4 min read
Unlock the Full Potential of Saved Searches
Saved searches in NetSuite are often treated just as static reports, but they are actually the most powerful automation engine available to internal users without needing a developer. These features turn saved searches into active tools that do the work for you—alerting your team to critical events, highlighting what needs attention, and keeping data flowing where it’s needed without constant manual effort.Trigger-Based Email Alerts:
Instead of manually checking for unbilled usage or pending approvals, configure a saved search to trigger an email alert the moment specific conditions are met. You can route these alerts to the relevant accounting team member the second a high-value invoice goes overdue or a billing schedule hits an error.
Dynamic Highlighting:
In the "Results" tab of a saved search, use the highlighting feature to color-code rows based on criteria. This allows users to instantly spot critical action items on their dashboard, like highlighting inventory items in red when they drop below minimum thresholds.
Live Excel Web Queries:
For users who prefer working in spreadsheets, admins can check the "Allow Web Query" box under "More Options" on a report. This allows your team to export the report to Excel once, and the spreadsheet will automatically pull live data from NetSuite every time it is opened.
Optimize Sublist Rendering for System Speed
As an account matures, transaction history and item lists grow exponentially. Heavy records—like complex Bills of Materials (BOMs) or customers with massive transaction histories—can cause frustrating page load delays.
Navigate Sublist Loading:
Navigate to Home > Set Preferences > Optimizing NetSuite and enable Delay Loading of Sub Lists. This forces the data on each subtab to load only when that specific tab is clicked, drastically reducing the initial load time of heavy records.
Limit List Segments:
In the same preferences menu, reduce the "Number of Rows in List Segments" to 50. Loading lists in smaller chunks speeds up the interface significantly.
The Hidden Performance Tool:
If the system ever feels sluggish, double-click the Oracle NetSuite logo in the top left corner. This instantly reveals a hidden performance dashboard detailing your server, network, and client render times, allowing admins to instantly pinpoint the bottleneck.
Written by: Travis Perkins, Protelo's go-to NetSuite tips guru!
READ MORE NETSUITE TIPS, TRICKS & HOW-TO’S
- NetSuite How-to: Dynamic Fields on Saved Searches
- NetSuite Guidelines and Tips for Importing CSV Files
- Creating Custom Segments in NetSuite
- Get NetSuite Support & Services List
- Why Protelo?
NetSuite Questions?
We hope this guide was helpful in assisting you with saved searches. If you still find you need more help customizing NetSuite for your needs, our senior team of NetSuite consultants is available to answer your questions. Protelo is a NetSuite Partner and Solution Provider here to make your business better. Let’s talk!
We can help you to implement, service, and support NetSuite today.
Follow us on Social for NetSuite tips, tricks, and ERP fun:
YouTube, LinkedIn, X, Pinterest, Instagram, and Facebook