When you’re looking to gain business intelligence from your data, NetSuite saved searches are the answer. They’re able to provide real-time information on any record in the system, filtering and matching on the data that is most important to you either out of the box or via custom saved searches you create.
Saved searches are a powerful tool and have a huge role in analytics in the system – even with the introduction of the newer NetSuite SuiteAnalytics tool.
NetSuite Saved Search Creation
Custom NetSuite saved searches can be created from scratch based on a specific record type in NetSuite. To create a new saved search, select
Reports > Saved Searches > All Saved Searches > New. Then choose the record type which your search will be based on. Once you’ve named your search and checked the appropriate checkboxes, you’re ready to enter the options for the search.
Criteriasubtab allows you to select what information must be true about the record for it to be included in the search.
Resultssubtab allows you to select which fields in the record you’d like to see data for. There are default fields already selected for you – you can add, remove, and rearrange fields as required.
Highlightingsubtab allows you to highlight records that conform to specified criteria.
Available Filtersis where you can specify what you’d like to be able to filter on once the search has been run.
Rolessubtabs, if available for your role, allow you to select who has access to the search if you’d like to limit the availability.
The user who runs the search must have access to the data sets it contains in order to see the results. Once you’ve defined your search criteria, you can
Preview the NetSuite saved search to verify that it returns the results you are looking for prior to clicking
Save. You can also select
Save and Run to save the report and have it immediately run.
The Criteria Subtab
- In the
Filterselect the field(s) you would like to filter the search on.
- A new window will pop up with the option for that filter, which vary based on field type. For example, a true/false field with return the options “both”, “yes”, or “no”. Choose the appropriate filter settings and click
- Repeat these steps for as many filters as you need for the search.
But wait, there’s more! Select the
Use Expressions checkbox on this tab to allow the use of formulas.
NOTallows you to specify that you would like records that do not meet the criteria listed.
AND/ORallows you to select AND or OR as your search condition for multiple filters with the use of
Parensto enclose the conditions in parenthesis.
The Results Subtab
Data returned in the NetSuite saved search can be modified in the Results tab:
Summary Type– Summarize the data based on Group, Count, Sum, Minimum, Maximum, or Average.
- When this is used, the
Summarysubtab on the
Criteriasubtab becomes available for use.
- When this is used, the
Function– Select a built-in NetSuite function to apply to the results, such as % of Total or Round to the Nearest Hundredth.
Formula– When a formula field is selected as the field type, enter the formula to be calculated using NetSuite Tags. This can be as simple as basic arithmetic or as complex as a CASE statement, depending on your needs.
Custom/Summary Label– A custom title can be given to any field in the search and is especially helpful for calculated fields.
Don’t forget to choose the Sort By order for your data – at least one field is necessary. The Output of the saved search can be changed to Report, Grid, or Graph, if desired.
The Highlighting Subtab
Highlight If… and
Highlight If… (Summary) tabs allow you to set the criteria for returned data within your NetSuite saved search.
- Click the Expand button on the right side of the
Conditionheader to open a window to specify the criteria for the highlight. This window functions in the same way as the
- Choose an
Background Color, or
Boldfor the results of the condition.
The Available Filters Subtab
- Select a
Filterthat you would like to appear on the screen when you have run the saved search.
- Check the box under
Show in Filter Regionfor it to appear at the top of the report.
- If you’d like to be able to select multiple results from this filter, check the
Show as Multi-Select
Overall Saved NetSuite Saved Search Management
Edit a saved search, you must be an administrator or have permissions to publish search. The owner must also have given
Allow Audience to Edit privileges, which will allow you to modify the search and keep the same name or save it with a different name.
Delete a saved search, you must either be the owner of the search or an administrator. The delete button is only available when the correct permissions are in place.
Closing Thoughts on NetSuite Saved Searches
- NetSuite provides thorough documentation for working with saved searches in it’s official NetSuite Search Guide PDF documentation.
- For even more NetSuite saved search tips check out this video on NetSuite’s official YouTube channel.