🔍 Module 07: Creating Saved Searches

Week 2 • Saved Searches Fundamentals • Core Skills

What is a Saved Search?

A saved search is a reusable, customizable query that retrieves specific data from NetSuite based on criteria you define. Unlike standard reports, saved searches give you complete control over what data is returned, how it's filtered, and how it's displayed. They can be used for reporting, dashboards, workflows, email alerts, and more.

Common Search Types

When creating a saved search, you first select the record type (search type) to query.

Transaction
Customer
Item
Vendor
Employee
Contact
Case
Opportunity
Project
Custom Record

Creating a New Saved Search

  1. Navigate to Reports → Saved Searches → All Saved Searches
  2. Click New
  3. Select the Search Type from the list (e.g., Transaction, Customer, Item)
  4. Enter a Search Title (this appears in menus and lists)
  5. Optionally enter a Script ID for use in SuiteScript
  6. Configure the Criteria subtab (filters)
  7. Configure the Results subtab (columns and sorting)
  8. Click Save or Save & Run

Public vs. Private Searches

Setting Description
Private (default) Only you can see and run the search
Public All users can run and view results; only owner/admin can edit
Allow Audience to Edit Specific users/roles can edit the search (set on Audience subtab)

💡 Naming Convention

Use a consistent naming convention for saved searches:

Saved Search Subtabs

📋 Key Subtabs

Subtab Purpose
Criteria Define filters to limit which records are returned
Results Select columns to display and set sort order
Available Filters Add filters users can adjust when viewing results
Highlighting Set conditional formatting (colors, bold, images)
Audience Define who can view/edit the search
Email Configure email alerts and scheduled emails

Deployment Options

Control where and how the saved search appears in NetSuite.

Option Effect
Available as List View Search appears as a view option on record list pages
Available as Dashboard View Search can be added to Custom Search portlets
Available for Reminders Search can be added to the Reminders portlet
Show in Menu Search appears in Reports → Saved Searches menu

💡 Example: Customer Balance Search

Create a search to find customers with a positive balance who were created in the last year:

🎯 Key Takeaways