ANS-0182 · SAVED SEARCHES & FORMULAS
How to Optimize NetSuite Performance with Many Inventory Locations
Organizations managing numerous inventory locations in NetSuite can experience performance degradation in saved searches, reports, and item record loading.
Short answer
To mitigate performance issues with a large number of NetSuite inventory locations, optimize saved searches and reports to limit results. Additionally, improve item record load times by configuring sublist loading preferences. The default location limit, which is 100 when Multi-Location Inventory is enabled, can be increased to accommodate extensive dealer networks.
Scenario
Organizations utilizing NetSuite's Advanced Partner Center for inventory management across a large network of dealers, potentially exceeding 250, often require increasing the default location limit (which is 100 when Multi-Location Inventory is enabled) to accommodate all dealer locations. When managing hundreds of inventory locations (e.g., over 400), users may encounter significant performance issues, including saved searches and reports timing out due to the extensive result sets.
Solution
Performance issues stemming from a high volume of inventory locations can be mitigated through several strategies. First, optimize saved searches and reports by carefully crafting them to limit results to a smaller, more relevant subset of locations. This reduces the data processing load and helps prevent timeouts. Additionally, item record load times can increase dramatically with a large number of locations. To overcome this, it is recommended to manage the loading behavior of subtabs. While the direct 'moving' of subtabs to different parent tabs is not explicitly supported, optimizing their display and loading can improve performance. A crucial step is to set the 'Delay Loading of Sublists' preference to 'Checked' within General Preferences. This ensures that sublist data, such as location details on the Purchasing/Inventory tab, only loads when explicitly accessed, thereby improving the initial load times for item records.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support