ANS-0049 · SAVED SEARCHES & FORMULAS
How to Limit NetSuite Saved Search Results to the Top 10 Records
Configure a NetSuite saved search to display a specific number of top records by adjusting result settings and sorting preferences.
Short answer
To limit NetSuite saved search results, navigate to the Results tab. Enable 'Run Unrestricted' and set the 'Max Results' field to 10. Crucially, verify that the search's sorting preferences are correctly configured to ensure the desired top records are displayed.
Scenario
Users often need to restrict the number of records returned by a NetSuite saved search to focus on the most relevant data. This is particularly useful when analyzing top performers, recent transactions, or other prioritized lists. The challenge is to configure the search to display only a specific, limited set of results, such as the top 10.
Solution
To limit a NetSuite saved search to display only the top 10 results, navigate to the Results tab of the saved search definition. On this tab, enable the 'Run Unrestricted' checkbox. Next, in the 'Max Results' field, enter the value 10. It is essential to ensure that the sorting preferences for the search are correctly configured to guarantee that the desired top records are returned in the result set.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support