I am trying to export a saved search but the excel file shows less that the saved search results in netsuite. why is it ?

AI generated answer (using internal Slack threads):

The discrepancy between the number of results in the Excel file and the saved search results in NetSuite could be due to several reasons: 1. Excel Export Limit: NetSuite has a limit on the number of rows that can be exported to Excel. If your saved search results exceed this limit, the exported Excel file will not include all the results. 2. Email Size Limit: If you are emailing the Excel file, there is a size limit for attachments. If the Excel file exceeds this limit, it may be truncated, and some results may not be included. 3. Data Formatting: NetSuite strips all formatting on export. If your saved search results include highlighted or specially formatted data, this formatting will not be included in the exported Excel file. 4. Additional Filters: If you are using SuiteScript to load the saved search and apply additional filters, these filters may be affecting the results that are included in the exported Excel file. Here is a sample SuiteScript code to extract the results of a saved search into the file cabinet:

javascript
var searchTask = task.create({ taskType: task.TaskType.SEARCH});
searchTask.savedSearchId = 123; // CHANGE THIS
searchTask.filePath = ; // set this to where you want your CSV
var result = searchTask.submit();

Please note that you cannot use additional filters in the existing search using SuiteScript. If you need to apply additional filters, you will need to create a new search that includes these filters. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

@Merrick how many records are returned in your search? Can you share the criteria and results tab here?

around 80,000 lines

try exporting as csv instead of Excel @Merrick IIRC Excel export is restricted to 10K rows and CSV to 25K. I know that doesn't solve your problem but it at least verifies the issue.

Thank you Chris, will give that a try

@Merrick I'm curious to see what the result was. LMK?

Results results were the same unfortunately

@Merrick CloudExtend has an Excel App that should support this. This is not meant to be a sales pitch 🙂 You could try it for free. It allows you to stream your saved searches into NetSuite on demand or on a schedule. I recall our team had to implement some coding to get high numbers of records into Excel. Anyway, LM if you want to try it, no obligation.

Thank you Chris