I'm looking for a solve for rate decimal place rou...
# general
r
I'm looking for a solve for rate decimal place rounding when converting a Sales Order to an invoice. For example, the rate on the Sales Order is to 4 decimals places, but when it's converted to an Invoice, NetSuite rounds it to 3 which creates an issue if not manually reconciled. Looking to see how to resolve this through SuiteScript.
l
I recall we encountered similar problem many years back. quote doesn't match with sales order grand total. we sold software contracts with default 12 months, but sometimes they get co-termed with some odd months number resulting the total is off by a few cents. forgot how I fixed it. quick search says you can define decimal rounding precision. give that a try. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1397831.html#Currency-Decimal-Precision
r
Unfortunately the only values here are 0 and 2, where 4 is the desired result. I'm thinking about rigging a custom field to save from the SO Rate and carry the custom field over to the Invoice and having that write before record load.