What Is NetSuite Saved Search?
Also known as: saved search, NetSuite search, SuiteAnalytics saved search
Definition
A NetSuite saved search is a stored query over a record type, such as transactions or items, defined with criteria, result columns, filters and formulas. It powers lists, dashboard portlets, email alerts, mass updates and SuiteScript lookups.
NetSuite Saved Search Explained
Saved searches are NetSuite's most-used reporting tool. You pick a record type (Transaction, Item, Customer, Work Order and others), set criteria such as status or date range, choose result columns, and optionally add summary grouping and formula fields written in SQL-like syntax. The result can be shown as a list, a dashboard portlet, a scheduled email, or exported to CSV.
Searches can be driven by scripts. SuiteScript's N/search module runs the same definitions programmatically, and the newer N/query module (SuiteQL) offers a SQL-style alternative with joins. Saved searches also feed reminders, KPI scorecards, and mass update or mass delete jobs, so a badly built search can change data at scale.
Limits matter. Large result sets can time out in the UI, formula text has length limits, and searches with many joins slow down. Teams typically keep a library of searches by function: open purchase orders past due, items below reorder point, work orders awaiting components, and unbilled receipts.
Why It Matters
- Most day-to-day NetSuite reporting is done in saved searches, so they hold undocumented business logic that has to be understood before a migration or AI rollout.
- Searches act as a ready-made, role-aware data layer: an AI assistant can reuse them to answer questions without bypassing permissions.
- Mass updates driven by saved searches are a common way data errors spread, so control over who can edit them is a governance point.
- Slow or duplicated searches degrade dashboard load times and are a frequent cause of user complaints.
In Practice
A planner builds a saved search on the Item record, with criteria Quantity Available less than Reorder Point and Preferred Vendor is not empty, then adds a formula column for days of cover (available divided by average daily usage). Scheduled to email every morning, it replaces a manual spreadsheet check and highlights roughly the 20 items needing action first.
Frequently Asked Questions
What is the difference between a saved search and a report in NetSuite?
Reports are built from predefined financial and operational templates. Saved searches query records directly with custom criteria and columns, which makes them more flexible for operational lists and alerts.
Can saved searches be used by scripts?
Yes. The N/search module can load a saved search by ID and run it, so scripts and integrations can reuse the same logic business users maintain.
What is SuiteQL?
SuiteQL is NetSuite's SQL-style query language available through N/query and the REST API. It supports joins that saved searches handle awkwardly.
Related Terms
Reorder Point
A reorder point is the inventory level at which a replenishment order is triggered. It equals expected demand during the replenishment lead time plus safety stock, so stock on hand covers usage until the new supply arrives.
Safety Stock
Safety stock is buffer inventory carried above expected demand to protect against variability in demand and supply during replenishment lead time. In ERP it is netted out of available inventory so MRP plans replenishment before the buffer is consumed.
REST API
A REST API is a web interface that exposes application data as addressable resources over HTTP, using standard verbs such as GET, POST, PUT, PATCH, and DELETE, stateless requests, and conventional status codes, typically exchanging JSON.
ERP (Enterprise Resource Planning)
ERP (Enterprise Resource Planning) is integrated business software that runs finance, manufacturing, supply chain, sales, and HR processes on a single shared database, so a transaction entered once updates every dependent function in real time.
SuiteScript
SuiteScript is NetSuite's server-side and client-side JavaScript platform for custom business logic. Scripts run on record events, schedules or HTTP calls, and use the N/record, N/search and N/https modules, under governance limits on usage units per execution.
Working with NetSuite Saved Search in a live environment? Our engineers do this every day - and our AI agents automate most of it.
Try it here, free
NetSuite Saved Search Formula Generator
Fill in your field IDs and thresholds and get copy-ready formula snippets for NetSuite saved search results and criteria.
New to NetSuite? Start with the NetSuite guide and toolkit, or plan with NetSuite Cost Calculator, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- NetSuite Saved Search Formula GeneratorFill in your field IDs and thresholds and get copy-ready formula snippets for NetSuite saved search results and criteria.
- NetSuite Saved Search Formula Functions ReferenceEvery common SQL function for Formula (Text), (Numeric), (Date), (Currency) and (Percent) fields, with syntax and an example using real NetSuite field ids.
- NetSuite Saved Search Summary Types and Summary Criteria ReferenceWhat each Summary Type returns, plus the formula patterns that do count distinct, conditional sums, latest value per group and HAVING-style filters.
ERP fixes and how-tos
- How to Build NetSuite Dashboards and KPI ScorecardsHow to build NetSuite dashboards with KPI, KPI Scorecard, and saved search portlets, set comparison periods, and share dashboards by role.
- How to use formula fields in a NetSuite saved searchHow to build formula (text), formula (numeric) and formula (date) fields in a NetSuite saved search, with CASE WHEN, DECODE and NVL examples that actually work.
- How to write and run SuiteQL queries in NetSuiteRun SuiteQL from Analytics > SuiteQL Query Tool or via N/query in SuiteScript. Syntax basics, joins, pagination and real examples for NetSuite reporting.
AI on your ERP
- NetSuite Procurement With AI for Purchase Orders, Receipts and Vendor BillsAI for NetSuite procurement: query purchase orders, item receipts and vendor bills with SuiteQL, flag three-way match breaks, and draft vendor follow-ups.
- AI agents for NetSuite manufacturing operationsAI agents for NetSuite manufacturing: WIP tracking, routing exceptions, and work order status grounded in SuiteQL, with human approval on anything that writes back.
Integrations
- How to add AI agents to Oracle NetSuiteHow to add AI agents to Oracle NetSuite: SuiteQL and REST tool layer, RESTlet writes, role-scoped tokens, human approval, and where a private model fits.
- How to use Claude with Oracle NetSuiteUse Claude with Oracle NetSuite through MCP connectors, the Anthropic API, AWS Bedrock or Vertex, plus the on-prem alternative for controlled data.