Currency Field Limitations

When you work with currency fields in NetSuite, the fields may not calculate the correct value for large decimal numbers correctly. This is related to the limitations of floating-point numbers in computer science.

The maximum whole number that can be represented accurately is 9,007,199,254,740,991. However, for decimal numbers, when a number has 15 or more digits before the decimal point, rounding errors can occur. For example, 142,325,911,132,191.64 might be incorrectly rounded to 142,325,911,132,191.62.

With more digits before the decimal, the system may truncate the decimal part entirely, for example 14,232,591,113,219,174.64 might be rounded to 14,232,591,113,219,174.

Related Topics

General Notices