- Home
- NetSuite automation
- NetSuite reporting
A NetSuite saved search is a report you build once and run again on a schedule or by API
A saved search is a search you set up once and run again by name. Oracle says its results help with reporting, tracking, business analysis and decision-making. You can share it, email it on a schedule, show it as a dashboard KPI, and run it through REST web services or an AI client.
A saved search keeps a report you will run again
A saved search is a search with fixed filters and columns, stored under a name. Oracle calls it “a reusable search definition”. It names four uses for the results: reporting, tracking, business analysis and strategic decision-making. Anyone with the Publish Search permission can share one with other users.
Saving is what opens the extra uses. Oracle’s saved search page lists four of these; the fifth comes from its SuiteFlow help:
- Email. Results go out on a schedule, when they change, or both, and nobody has to rerun the search.
- KPIs. A summary value from a saved search can show on a dashboard as a custom KPI (key performance indicator).
- Views. The results can replace the dashboard view, list view or sublist view of a record type.
- Templates. An administrator can set up saved searches as starting points that others adjust.
- Workflows. A scheduled workflow runs on each record a saved search returns. Our NetSuite automation page covers that.
How to make a saved search, in five steps
- Go to Reports > New Search and choose the record type you want to find.
- Check the Use Advanced Search box.
- Set filters on the Criteria subtab and columns on the Results subtab.
- Click Create Saved Search. The button sits on every simple and advanced search page.
- Name it, set who can see it, and save.
Oracle says advanced search can use formulas with SQL expressions, filter by related records, sort, and group results with summary totals you can filter on. Once a search has run, its results export as .csv, .xlsx or .pdf files.
Where to find saved searches, and who can open them
Some saved searches have their own entry under Reports > Saved Searches. If you know part of the title, type se: and that text into Global Search. The full list opens from any of three paths:
- Reports > Saved Searches > All Saved Searches
- Lists > Search > Saved Searches
- Transactions > Management > Saved Searches
You can run a search if it is public, or if its audience names you, your role, department, subsidiary or group. Editing is narrower. Oracle allows it when the search is marked Allow Audience to Edit, when you own it, or when you are an account administrator.
One trap catches people on accounts with Advanced Employee Permissions. If your role cannot see a field used as a criteria filter, NetSuite drops that filter from your results. Two people running the same search can then see different rows.
Scheduled emails and KPIs have hard limits
Email has the tightest limits. An administrator, or a user with the Create level of Publish Search, can turn it on. Then:
Scroll the table sideways to see every column.
| Rule | Oracle’s limit |
|---|---|
| Email size | Cut off above 5MB or 10,000 rows, with a note in the email |
| Format | CSV, the most compact; Excel and Tableau Workbook also work |
| Scheduled runs | One at a time per user, up to 200 at once per account; the rest wait |
| Inactive search | Its schedules stop, and no email goes out |
| Release Preview | Production schedules do not run there |
| No results | Turn off Send if No Results to skip empty emails |
Dashboards have limits of their own. NetSuite ships over 75 standard KPIs. A Key Performance Indicators portlet shows up to ten custom KPIs, a dashboard holds up to three KPI meters, and you can add up to five Trend Graph portlets.
A saved search must meet three rules to work as a custom KPI across date ranges. It needs exactly one summary field on the Results subtab. It needs no date filter on the Criteria subtab. And it needs a date field set as an available filter.
Long searches: persist the results to a CSV file
When a search times out, persist it. NetSuite then runs it in the background for up to 3 hours and saves the results as a CSV file. The file stays for 7 days, then it is deleted. A search still marked Pending after 24 hours turns to Failed.
Administrators can persist searches, and they may let other roles do it too. To allow a role, add the Persist Search permission to it.
Four formula rules, and the one that changed old searches
A formula can return different results from one user to the next. Oracle’s formula help sets four rules:
- Formula (Text) shows plain text only. Oracle made this change for security, and it is the one that alters searches that already worked. Move such fields to Formula (HTML).
- Use internal field IDs. A value in a formula may be translated for a user in another language, and the results then change.
- Do not mix SQL function types. One formula cannot combine aggregate and non-aggregate functions.
- No encrypted fields. Fields such as credit card numbers cannot go in a formula. Oracle says they cause invalid expression errors, because SQL cannot decrypt them.
The execution log shows who ran a search, for 60 days
Each saved search keeps an Execution Log subtab. It lists every user who ran or exported it in the past 60 days, with the date and time. Scheduled runs, script runs and dashboard portlets count too. To see it you need to be an administrator or hold the Create level of Publish Search. Reports have no such log; Oracle keeps it for saved searches only.
Without that permission, the Saved Searches list still shows Last Run By and Last Run On for each search. Sort by Last Run On to find searches nobody has run in months.
SuiteAnalytics Workbook runs on a different data model
SuiteAnalytics Workbook is on by default, and Oracle’s search pages carry a note pointing readers to it. But it reads the analytics data source, not the one saved searches use. Matching an old search may take different fields, record types, joins or formulas. Some calculated fields were never carried over at all.
Oracle offers a spreadsheet, TransactionMapping.xlsx, that maps the transaction record between the two. Rebuild one search, compare the totals, and only then retire the old one.
Run saved searches from outside NetSuite: REST and MCP
REST web services can list and run saved searches. They cannot build or change them.
Scroll the table sideways to see every column.
| Job | How |
|---|---|
| List the searches your role can see | GET /services/rest/query/v1/savedsearch |
| Run one search | GET /services/rest/query/v1/savedsearch/[savedSearchId]/result, by internal ID or script ID |
| Long runs | Either call can run asynchronously |
| Not possible | Building or changing a search, or overriding how it filters and sorts |
An AI client can reach the same searches through Oracle’s MCP server, covered on our NetSuite MCP page. The tool ns_listSavedSearches returns each search’s ID, title, record type and public setting. ns_runSavedSearch runs one, with an optional range of rows. For a search on a standalone search type, one with no matching record type, the call must name that type. Both tools need the Perform Search permission at View level.
Oracle’s advice for AI clients favors these searches. Have the model run a saved search or a report before it writes its own SuiteQL query. And do not use SuiteQL for financial reports, because NetSuite’s standard reports apply business rules SuiteQL cannot. Oracle’s report tools have gaps too: they do not support accounting periods, and they may return empty values for custom reports split by custom segments.
NetSuite’s own AI for reports, and where an agent fits
Narrative Insights uses generative AI to write short summaries of supported NetSuite records and reports. Oracle puts one summary at 5 to 200 AI Units. Oracle lists it as available everywhere, in every language NetSuite supports. It cannot be turned on for healthcare customers with a signed BAA (a HIPAA business associate agreement). Oracle’s Companion SuiteApp also has Financial Prompts that turn standard reporting questions into repeatable analyses for AI clients.
A custom agent fits when a result has to trigger work. Software can call the saved search endpoint on a schedule, read the rows, and draft the follow-up for a person to approve. The search stays the single place where the logic lives.
Our team has taken NetSuite live. The first call is free.
Questions
What is the purpose of a saved search in NetSuite?
To keep a search you will need again. Oracle calls it a reusable search definition with its own filters and columns. Oracle says the results support reports, tracking, business analysis and decisions. Once saved, it can email its results on a schedule, act as a KPI on a dashboard, replace a record's list view, or start a scheduled workflow. With the Publish Search permission, you can share it with other users.
How do you find saved searches in NetSuite?
Three ways. Some searches have their own entry under Reports > Saved Searches. If you know part of the title, type se: and that text into Global Search at the top right. For the full list, go to Reports > Saved Searches > All Saved Searches. The same list also opens from Transactions > Management or Lists > Search. You only see searches that are public or whose audience includes you, your role, department, subsidiary or group.
How do I create a saved search in NetSuite?
Go to Reports > New Search and pick the record type you want to find. Check Use Advanced Search. Set your filters on the Criteria subtab and your columns on the Results subtab. Then click Create Saved Search, name it and save. Advanced search adds formulas with SQL expressions, filters on related records, sorting and summary totals.
Why is my NetSuite saved search email cut off?
Because it went past the email limit. Oracle cuts saved search emails that are over 5MB or have more than 10,000 rows, and the email carries a note saying so. Send the results as CSV, which Oracle says is the most compact format. For bigger result sets, persist the search instead: it runs in the background for up to 3 hours and saves a CSV file you can download.
Can I run a NetSuite saved search through the API?
Yes, through REST web services. One endpoint lists the saved searches your role can see. Another runs one search by its internal ID or script ID, and either call can run in the background. REST cannot build or change a saved search, and it cannot override how the search filters and sorts. Build the search in NetSuite first, then call it.
Should we move our saved searches to SuiteAnalytics Workbook?
Only where Workbook adds something you need. Workbook is on by default, but it reads a different data source. Oracle says matching a saved search may take different fields, record types, joins or formulas, and some calculated fields were never carried over. Oracle offers a spreadsheet, TransactionMapping.xlsx, that compares the transaction record type in saved searches with the one in Workbook. Test each search before you switch off the old one.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- Oracle NetSuite Help: Saved SearchesRead 18 Nov 2026
- Oracle NetSuite Help: Accessing a Saved SearchRead 18 Nov 2026
- Oracle NetSuite Help: Simple and Advanced SearchesRead 18 Nov 2026
- Oracle NetSuite Help: Saved Search EmailRead 18 Nov 2026
- Oracle NetSuite Help: Enabling Saved Search Scheduled EmailRead 18 Nov 2026
- Oracle NetSuite Help: Persisting Search ResultsRead 18 Nov 2026
- Oracle NetSuite Help: Custom KPIsRead 18 Nov 2026
- Oracle NetSuite Help: Formulas in SearchesRead 18 Nov 2026
- Oracle NetSuite Help: Auditing Saved Search ExecutionRead 18 Nov 2026
- Oracle NetSuite Help: Analytics Data Source ChangesRead 18 Nov 2026
- Oracle NetSuite Help: Using Saved Search in REST Web ServicesRead 18 Nov 2026
- Oracle NetSuite Help: ns_runSavedSearchRead 18 Nov 2026
- Oracle NetSuite Help: Report ToolsRead 18 Nov 2026
- Oracle NetSuite Help: Generative AI Feature AvailabilityRead 18 Nov 2026
Bring the saved searches your team runs by hand
The first call is free. Bring the saved searches and reports your team exports every week, and we can talk through which ones could run on a schedule, through the API or from an AI client.