Values changing due to When-Validate-item Trigger
535237Nov 3 2009 — edited Nov 6 2009Hello,
I am developing a Form6i. I have a customer_name lov field. I have when-validate-item trigger to the cutomer name field.
When i select the cutomer_name i have other fields which will derive depending on the customer_name like payment_term, Sales_rep, Price list and so on.
The issue i have is Ex:
When i select Customer_Name = 'ABCD'. Payment Term field will be driven using some code from when_validate_item trigger and populate Payment Term = Net 45.
When i change the Payment Term = Net 30 and Save the Form, it will come back to Net 45 and saves.
I know this is because of the when-validate-trigger fires again at Form level.
I want to change the payment_term to change only when customer_name is changes. Kind of Same funtionality as Oracle Order Entry Form
How do i over come this, can any one please help.
Thanks.