Scenario
Error above is encountered upon saving transaction records when a workflow Set Field Value Action on the sublist action group is used on any sublist fields with field type = Currency and the value is being set using a formula.
For example, Amount on the sublist is being set by workflow using formula. The formula is the sum of val1 = 100.002 and val2 = 100.003 and is using the formula Amount = {val1-val2} . When manually calculated, the sum is 200.005 and rounded of as 200.01. But Netsuite will round it separately and will read the values as val1 = 100.00 and val2 = 100.00 which will give a sum of 200.00 causing a difference of 0.01.
Solution
- The reason for the error is the value returned by the formula is returning 3 or more decimal places or that the total amounts are not in balance.
- To successfully save the transaction, you would need to round the the sum of the formula being used on the Set Field Value action. Based on the sample on the scenario, the formula would be Amount = ROUND (({val1-val2},2)).