# NetSuite Saved Search vs Report vs SuiteQL vs Workbook: Which Should You Use? > Source: https://netray.co/tools/netsuite-reporting-tool-choice-assessment > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Score your reporting need on joins, volume, delivery, users and integration to see whether a saved search, workbook, SuiteQL or SuiteAnalytics Connect fits best. ## Category netsuite ## Erp NetSuite ## Audience - NetSuite administrator - Finance systems analyst - BI developer - SuiteScript developer ## Tool **Kind:** assessment **Questions:** #### What does the output look like? **Help:** A formatted GL statement is a separate case: use the Financial Report Builder whatever your score. **Options:** ##### A list of records or transactions people open and act on **Score:** 0 ##### A summary or pivot by period, customer or item **Score:** 1 ##### A result set another process or script consumes **Score:** 2 ##### Raw rows loaded into another system **Score:** 3 #### How many record types do you need to combine? **Options:** ##### One record type, with a few joined fields **Score:** 0 ##### Two related record types **Score:** 1 ##### Three or more, or joins a saved search cannot express **Score:** 2 ##### NetSuite data joined with data outside NetSuite **Score:** 3 #### How is the result delivered? **Options:** ##### On screen or as a scheduled email **Score:** 0 ##### Shared, interactive analysis inside NetSuite **Score:** 1 ##### Returned to a script, RESTlet or integration **Score:** 2 ##### Refreshed into a BI tool or data warehouse **Score:** 3 #### How does the data get to Excel or BI? **Options:** ##### Rarely, a user exports when needed **Score:** 0 ##### Weekly manual export to Excel **Score:** 1 ##### Automatic feed through an API call **Score:** 2 ##### Scheduled refresh over ODBC or JDBC **Score:** 3 #### How many rows does a typical run return? **Options:** ##### Under 1,000 **Score:** 0 ##### 1,000 to 10,000 **Score:** 1 ##### 10,000 to 100,000 **Score:** 2 ##### More than 100,000 **Score:** 3 #### What kind of summarising is needed? **Options:** ##### Simple group and total **Score:** 0 ##### A pivot across two or more dimensions **Score:** 1 ##### SQL logic such as subqueries or CASE across joined tables **Score:** 2 ##### Modelled measures across history in a BI model **Score:** 3 #### Who builds and maintains it? **Options:** ##### Business users with no technical help **Score:** 0 ##### Power users or an analyst **Score:** 1 ##### A NetSuite admin or developer who writes SQL **Score:** 2 ##### A data engineering or BI team **Score:** 3 #### Will code use the result? **Options:** ##### No **Score:** 0 ##### Yes, a script loads an existing search (search.load) **Score:** 1 ##### Yes, a script or integration runs SQL (N/query or REST SuiteQL) **Score:** 2 ##### Yes, an external pipeline extracts it on a schedule **Score:** 3 #### Do you need comparisons across periods? **Help:** For GL statements with comparative columns, use a financial report. **Options:** ##### No **Score:** 0 ##### Simple this period vs last period **Score:** 1 ##### Period over period across joined records **Score:** 2 ##### Multi-year trends and snapshots **Score:** 3 #### How fresh must the numbers be, and where? **Options:** ##### Live on a NetSuite dashboard portlet or KPI **Score:** 0 ##### Current when someone opens it in NetSuite **Score:** 1 ##### Current when an app or script asks **Score:** 2 ##### Daily or nightly in BI is fine **Score:** 3 **Bands:** #### Saved search **Min:** 0 **Max:** 25 **Verdict:** A saved search fits: one main record type, modest volume, non-technical owners, on-screen or emailed delivery and dashboard use. It is the tool most NetSuite users already know and the only one here that feeds portlets, reminders and scheduled emails directly. **Recommendations:** - Use summary types for group and total, and formula fields for simple calculations - Schedule delivery from the saved search's Schedule subtab - Expose it as a dashboard portlet or KPI where people work - Use the saved search formula generator for CASE and date formulas #### SuiteAnalytics Workbook and dataset **Min:** 26 **Max:** 50 **Verdict:** A workbook fits: you need joins across related records and pivots, built by analysts, consumed inside NetSuite. Datasets define the joined data once; workbooks add tables, pivots and charts that can be shared and exported. **Recommendations:** - Build one dataset per subject and reuse it across workbooks - Use pivots for multi-dimension summaries instead of many saved searches - Export the table view when someone needs it in Excel - Move to SuiteQL if a script or integration needs the same data #### SuiteQL (N/query or REST) **Min:** 51 **Max:** 75 **Verdict:** SuiteQL fits: joins and logic that are easier in SQL, maintained by an admin or developer, consumed by scripts, RESTlets or an integration. Run it with query.runSuiteQL in SuiteScript or POST it to the REST query service. **Recommendations:** - Use runSuiteQLPaged or REST paging for larger result sets - Look up table and field names in the Records Catalog - Keep queries in source control with the scripts that use them - Use the SuiteQL query generators to start from working joins #### SuiteAnalytics Connect (ODBC/JDBC) to BI **Min:** 76 **Max:** 100 **Verdict:** Connect fits: high volume, joins with other data, scheduled refresh into BI or a warehouse, owned by a data team. It exposes the NetSuite2.com data source over ODBC, JDBC or ADO.NET and is a separately licensed add-on. **Recommendations:** - Confirm the Connect licence before designing around it - Extract incrementally on lastmodifieddate rather than full reloads - Use a dedicated, restricted role for the connection - Keep operational lists and dashboard KPIs in saved searches ## Content **Intro:** NetSuite gives you several ways to get data out: saved searches, standard and financial reports, SuiteAnalytics Workbook, SuiteQL and SuiteAnalytics Connect. This assessment scores your need on ten questions and recommends the one that fits, with standard financial reports treated as their own case. **Sections:** #### How to use it **Body:** Answer for one reporting need at a time, not for the whole department. Options are ordered from simple to technical, so the score rises with joins, volume, automation and the technical skill of whoever maintains it. The result band names a tool and lists what to do next. If two needs give different answers, that is normal: most accounts use saved searches for operations, workbooks for analysis and SuiteQL or Connect for integrations and BI. Export the result to attach to a report request so the person building it knows why the tool was chosen. #### Where reports fit **Body:** Standard reports and the Financial Report Builder are the right tool for GL statements: income statement, balance sheet, cash flow and their comparative and budget columns. They respect accounting periods, consolidation and the chart of accounts in ways that rebuilding from transaction lines does not, so use them regardless of your score whenever the output is a financial statement. Standard reports can also be customized and scheduled for email. For everything else, the choice is between the four tools in the bands, and the main trade-offs are who can maintain it, how many record types it joins, how much data it returns and whether code or BI consumes it. #### Worked example **Body:** A plant controller wants open work orders with component shortages, refreshed daily for planners. It joins work orders, items and inventory balances, returns a few thousand rows, is maintained by the NetSuite admin and is read in NetSuite. The answers score about 40 percent, so a workbook on a dataset fits. A second need, a nightly load of all transaction lines into the company's warehouse alongside MES data, scores over 80 percent and points to SuiteAnalytics Connect. The same admin keeps a saved search portlet of late work orders on the planners' dashboard, because that need scores under 20. #### Common mistakes **Body:** Rebuilding financial statements from saved searches and spending every close reconciling them to the GL. Stacking dozens of saved searches where one dataset and a pivot would do. Using SuiteQL for a list business users must change themselves. Buying Connect for a report a workbook could deliver. Exporting large saved searches to Excel by hand every week instead of automating the feed. Forgetting that SuiteQL and Connect results depend on the role's permissions, so a query can return fewer rows for one role than another. **Cta:** If you want people to ask NetSuite questions in plain English and get the answer with the saved search or SuiteQL shown, on infrastructure you control, we can set that up. **Faq:** #### What is the difference between a saved search and a report in NetSuite? **Answer:** A saved search is a flexible query over one main record type with joined fields, formulas, summaries, scheduled emails and dashboard portlets. A report is a predefined layout, strongest for financial statements and standard summaries that follow accounting periods. Use reports for GL statements and saved searches for operational lists and alerts. #### Does NetSuite have a SQL query tool? **Answer:** NetSuite supports SuiteQL, a SQL-based query language over the same data model as SuiteAnalytics. You run it from SuiteScript with the N/query module, through the REST query service, or over SuiteAnalytics Connect. There is no general SQL console in the standard UI, so admins often use a small Suitelet or an approved tool. #### How do I connect NetSuite to Excel? **Answer:** For occasional use, export a saved search, report or workbook table to CSV or Excel. For a refreshable connection, use SuiteAnalytics Connect with the ODBC driver and a DSN pointed at NetSuite2.com, then load data in Excel through Get Data from ODBC. Connect is a separately licensed add-on. #### How do I schedule a saved search in NetSuite? **Answer:** Open the saved search, go to the Email subtab for alerts on record changes or the Schedule subtab for scheduled email of the results, set recipients and frequency, and save. Recipients need access to the data or receive it as an attachment depending on settings. Keep scheduled results small so the email stays readable. ## Search terms netsuite saved search vs report, netsuite sql query tool, netsuite saved search and dataset export, how to connect netsuite to excel, netsuite schedule saved search, netsuite workbook vs saved search, suiteql vs saved search --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json