How to Create and Manage Saved Searches in NetSuite: A Beginner’s Guide
Start With One Question You Need to Answer
Which invoices did we issue this month? Which customers need a follow-up? A saved search gives your team a repeatable way to find those records. Oracle describes saved searches as reusable definitions with filters and display choices. You can run them again without rebuilding the search.[8]
We conducted a review of Oracle’s saved-search documentation for this guide. Our analysis focuses on a small first search that you can check before sharing. The invoice example below is a suggested practice exercise, not a test run in a customer account.
1. Create a Private Practice Search
Oracle’s starting path is Reports > Saved Searches > All Saved Searches > New. Choose Transaction and enter a clear title, such as Finance | Invoices This Month | Draft. Leave Public unchecked while you build.[1]
Menus and fields can vary with your role and account setup. If you cannot reach this page, ask your administrator to check your search and record access. Begin with records you are allowed to view.
2. Set Criteria: Which Records Should Appear?
Use Criteria > Standard to add the filters below. This example finds invoices dated this month, whether paid or unpaid. It is not an overdue-invoice list or a revenue report.
| Filter | Choose | Purpose |
|---|---|---|
| Type | Invoice | Keep the exercise focused on one transaction type. |
| Date | Within this month | Use a small, relative date range. |
| Main Line | Yes / True | Start with transaction headers, rather than item lines. |
Oracle recommends Main Line = True to avoid multiple transaction lines in a basic transaction search.[2] Keep this first search free of joined fields from other records. A join can change the number of rows you see. If you later need item detail, build a separate search and check its row count again.
3. Choose Results That Are Easy to Check
On Results > Columns, try Date, Document Number, Name, Status, and Amount. Remove columns you do not need. Sort by Date. Oracle documents column order, labels, and sorting as Results settings.[1]
For this exercise, keep one row per invoice and skip formulas and summary types. Open a few invoices and compare the search values with the records. If your account uses multiple currencies, check the currency basis before adding or comparing amounts. A list of invoices does not automatically make a valid financial total.
- Pick an invoice that should appear and confirm that it does.
- Pick one dated outside this month and confirm that it does not appear.
- Check that one invoice does not show several unexpected rows.
- Confirm what each amount means before anyone uses it in a decision.
4. Add a Filter People Can Use
Criteria define the search’s base scope. Oracle says Available Filters add optional controls that viewers can use to narrow the results. For example, add Status and select Show in Filter Region to offer a visible status selector.[3]
Keep the options simple. A teammate checking paid invoices should be able to narrow this month’s list without editing the saved definition. An optional filter does not replace the base criteria: choosing a status will still leave the search limited to this month.
5. Preview, Save, and Repeat Your Checks
Click Preview to inspect the output before saving. When it looks right, choose Save & Run. Oracle distinguishes previewing from saving the definition.[1] Give the saved version a clear name before handing it to a teammate.
Use this five-step flow whenever you build another search. If a check fails, return to the filters or columns and preview again.
6. Share With the Right Audience
Oracle’s Audience guidance says administrators and users with at least Create-level Publish Search permission can choose who can run a search. By default, the owner and administrators can edit it; Allow Audience to Edit extends that access. Oracle advises against making sensitive searches public.[4]
Choose the smallest useful audience and ask a teammate to check the search with their normal role. Review both the records they can see and the fields shown in the output. Do not enable broad access simply to work around a missing result.
NIST defines least privilege as limiting access to what someone needs for their work.[5] Applied here, that means sharing a finance search with the people doing that task and granting editing access only when they need to maintain it.
7. Set Up Email Only After the Results Are Trusted
Oracle supports scheduled saved-search emails. On the Email subtab, enable Send Emails According to Schedule, choose recipients, and set the interval and start date on Schedule. Oracle notes that inactive searches do not send scheduled emails.[6]
Start with yourself as the recipient. Review the actual message, columns, and attachments before adding a wider group. Decide whether an empty result is useful: for an exception list, no rows may mean there is nothing to do. Oracle provides a Send if No Results option for that choice.[6]
Keep scheduled reports separate from urgent alerts in your operating plan. A daily invoice list supports a routine review; it is not a promise that someone will act on every new invoice immediately.
8. Manage Changes Without Losing the Purpose
Oracle documents Save As as the way to save an edited search under a new name. Saving changes to the original depends on ownership, permissions, and whether audience editing is enabled.[7] For a major change, use a clearly named draft copy and compare its output with the current version.
- Keep an owner: name who answers questions about the results.
- Record the purpose: note the business question, important filters, and expected users.
- Review recipients: remove people who no longer need the emailed data.
- Check dependencies: ask whether dashboards, scripts, or integrations rely on the search before replacing or deleting it.
- Review on a schedule: choose a regular check that fits how often the process changes.
An ownership change deserves an extra email check. Oracle warns that moving a scheduled search to an owner who has never scheduled one can stop delivery until that owner signs in with the appropriate role and resaves it.[1]
When the Results Do Not Look Right
No rows? Start with a record you know exists. Check its type and date, then review each filter and your access. Change one setting at a time so you can see what caused the problem.
Repeated invoices? Recheck Main Line and remove added joins while testing. Unexpected totals? Compare individual records before changing formulas. A teammate sees different data? Ask your administrator to review their role and the audience settings.
A useful first search is small enough to explain and easy to verify. Once this invoice list works, use the same process for your next question. For deeper troubleshooting, see our saved-search optimization guide.
References
Sources reviewed September 23, 2026. Product steps use Oracle documentation; the access principle comes from NIST.
- Oracle NetSuite Help: Defining a Saved Search.
- Oracle NetSuite Help: Tips for Defining Simple Search Filters.
- Oracle NetSuite Help: Selecting Available Filters for Saved Searches.
- Oracle NetSuite Help: Defining Audiences for Saved Searches.
- NIST CSRC Glossary: Least Privilege.
- Oracle NetSuite Help: Enabling Saved Search Scheduled Email.
- Oracle NetSuite Help: Editing or Deleting a Saved Search.
- Oracle NetSuite Help: Saved Searches.