ANS-0957 · INVENTORY & ITEM MANAGEMENT
What Are NetSuite’s Recommended Line Item Limits for Transactions?
Understand the recommended maximum number of line items for various NetSuite transaction types, including UI, CSV import, and Web services, to optimize system performance.
Short answer
NetSuite recommends specific line item limits for transactions to ensure optimal performance. General transactions via UI are limited to 500 lines, while CSV import/Web services allow up to 5,000 lines. Journal entries have higher limits: 1,000 for UI and 10,000 for import/Web services. Adhering to UI limits is crucial if transactions will be edited in the UI post-import.
Scenario
Users frequently encounter performance issues or system limitations when processing NetSuite transactions with a large number of line items. This often leads to questions regarding the maximum recommended line item counts for different transaction entry methods, such as direct user interface input, CSV imports, or integrations via Web services.
Solution
NetSuite provides recommended maximum line item limits for transactions to maintain optimal system performance. Exceeding these guidelines may lead to performance degradation. The limits vary depending on the transaction type and the method of submission:General Transactions (e.g., Sales Orders, Purchase Orders, Transfer Orders):User Interface (UI): 500 linesCSV Import or Web Services: 5000 linesJournal Entries:User Interface (UI): 1000 linesCSV Import or Web Services: 10,000 linesIt is important to note that even if transactions are initially imported via CSV or Web services, if there is an intention to work with or edit these transactions within the NetSuite user interface at a later stage, it is strongly recommended to adhere to the lower UI-specific line item limits rather than the higher import limits. This practice helps prevent potential performance issues when interacting with the transaction record in the UI.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support