Hi, I want to add a custom field to the Purchase Requisition Lines view, which is based on two criteria to make the search unique.I've made a Read Only Custom Field with one of the key variables, but make it work for each line I need to add a second variable to my select statement. Problem is: I get an error when I want to finish creating the Custom Field.This is the field I want to add to Purchase Requisition Lines:Operation_DescriptionThis is what I got so far. SettingsSelect Statement:SELECT Operation_Description FROM Shop_Order_Operation WHERE Order_No = :Demand_Order_No AND Outside_Op_Item = :Part_No This is the Error that appears after clicking on ‘Finish’: And these are the results when I only use the Shop Order number as criteria:1) Description of the first line on de Shop Order 2) second criteria to make search uniqueDoes someone know what I am missing here?
Hi all,As i said i created a matrix lobby. But i see numbers without comma seperator at the element designer. So i tried to use to_char(value,’999,999,999,999’) format and that was success at the data source designer. But when i turn the element designer that changes has not processed and comma seperator doesnt work at element designer for some reasons.Any usefull idea about this?Best Regards.with seperator at data source without seperator at element designer
Hello everyone, I am not able to join part_catalog and technical_class_reference as the key_value in technical class reference includes after the part_no this character ‘^’. select a.part_no, b.technical_class from Part_catalog a INNER JOIN TECHNICAL_OBJECT_REFERENCE b ON a.part_no = b.key_value I tried to get rid of the last character of key_value which did not work: select pc.part_no, tor.technical_class from Part_catalog pc INNER JOIN TECHNICAL_OBJECT_REFERENCE tor ON pc.part_no = (select SUBSTR(tor.key_value, 0, LENGTH(tor.key_value) -1)) I never had such an issue in IFS. Any idea how to link these views? Thanks a lot! !--[endif]-->!--[if>![endif]-->!--[if>
Hi How do customer connect to supplier.
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.