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.
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.
Filterselect the field(s) you would like to filter the search on.
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.
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.
Summarysubtab on the
Criteriasubtab becomes available for use.
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.
Highlight If… and
Highlight If… (Summary) tabs allow you to set the criteria for returned data within your NetSuite saved search.
Conditionheader to open a window to specify the criteria for the highlight. This window functions in the same way as the
Background Color, or
Boldfor the results of the condition.
Filterthat you would like to appear on the screen when you have run the saved search.
Show in Filter Regionfor it to appear at the top of the report.
Show as Multi-Select
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.
Reach out and let us show you all the ways NewGen is committed to your success.