Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Bypass rate change on quantity update
I currently have a small script that checks the value of a custom check box on the line item sublist of my sales orders and if the box is checked it enables (unlocks) the rate field to allow for user editing.
All works well, the user updated rate is used to calculate the amount field. The problem comes if the user changes the quantity after changing the rate. Netsuite immediately changes the rate back to the default value.
Is there any trigger or function I can use that will effectively say "on quantity update, if checkbox is true, leave rate as is"? if the box is unchecked it already resets the rate to the default so I don't care what it does in that case.