NetSuite saved search formulas are SQL-based expressions that transform, calculate, and manipulate your data beyond standard field outputs, and in 2026 they've grown to include AI-assisted text enhancement and secure HTML fields. This deep dive breaks down the five formula types, the core saved search methods, and the modern tips that get more out of your reporting.
NetSuite Saved Searches remain the most powerful reporting tool for daily operations. However, as NetSuite’s security architecture and AI capabilities have evolved, the way we write formulas has changed. To get the most out of your data in 2026, you need to master not just SQL syntax, but also the new security and AI-driven workflows.
What are NetSuite Saved Search Formulas
NetSuite Saved Search formulas are powerful expressions based on Oracle SQL that allow you to transform, calculate, and manipulate your data beyond standard field outputs. In 2026, these formulas have evolved from simple math and text joins into sophisticated tools that support Generative AI for text enhancement and dedicated HTML fields for secure data visualization. Whether you are using a CASE statement to categorize high-value customers or employing Formula (HTML) to create dynamic, clickable dashboards, these formulas remain the essential engine for turning raw data into actionable business intelligence.
Formula (Text)
Purpose: Used to manipulate and display text data.
Examples:
- Concatenating fields: {firstname} || ‘ ‘ || {lastname}
- Extracting substrings: SUBSTR({itemid}, 1, 5)
Formula (Numeric)
Purpose: Used to perform calculations that return numeric results.
Examples:
- Calculating totals: {quantity} * {rate}
- Displaying a value for a null numeric result: NVL({quantitycommitted},0)
Formula (Date)
Purpose: Used to manipulate and calculate dates.
Examples:
- Adding days to a date: {startdate} + 30
- Extracting the year: TO_CHAR({trandate}, ‘YYYY’)
Formula (Percent)
Purpose: Used to perform calculations that result in a percentage.
Examples:
- Calculating profit margin: ({amount} – {cost}) / NULLIF({amount}, 0)
- Percentage of total: ({quantity} / NULLIF(SUM({quantity}) OVER (), 0))
Formula (Currency)
Purpose: Used to perform financial calculations involving currency amounts.
Examples:
- Converting amounts: {amount} * {exchangerate}
- Conditional currency calculation: CASE WHEN {currency} = ‘USD’ THEN {rate} ELSE {fxrate} END
By leveraging the power of NetSuite saved search formulas and functions, users can create highly customized and insightful reports, aiding in better decision-making and efficient data management. These advanced formulas enable users to manipulate and analyze data with precision, uncovering valuable trends, patterns, and metrics. By mastering NetSuite formula syntax and modern security protocols, businesses can enhance their reporting capabilities, optimize operations, and gain a competitive edge through data-driven insights.
Saved Search Methods
Basic Saved Search
The Basic Saved Search is the foundation of data querying in NetSuite. It allows users to define simple criteria and filters to retrieve relevant records. You can specify the type of record (e.g., transactions, customers, items) and apply basic filters (e.g., date range, status).
- Example: To find all sales orders created in the last month, you can set the criteria to:
- Type: Sales Order
- Date Created: Last Month
Summary Saved Search
Summary Saved Searches aggregate data and provide summarized views of information, such as totals, averages, and counts. This method is useful for generating high-level reports and dashboards.
- Example: To summarize total sales by customer:
- Type: Sales Order
- Criteria: Date Created = This Month
- Results: Group by Customer, Sum of Amount
Join Saved Search
Join Saved Searches allow users to pull in related data from different records. By using joins, you can create complex queries that span multiple record types.
- Example: To find sales orders and their associated customer details:
- Primary Record Type: Sales Order
- Join Field: Customer (will be denoted as ‘Customer Fields…’ when searching for join)
- Display Fields: Sales Order Number, Customer Name, Customer Email
Formula Saved Search
Formula Saved Searches use SQL-based expressions to create custom calculations and logic within search criteria and results. In 2026, this includes the use of Formula (HTML) for secure data visualization and AI-assisted formula generation.
- Example: To calculate the total sales amount excluding tax:
- Formula Field: {amount} - {taxamount}
- Criteria: Type = Sales Order
Tips for maximizing NetSuite saved searches
- Use Criteria and Filters Wisely: Narrow down your search results by applying specific criteria. This ensures your searches are efficient and return only relevant data.
- Leverage Modern Formulas: Utilize Formula (HTML) for clickable links or status badges, and use NetSuite Text Enhance (AI) to automate the cleaning of text data within your results.
- Create Summary Searches: Generate high-level overviews for easier consumption. Note: If you need to join more than two records deep, consider moving these summaries into SuiteAnalytics Workbooks.
- Schedule and Automate: Automate your reporting by scheduling saved searches to run at regular intervals.
- Share and Save Searches: Promote consistency by saving and sharing searches, but ensure users have the "Create HTML Formulas" permission if your search contains custom UI elements.
Modernize your NetSuite reporting
From securing HTML formulas to AI-driven analysis, we help you move from basic searches to advanced SuiteAnalytics Workbooks.
Book a demo
