This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I just found out that I am limited to 100,000 records per query. Do you guy recommend handling that by simply indexing through parameters in the query? Like, for example, request data month by month?

I answered my own question. Yes. If anyone finds this, you’ll need to index through the dates on the SuiteQL query.

1. Perform a query with nothing but a COUNT(…) to determine how many record are in your segment.
2. If more than 100,000, make the segment smaller.
3. Make sure you check every SuiteQL query before you run it.
4. Index through the dates in your WHERE clause to make sure you always have less than 100,000 results.
5. Index through the offset to return your the items for your query.