What we do
Tools
Industries
Department
How we workLet's talk →
Home/NetSuite/NetSuite Saved Search
NetSuite

How a NetSuite Saved Search Is Built, Shared and Scheduled

Someone in finance wants every invoice more than 60 days past due, grouped by sales rep, in their inbox each Monday. That's one saved search: a record type, some filters, a few columns, a summary and an email schedule. No code. Below is each piece in the order NetSuite asks for it.

From a blank definition to a search people use

  1. 1

    Start a new search and pick the record type

    Reports Saved Searches All Saved Searches New

    Choose what you're searching: Transaction, Customer, Item and so on. You can also turn an advanced search into a saved one with Create Saved Search, or save a results page with Save This Search.

  2. 2

    Criteria: which records come back

    Add filters such as Type is Invoice, Status is Open, Due Date is before 60 days ago. Use Use Expressions for AND/OR logic and brackets, and joined fields (the customer's sales rep, the item's vendor) to filter on related records.

  3. 3

    Results: the columns, the sort and the summary

    List the fields to show and set a sort order. To roll rows up, set a Summary Type on the columns: Group on sales rep, Sum on amount remaining, Count on document number. Minimum, Maximum and Average work the same way. The search then opens on a summary you can drill into.

    Watch for: grouping on a field that's unique per row, such as document number. The summary then has as many lines as the plain list.

  4. 4

    Formulas for anything the field list lacks

    Pick Formula (Numeric), Formula (Text) or Formula (Date) as a column or a filter and write an SQL expression using field IDs, like days overdue from the due date. Aggregate and non-aggregate functions can't be mixed in one formula.

  5. 5

    Available Filters and Highlighting

    Available Filters puts dropdowns on the results page (subsidiary, date range) so one search serves several people. Highlighting colors rows that meet a condition, such as anything over 90 days in red.

  6. 6

    Audience: who can run it

    Tick Public only for searches with nothing sensitive in them. Otherwise name roles, groups or employees on the Audience subtab. Setting audience and email needs at least Create level of the Publish Search permission.

  7. 7

    Email: alerts, schedule, or both

    On the Email subtab you can send alerts when records matching the criteria are created or changed, schedule the results to go to set recipients, or both. Then Save & Run to check what it returns.

Searches that crawl, or show people too much

No date limit on a transaction search

How you'll know: It ran in seconds at go-live and now spins or times out.

Fix: Add a date range to the criteria or as an available filter, and set Sort By to columns you already return. NetSuite's own guidance for large result sets is to sort on the result columns.

Run Unrestricted left on without thinking

How you'll know: A sales rep can see totals for customers outside their territory.

Fix: Run Unrestricted shows results to users who couldn't normally see the underlying records. Turn it off unless that's the point, and narrow the audience instead.

Public searches holding payroll or margin data

How you'll know: A search with salary, cost or margin columns is ticked Public.

Fix: Untick Public and set the audience by role. Public means every user in the account can run it.

Too many searches in the menu

How you'll know: People can't find the search they need, and old copies keep getting edited.

Fix: Show in Menu caps at 100 saved searches. Retire the duplicates and put the live ones on a dashboard as a list or KPI portlet instead.

Saved search or SuiteAnalytics workbook?

Saved search

Lists, alerts and scheduled emails

  • Quick to build and familiar to most NetSuite admins.
  • Feeds list views, dashboard portlets, KPIs and reminders.
  • Can email results on a schedule or alert on record changes.
  • Can be loaded and run from SuiteScript.
SuiteAnalytics workbook

Pivots, charts and wider joins

  • Pivot tables and charts on top of a dataset.
  • Better for exploring relationships across record types.
  • Built for analysis on screen more than for driving lists and alerts.
  • Covered further on our NetSuite reports page.

If the output is a list someone acts on, or an email, use a saved search. If someone wants to slice and pivot, start a workbook.

When the results need to live outside NetSuite

There are three built-in ways out. Export the results page to CSV or Excel. Schedule the search to email its results. Or run it from SuiteScript: the N/search module loads a saved search by its ID and pages through the rows, which is how scripts reuse a search an admin already maintains.

The first two end in somebody's inbox. If the rows are meant for a data warehouse, a BI tool, a Google Sheet a partner reads, or another company's portal, someone still opens the file and imports it. n-frames builds the scheduled script or RESTlet that runs your saved search and writes the rows into that system directly, so the admin keeps editing the search in NetSuite and the feed follows. For record-level integration work, see our NetSuite API and SuiteScript pages.

Questions people ask

What is a saved search in NetSuite?

A stored set of criteria and result columns for one record type, which you and the people you share it with can run again any time. It can show as a list, a dashboard portlet or KPI, a reminder, or an email that goes out on a schedule.

Can I export a NetSuite saved search?

Yes. From the results page you can export to CSV or Excel. For a regular copy, set a schedule on the Email subtab and the results go to the recipients you choose. Getting the same rows into another system without anyone touching a file needs a script that runs the search.

Does NetSuite have a saved search API?

Yes, through SuiteScript. The N/search module can load a saved search by ID and return its results, and a RESTlet can expose those results to outside systems. NetSuite's SOAP web services can also run saved searches, though new integrations usually go the REST and SuiteScript route.

How is a saved search different from a SuiteAnalytics workbook or a report?

A saved search is best for lists, alerts and scheduled emails. A SuiteAnalytics workbook is built for pivoting, charting and exploring data across record types on screen. Standard reports cover financial statements and fixed layouts. Many accounts use all three, often with saved searches behind the dashboards.

Why would a business need help with saved searches if they are built for non-developers?

Building one rarely needs a developer. The help is needed around it: a search that's become too slow on years of data, a formula that needs logic SQL expressions in the builder can't hold, or results that have to reach another system on their own. n-frames writes the scripts and feeds that take a saved search the last step.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.