Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NetSuite Admin Tips: How to run a large financial report in the background
In some scenarios, management may be required to run financial reports from previous years to date which can contain a lot of lines. Users may sometimes encounter a notice: "The results of this report are too large. Please narrow your results." which can render incomplete data.
As per SuiteAnswers Id 8392, 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 the report shows limited result, you have the following options to get better output:
- Limit filters for example, limit the dates and periods
- Create a Saved Search - but this has its own limitation
Tagged:
3