Currency Decimal Precision

The Currency Precision field on the currency record is read-only. If you need to change this field to a list through which you can change the precision from zero or two, contact NetSuite Customer Support. To view or edit a currency record, go to Lists > Accounting > Currencies and click the Name link.

The decimal precision of a currency is displayed in the Currency Precision field on the Currency record. For example, the Currency Precision value for the Default Locale United States (English) is 2, for two decimal places.

For the Japan (Japanese) local the Currency Precision value is 0. Therefore, you cannot edit the Currency Precision. If you need a different decimal precision, contact NetSuite Customer Support for assistance. The only values supported are 0 and 2.

Some currencies require the use of integers, without decimal fractions. For example, Japanese yen are usually displayed as ¥123, but not as ¥123.45. For this reason, customer-facing documents must display currency amounts in yen using integers. The NetSuite user interface generally displays these currencies as integers. 

If the base currency of your company or subsidiary permits the use of decimal fractions, NetSuite displays amounts from foreign currency transactions in base currency amounts using two decimals places. Your customer can see the total amount of a transaction in a zero-precision foreign currency as an integer, but your company's records display the translated, base-currency amounts using two decimal places. 

For example, a company can use U.S. dollars as its base currency and price an item at $123.45 per unit. If the exchange rate is 93.4857 Japanese yen to the U.S. dollar, the line item amount displayed on an invoice to a Japanese customer for ten units of the item is ¥115,408, not ¥115,408.10. However, NetSuite displays the transaction amount for the ten units on the U.S. company's books, as $1,234.50. 

Values in report results are rounded to the base currency precision. This rounding applies to currency values and non-currency values including formula column values.

Currency decimal precision is used for inventory costing calculations to maintain consistency between inventory costing and reporting. Values in report results are rounded to the base currency precision. This rounding applies to currency values and non-currency values, including formula column values.

Currencies Usually Expressed as Integers

NetSuite displays the following currencies as integers, without using decimal fractions.