I’m making a custom view to pull the labor class from Routings to show in Customer Order Lines, it functions by checking the first number of the labor class and giving it a 10, 40, 50, or using the site number from COL otherwise based on the result. The issue is if there is no corresponding entry in Routings then it would default to the site instead, it will just show up as null. Is there a way to force IFS to use the source field? Here is the main code I have in the SELECT custom field.SELECT CASE WHEN SUBSTR(labor_class_no,1,1) = '1' THEN '10' WHEN SUBSTR(labor_class_no,1,1) = '4' THEN '40' WHEN SUBSTR(labor_class_no,1,1) = '5' THEN '50' WHEN :catalog_type = 'Non inventory part' THEN :contract ELSE :contract END FROM ifsapp.routing_operation where part_no = :part_no and contract = :contract and routing_revision = (select MAX(routing_revision) from ifsapp.customer_order_join left outer join ifsapp.routing_operation where part_no = :part_no and contract = :contract and alternative_no =
I have created a custom field for MRBs that uses enumeration with two values (Internal and Customer) and set it to have a default value of Internal.However, when creating a new MRB the field does not get a default value and is instead empty.Is there something I am missing?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.