Scenario
User is entering a Sales Order or Invoice with a Quantity and Invoice Quantity of 99,999,999,999 but receives an error preventing them from saving the record.
Cause
The system throws the following error:"Invalid number (must be between -9,999,999,999 and 9,999,999,999)"
This is because NetSuite’s standard number field for quantity is limited to 10 digits, and any value beyond this range exceeds the allowed input. Attempts to configure a higher maximum quantity at the item level do not bypass this system limitation.
Solution
To work around this limitation:
Step 1: Split the total quantity across multiple line items or transactions, ensuring each quantity is below the 10-digit limit.
Step 2: Use the Memo or Description field on the line or header to indicate the total intended quantity (e.g., "Part of total 99,999,999,999units").
Step 3: Save the record once quantities are within the acceptable range.
This workaround allows the record to be saved without violating system constraints.
Conclusion
While NetSuite cannot currently accommodate quantities exceeding 10 digits in a single field, users can continue processing large orders by breaking them into manageable entries and using memo fields for clarity. For long-term solutions, consider submitting an enhancement request or working with your NetSuite Administrator on potential automation or custom scripting.
-----
If you find this information useful, let us know by reacting or commenting on this post!
