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
Live Updating Currency Fields with Scripting
I've got 8 fields on a project that I would like to do some live math scripting on. By that I mean I would like them to update as they leave the field.
These fields are:
Amount (custentity24) - Currency type
MD Labor (custentity153) - Currency Type
Temp Labor (custentity154) - Currency Type
Union Labor (custentity155) - Currency Type
Total Labor (custentity156) - Currency Type
Total Costs (custentity157) - Currency Type
Profit (custentity158) - Currency Type
Labor Percentage (custentity159) - Percent Type
What I would like to do is to have the Total Labor field sum MD, Temp, and Union Labor. Profit should take Amount minus Total Labor and Total Costs. Labor Percentage should be Total Labor divided by Amount.
0