NetSuiteFree assessmentPDF, Excel, Word exportNetSuiteAll NetSuite tools

NetSuite Saved Search vs Report vs SuiteQL vs Workbook: Which Should You Use?

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.

0 of 10 answered0%

1. What does the output look like?

A formatted GL statement is a separate case: use the Financial Report Builder whatever your score.

2. How many record types do you need to combine?

3. How is the result delivered?

4. How does the data get to Excel or BI?

5. How many rows does a typical run return?

6. What kind of summarising is needed?

7. Who builds and maintains it?

8. Will code use the result?

9. Do you need comparisons across periods?

For GL statements with comparative columns, use a financial report.

10. How fresh must the numbers be, and where?

Was this tool useful?

How to use it

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

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

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

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.

Frequently Asked Questions

What is the difference between a saved search and a report in NetSuite?

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?

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?

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?

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.

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.

Talk to an Expert Explore More Free Tools