CODEWITHSUNDEEP
exportnetsuitesaved-searches
Bill Sutton
Bill Sutton

Reputation: 1

Netsuite Saved Search does not export all results

I've created a saved search of historical order data in Netsuite. When I run the saved search filtering it for a period of one particular month, 1259 results are returned, with orders on every day of the date range—spanning several "pages" in the saved search results.

However, if I download that to CSV, only 50 results are downloaded. I've searched far and wide for what could be restricting the download and found nothing.

I have to get this data out, and this CSV download malfunction is a major obstacle.

Any ideas on what could be causing this would be greatly appreciated.

Here's what I've tried and what resulted:

I ran the saved search, and clicked the CSV download icon. I was expecting all 1259 result rows to appear in the CSV.

I've been trying this with a limited set of data to make sure it's not a time-out issue. It's not. The whole thing runs in about 15 seconds.

I've also tried creating a Persisting CSV file, and that yielded the same results. Only 50 line items were downloaded.

Upvotes: 0

Views: 336

Answers (1)

Jared
Jared

Reputation: 1

I just had this issue. My problem was I had a field listed twice in the criteria section with different operators. (Date is before X and then another line with Date is after X) I also had this date field as an available filter. What I found was in having the date as an available filter it was changing both date criteria lines to be on the same operator only when exporting. I could fix the problem by either merging to the two date fields into one criteria line (date is within X) or removing date as an available filter.

Upvotes: 0

Related Questions