How Breadwinner handles Numbers, Discounts and Decimal places
2 min
In NetSuite, the following behaviors are observed for decimal fields:
NetSuite Item Price – Decimal Field
- The Standard Value field supports up to 18 characters in total.
- The decimal point (.) is counted as one character.
Handling rules:
- The minimum decimal length is 2, allowing the integer part to be up to 15 digits.
- The maximum decimal length is 8, limiting the integer part to 9 digits.
- The decimal portion is always restricted to a maximum of 8 digits, even if the integer part is only one digit.
Examples of valid values:
- 0.00
- 1.12
- 1.12345678
- 123456789.001
- 123456789012345.12
- 1.12345678
NetSuite Item Quantity – Decimal Field
- The Standard Quantity field supports up to 16 characters in total.
- The decimal point (.) is counted as one character.
Handling rules:
- The minimum integer length is 1, and the minimum decimal length is 0.
- The maximum decimal length is 5.
- The maximum integer length is 10.
Examples of valid values:
- 1
- 10
- 10.12
- 1234567890.12345
NetSuite Price Level Discount – Decimal Field
- Discount values must be between -1000 and 1000.
- The minimum integer length is 1.
- The maximum decimal length is 2.
Examples of valid values:
- 1999.99
- 1000.00
- -1000.00
Breadwinner presumes 2 decimal places for all numbers.