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!
Transaction column formula
Hello all,
I want to show the total net weight in every transaction line.
Can anyone remind me how to do a simple formula to do the following in a transaction column?
I tried the following but it did not work
{quantity})*{custcol19}
Did not give any results
and
NVL({quantity}, 002)*NVL({custcol19},010)
This only gave the result 20 which means it is not working
I have the following fields,
Quantity (NS standard column)
Net Weight (custcol119 Custom Integer number sourced from Item record, which does dhow the item net weight)
Total line net weight (Custom transaction column field (set to Integer number to match Net Weight)