Hello everyone,
We have a business requirement where a single customer order can contain approximately 13,000 line items.
We understand the documented transaction limits:
- UI: 500 lines per transaction
- CSV Import / SOAP Web Services: 5,000 lines per transaction
- Transactions with more than 1,000 lines may also impact performance or cause timeouts.
- The display limit for transaction sublists is 10,000 lines.
Our requirement is to understand the best-practice NetSuite design for this scenario.
For example, if we have one customer order with 13,000 items, what would be the recommended approach?
- Splitting the Sales Order:
Should we split the order into multiple Sales Orders (for example, 5,000 + 5,000 + 3,000 lines) and maintain a common Customer PO / External Reference / Parent Order ID so that all Sales Orders can still be identified as one business order? - Contract / Parent Record:
Is there any standard NetSuite functionality, such as a Contract or another parent/master record, where we could maintain the overall 13,000+ items and then create multiple Sales Orders against it? In other words, is there a recommended way to represent one business order containing 13,000+ items while the actual Sales Orders are split because of transaction line limits? - Fulfillment and Invoicing:
If we split the 13,000-line order into multiple Sales Orders, each Sales Order will eventually have its own Item Fulfillment and Invoice, potentially containing the same large number of lines. What is the recommended approach for handling the Fulfillment and Invoicing process in this scenario? Are there any additional line limits or performance considerations we should be aware of when these Sales Orders move through Fulfillment → Invoice? - Working with a Large Sales Order After Creation:
If we create a 5,000-line Sales Order through CSV/SOAP, can it still be viewed in the NetSuite UI? Also, if we later need to make a small change—for example, update only 10 lines—would that change need to be performed through CSV/SOAP, or is there a supported way to edit the transaction through the UI?
We are mainly looking for the recommended architecture/best practice for handling this type of high-volume order rather than simply trying to bypass the transaction line limit.
Any guidance or experience with similar high-volume Sales Orders would be greatly appreciated.