Row Limitations for Report Results
Report size is measured by the number of database rows retrieved for it. The number of rows retrieved for a report might be higher than the number displayed, for example when results are split across multiple classifications.
Report results get cut off if they exceed the following row limits. These limits help performance. Row limits are the same for all NetSuite reports, but reports run in the background, like scheduled, emailed, or exported reports, have higher limits.
The limits for retrieved rows per report are:
-
100,000 rows — for a report executed on demand (synchronously)
-
1,000,000 rows — for a report executed in the background (asynchronously)
If a report is being truncated, you can try the following:
-
Set additional filters to limit report results. See Filtering Data on Reports.
-
Create a saved search to return the desired data. Saved searches don't have row limitations like reports, although you may be unable to export search results with extremely large data sets. See Defining a Saved Search. To learn how to persist saved search results for searches that contain a high volume of data, see Persisting Search Results.
-
Obtain access to NetSuite SuiteAnalytics Connect service. See SuiteAnalytics Connect.