Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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.
Tagged:
0