Are there size limits for report and search results?
Report results are truncated if they exceed the following row limitations. These limits are enforced for performance reasons.
-
For most reports, results are limited to 25,000 rows.
-
For the following reports, results are limited to 75,000 rows :
-
Ad hoc reports
-
A/R Aging
-
Balance Sheet
-
Budget Income Statement
-
Budget vs. Actual
-
Cash Flow Statement
-
Cash Statement
-
Comparative Balance Sheet
-
Comparative Income Statement
-
Current Inventory Snapshot
-
Deferred Revenue by Customer
-
General Ledger
-
Income Statement
-
Inventory Valuation
-
Pipeline by Sales Rep (summary only)
-
Revenue by Customer
-
Revenue Recognition Forecast
-
Sales by Customer
-
Sales by Item (summary only)
-
Sales Orders by Customer
-
Sales Orders by Item (summary only)
-
Scheduled Deferred Revenue
-
Search results have a limit of 10 MB. When exporting to a CSV file, this is equivalent to approximately 20,000 rows and 50 columns of data. If your results exceed these limits, try adding or modifying the existing criteria used in the search. For example, you can try limiting the date range used to generate the results.
If these limits are hampering your ability to access the data you need, you can try filtering report or search data. You also may want to consider purchasing the ability to access NetSuite data through SuiteAnalytics Connect.
See the following topics.