If there’s one feature in NetSuite that delivers outsized value relative to its learning curve, it’s saved searches. Saved searches are the foundation of reporting, analytics, dashboards, workflows, scripts, and data-driven decision-making in NetSuite. Yet many companies barely scratch the surface of what they can do.
In this article, we’ll explore saved searches in depth — what they are, how they work, advanced techniques, and practical examples that demonstrate their power.
What Is a Saved Search?
A saved search is a configurable query that retrieves data from NetSuite’s database and presents it in a list, chart, or summary format. Think of it as a SQL query with a visual builder — powerful enough for complex data retrieval but accessible enough for non-developers.
Every saved search has four main components:
- Record Type – The type of data you’re searching (transactions, customers, items, employees, custom records, etc.)
- Criteria (Filters) – Conditions that narrow the results (e.g., “Transaction Type is Invoice AND Date is within the last 30 days AND Status is Open”)
- Results (Columns) – The fields displayed in the output (e.g., Customer Name, Invoice Number, Amount, Due Date)
- Summary/Grouping – Optional aggregation that groups and summarizes data (e.g., total revenue by customer, average order value by month)
Why Saved Searches Matter
They’re Everywhere
Saved searches power virtually every data-driven feature in NetSuite:
- Dashboard Portlets – Key metrics, lists, and charts on user dashboards
- KPI Scorecards – Executive dashboards with real-time KPIs
- Reports – Custom reports that go beyond NetSuite’s standard report templates
- Workflow Conditions – Trigger workflows based on saved search results
- SuiteScript – Scripts can reference saved searches to retrieve and process data
- Scheduled Reports – Automatically email saved search results to stakeholders on a schedule
- Mass Updates – Use saved searches to identify records for bulk modification
- Form Source Lists – Filter dropdown fields on forms based on saved search criteria
- CSV Exports – Export data for external analysis or reporting
They’re Real-Time
Unlike static reports that run against a snapshot of data, saved searches pull live data from NetSuite’s database. When you view a saved search, you’re seeing the most current information available.
They’re Flexible
Saved searches support:
- Over 100 record types
- Dozens of filter operators (is, is not, contains, starts with, between, before, after, any of, none of, etc.)
- Formula fields using NetSuite’s formula syntax (based on Oracle SQL functions)
- Summary types: group, sum, count, average, minimum, maximum
- Highlighting rules for visual emphasis
- Email alerts triggered by search results
- Available as RSS feeds
Building Your First Saved Search
Let’s walk through a practical example: an accounts receivable aging report.
Step 1: Choose the Record Type Navigate to Reports > Saved Searches > New. Select “Transaction” as the record type.
Step 2: Define Criteria
- Type is Invoice
- Status is Open
- Main Line is True (to avoid duplicated line-level data)
Step 3: Define Results
- Customer Name
- Invoice Number (Document Number)
- Date
- Amount Remaining
- Days Overdue (Formula: {today} – {duedate})
Step 4: Add Summary (Optional) To create a summary view grouped by customer:
- Group by Customer Name
- Sum Amount Remaining
- Maximum Days Overdue
Step 5: Add Highlighting (Optional)
- Highlight rows in red where Days Overdue > 90
- Highlight rows in yellow where Days Overdue > 60
Step 6: Save and Deploy Save the search, set permissions (who can view it), and add it to a dashboard portlet.
Advanced Saved Search Techniques
Formula Fields
Formula fields use Oracle SQL-like syntax to create calculated columns. Common formula types:
- Formula (Text) – Text manipulation and concatenation
{firstname} || ‘ ‘ || {lastname}
- Formula (Numeric) – Mathematical calculations
{amount} * 0.1
- Formula (Date) – Date calculations
{today} – {duedate}
- Formula (Currency) – Currency-formatted calculations
{quantity} * {rate}
- CASE Statements – Conditional logic
CASE WHEN {daysoverdue} > 90 THEN ‘Critical’ WHEN {daysoverdue} > 60 THEN ‘Warning’ ELSE ‘Current’ END
Joined Searches
Saved searches can join data from related records. For example, a transaction search can include fields from the related customer record, item record, or custom record. This eliminates the need for separate searches and manual data consolidation.
Summary Searches with Filters on Summaries
You can apply filters on summary results (similar to SQL’s HAVING clause). For example: “Show me all customers where the sum of open invoice amounts exceeds $10,000.”
Relative Date Filters
Instead of hardcoding dates, use relative filters like “within the last 30 days,” “this fiscal quarter,” “next month,” etc. This keeps your searches dynamic and evergreen.
Available Filters
Make saved searches interactive by defining “Available Filters” — criteria that users can modify at runtime without editing the underlying search definition. This turns a single saved search into a flexible, self-service reporting tool.
Practical Saved Search Examples
1. Sales Pipeline by Stage
- Record Type: Opportunity
- Criteria: Status is not Closed Lost
- Results: Customer, Title, Probability, Projected Amount
- Summary: Group by Sales Stage, Sum Projected Amount
2. Inventory Below Reorder Point
- Record Type: Item
- Criteria: Type is Inventory Item, Quantity Available < Reorder Point
- Results: Item Name, SKU, Quantity Available, Reorder Point, Preferred Vendor
3. Revenue by Product Category (Monthly Trend)
- Record Type: Transaction
- Criteria: Type is Invoice, Date is within this fiscal year
- Results: Month (from Date), Item Category, Amount
- Summary: Group by Month and Item Category, Sum Amount
4. Customer Lifetime Value
- Record Type: Transaction
- Criteria: Type is Invoice
- Results: Customer, Sum of Amount, Count of Transactions, Min Date (first purchase), Max Date (last purchase)
- Summary: Group by Customer
5. Overdue Purchase Orders
- Record Type: Transaction
- Criteria: Type is Purchase Order, Status is Pending Receipt, Expected Receipt Date is before today
- Results: PO Number, Vendor, Expected Receipt Date, Amount, Days Overdue (formula)
Common Mistakes and How to Avoid Them
- Not Using Main Line Filter – Transaction searches without the Main Line filter return both header and line-level rows, leading to duplicated or confusing results.
- Ignoring Permissions – Saved searches inherit role-based permissions. Make sure the search results are appropriate for all users who can access it.
- Overcomplicating Criteria – Start simple and add complexity incrementally. A search with 20 criteria is hard to debug.
- Not Using Available Filters – If multiple users need slightly different views of the same data, use Available Filters instead of creating separate searches.
- Neglecting Performance – Saved searches that pull large data sets with many formula fields can be slow. Use summary types and date range filters to limit data volume.
Saved Searches and the Bigger Picture
Saved searches are a cornerstone skill for anyone working with NetSuite. Investing in NetSuite consulting to build a library of well-designed saved searches can transform how your organization uses data — replacing static spreadsheets with real-time, self-service reporting.
At Anchor Group, our NetSuite consultants regularly build saved search libraries as part of our implementation and optimization engagements. We design searches that answer the questions your team asks every day — and surface insights they didn’t know to ask about.
Conclusion
Saved searches are the most powerful and versatile tool in NetSuite. They power dashboards, reports, automations, and integrations — and they’re accessible to anyone willing to invest a few hours in learning the basics. By mastering saved searches, you unlock a level of data visibility and decision-making speed that spreadsheets simply can’t match.
If your organization is underusing saved searches — or struggling to build the reports you need — reach out to Anchor Group. We’ll help you unlock the full potential of your NetSuite data.
