Sunday, June 23, 2019

Standard Fields in NetSuite that you can use Mathematical Operations (e.g. +, -, x, ÷, etc.)

There are fields in NetSuite where you can use Mathematical Operations like addition (+), subtraction (-), multiplication (x) and division (÷). This is useful when customer wants to charge the customer more than the usual fee, etc. or if they need to compute first to get the total amount they want to enter or charge the customer.

The fields are but not limited to the following:

1.    Amount

2.    Shipping Cost

3.    Handling Cost

4.    Exchange Rate

5.    Estimated Extended Cost

Note: If using multiple or different operations on the field (i.e. 1+5*2), make sure to add a parenthesis "()" over the numbers so you are sure to get the correct result. On the example above if you don't use parenthesis it will give you 11 as the result however if you have separated the formula by parenthesis (i.e. (1+5)*2) it will give you 12.

No comments:

Post a Comment