Hello. I'd like to know if there is any standard w...
# general
b
Hello. I'd like to know if there is any standard way to implement 4 decimal places for currency in transactions in NetSuite. NetSuite doesn't allow other than 0~2 decimal places for USD but we may need 4 decimal places. Could someone tell me how to do that generally please? Like how to manage the total difference due to that decimal places please? Any help would be appreciated
m
Not possible but you can create a customization to have fields in which you enter the amounts with 4 decimal places and one script will populate the mandatory field like amount , gross amount etc with 2 decimal places. The goal is to have the custom amounts with 4 decimal places on financial reports
l
i believe you have to setup a ticket to ask for that to change your decimal precision to 4 places.
b
NetSuite documentation says it does not support 4 decimal. just 0 ~ 2 and it can be changed only after create a ticket
l
what’s the use case - is a country requirement or is it something that you guys prefer - try a ticket regardless as an exception, copy your account manager in it.
b
l
and if you had to work around it with a customization, then you’d need to back calculate into it - so you’d have to use quanity divided by amount and then store with 4 decimals iin a field.
b
yes I think so
l
what’s the use case? why do you need 4 decimals?
b
I don't know. just the client complains about issue due to rounding
l
ahhhhh…..ugh…….I know for fuel companies, the price goes to 3 decimals from what i remember, so try the netsuite ticket and explain that the rounding is needed for 4 for business purposes.
b
I see
Thank you