NetSuite collects financial and operational information across the business. However, collecting data is not the same as using it effectively.
NetSuite reports, saved searches, KPIs, dashboards, and SuiteAnalytics Workbook help users organize that information and turn it into practical insights. The key is selecting the right tool for the question and presenting the results in a format people can understand and act on.
Photo by Bia Limova on Pexels
Understanding NetSuite Reports
NetSuite SuiteAnalytics provides built-in reports, searches, KPIs, and dashboards. Because these tools are embedded in NetSuite, users can review current information and drill from summarized results into transaction-level details.
Standard NetSuite reports
Standard NetSuite reports provide a starting point for common financial and operational questions. Users can customize many reports by adjusting filters, columns, groupings, and formatting.
- Financial statements
- Point-in-time analysis
- Transaction summaries
- Routine departmental reporting
- Reports with established accounting layouts
Saved searches
A saved search is a reusable set of criteria and results. Saved searches can locate records, monitor exceptions, support dashboards, and provide employees with recurring operational information.
- A live list of records meeting specific conditions
- Detailed transaction information
- Exception reporting
- Operational tracking
- Proactive reminders or notifications
- Data that users can filter or sort
KPIs and dashboards
KPIs provide a high-level view of important measures. Role-based dashboards can combine KPIs, reminders, report snapshots, and saved search results. A good dashboard shows users what requires their attention.
SuiteAnalytics Workbook
SuiteAnalytics Workbook supports custom analysis through datasets, tables, pivot tables, and charts. It is helpful when standard NetSuite reports or saved searches cannot adequately answer a more complex question.
- Multiple related records
- Interactive filtering
- Detailed tables
- Pivot-style analysis
- Charts and visualizations
- Repeatable analytical views
NetSuite Reports Versus Saved Searches
Reports and saved searches sometimes appear interchangeable, but they are designed for different needs. Use a report when the goal is structured financial or operational presentation. Use a saved search when the goal is identifying records that match specific criteria or monitoring changing activity.
- Use a financial report to review revenue and expenses by period.
- Use a saved search to find invoices that are overdue and assigned to a specific collector.
- Use a dashboard KPI to monitor the total overdue balance.
- Use a workbook to analyze collection trends across customers, locations, or periods.
Start With the Business Question
Before building a report or saved search, define the question it needs to answer.
- Which orders are ready to ship but have not been fulfilled?
- Which customers have balances beyond their payment terms?
- Which items are below their reorder point?
- Where is gross margin declining?
- Which transactions are missing required information?
- Which departments exceeded budget?
A clear question helps determine the record type, criteria, columns, formulas, and appropriate reporting tool. Without that focus, searches often become large data exports that users must clean manually.
Build Better NetSuite Saved Searches
Select the correct search type
The search type determines the records and fields available. Begin with the record that most closely represents the activity being analyzed. For fulfillment tracking, for example, a transaction search filtered to the appropriate transaction type can isolate fulfillment-related activity.
Use transaction line criteria carefully
Transaction searches can produce duplicate or confusing rows because a transaction may contain main, item, shipping, tax, and other lines. Main Line, Shipping Line, Tax Line, and related criteria help control which transaction components appear. The correct settings depend on whether the search needs one row per transaction or detail from individual lines.
Keep criteria focused
Every criterion should support the original business question. Unnecessary filters can hide valid records, while overly broad criteria may return so much data that the results become difficult to use. Test criteria on a manageable group of records before releasing the search to a broader audience.
Choose useful result columns
Include only the information a user needs to understand the result and take the next step.
- Record number
- Date
- Customer or vendor
- Status
- Assigned employee
- Amount
- Days outstanding
- Location or department
- A link to the underlying record
Use summaries and grouping
Saved search results can be grouped, counted, totaled, or averaged. Summary results can turn a detailed record search into a concise reporting tool. Make sure the summary produces the intended level of detail.
Add formulas when needed
Formulas can calculate or transform values that are not stored directly on a record. Keep formulas readable and document their purpose. Test complex formulas against records with known results before using them for important decisions.
Structure joins carefully
Joins pull fields from related records, such as customer, item, employee, or transaction information. Use only the joins required to answer the question. Too many joins can make a search harder to understand and may affect performance.
Monitor search performance
A saved search may become slow when it contains broad criteria, complex formulas, unnecessary joins, or a large number of result columns. A focused search is easier to maintain and more likely to become part of the team’s daily work.
- Narrow the criteria
- Remove unused results
- Review formulas
- Reconsider joined records
- Confirm that users need the entire dataset
Establish a Saved Search Naming Convention
Clear names help users understand what a search does and reduce duplicate development. A naming convention might identify:
- The department or audience
- The record or process
- The search’s purpose
- Whether the search is used for a dashboard or automation
- The search owner
Organizations should also establish an owner and review date for important searches. This makes it easier to retire outdated versions and confirm that shared searches still serve their intended purpose.
Share Results With the Right Users
Saved searches can become shared resources when permissions allow. Before publishing a search, confirm that its audience should have access to the underlying records and fields. Role-based access remains important even when a search is operationally useful.
Design Dashboards Around Decisions
A dashboard should provide a quick, accurate view of the user’s responsibilities. Start with the audience:
- Executives may need revenue, cash, margin, and high-level trends.
- Finance may need close progress, receivables, payables, and exceptions.
- Sales may need pipeline, orders, and customer activity.
- Operations may need inventory, fulfillment, and purchasing information.
Place important KPIs and exceptions where they are easy to see. Use saved search results for actionable detail and Workbook for deeper analysis.
Create a Reporting Review Process
Reports and searches can become outdated as processes, products, and organizational structures change. Review important reporting assets regularly to determine:
- Whether users still rely on them
- Whether the criteria reflect the current process
- Whether formulas remain accurate
- Whether permissions are appropriate
- Whether duplicate searches exist
- Whether the output leads to a defined action
- Whether a different NetSuite reporting tool would work better
This review keeps dashboards useful and prevents employees from relying on old or conflicting information.
Get More Value From NetSuite Reports
The strongest NetSuite reporting environments do more than produce numbers. They give each user the information needed to make a decision or take action.
Zastro can help your organization review existing reports, improve saved searches, build role-based dashboards, and create SuiteAnalytics Workbooks that reflect how your business operates. The result is clearer reporting, less manual work, and more value from the data already available in NetSuite.
Frequently Asked Questions
Here are answers to common questions from NetSuite users about reports and saved searches.
What is a NetSuite saved search?
A saved search is a reusable search definition containing criteria, results, filters, and display options. It can support reporting, tracking, dashboards, reminders, and operational workflows.
What causes duplicate rows in a transaction saved search?
Duplicate rows commonly occur because transaction searches can return information from multiple transaction lines. Review Main Line and other transaction-line criteria, result columns, formulas, and joins.
What is SuiteAnalytics Workbook used for?
SuiteAnalytics Workbook supports custom datasets, tables, pivot tables, and charts. It is useful for deeper analysis that is difficult to present through a standard NetSuite report or saved search.
Can saved searches appear on NetSuite dashboards?
Yes. Saved search results can support dashboard views, reminders, KPIs, and other recurring reporting needs when properly configured and available to the user’s role.
How do I run a standard report in NetSuite?
Standard reports can be run from links on the Reports Page, on the Reports tab menu, and on other tabs throughout NetSuite. Many standard reports include both summary and detail versions. In many cases, you can start with the summary version and then open the detail version of the report from there to review the underlying transactions.
Can I customize standard reports in NetSuite?
Yes. You can use the Report Builder to customize most standard and ad hoc reports. NetSuite also provides a specialized Financial Report Builder for customizing financial statements only. This allows teams to tailor reports to their business without rebuilding them from scratch or exporting data for manual formatting.
What is the difference between a saved search and a report in NetSuite?
Reports provide formatted report definitions you can run to review, present, and analyze account data. Saved searches offer a more flexible way to gather data for everyday operational questions. Both serve managers who need data to run and improve their business, and many teams use them together to move from summary insight to transaction-level detail.
