Hello, I’m quite new using IFS Applications, and I wanted to put a custom field at Purchase Order with the Sales Order (which originated the PO). I was able to create a custom field retrievind the Tree_id from the view SUPPLY_ORDER_ANALYSIS and was trying to create anoter custom field usind the customized field above in order to retrives the sales order number, but it’s not working. The code to retrieve the Tree_ID:select Tree_id from SUPPLY_ORDER_ANALYSIS where Order_Ref1 = :ORDER_NO The field at my Purchase Order screen: The code to retrieve de Sales Order number (not working):select Order_Ref1 from SUPPLY_ORDER_ANALYSIS where Tree_id = :CF$_TREE_ID and Node = '0' When I try to synchronize the below error appear (Error: ORA-01403: No Data Found) Anyone know how to workaround this? Thank you.
Already have an account? Login
No account yet? Create an account
Enter your 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.
