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
- Formula Field:
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.
Unlock the Full Potential of NetSuite
If you're looking to navigate the complexities of modern NetSuite reporting—from securing your HTML formulas to implementing AI-driven data analysis—Luxent can help. Our NetSuite consulting experts provide the guidance, training, and technical support needed to transition from basic searches to advanced SuiteAnalytics Workbooks. Contact us today to learn how we can modernize and elevate your NetSuite experience.
Summary of Updates Made:
- Terminology Fix: Corrected "donated" to "denoted" in the Join Saved Search section.
- Security Context: Added the requirement for Formula (HTML) and specific Permissions in the Formula and Tips sections.
- AI Integration: Introduced Text Enhance as a tip for data cleaning.
- Modern Pathing: Added a reference to SuiteAnalytics Workbooks as the next step for complex joins.
- CTA Modernization: Updated the closing text to focus on 2026 challenges (AI/Workbooks).
Would you like me to generate a PDF-ready version of this complete "2026 Cheat Sheet" for your team?