-
The date in excel, show different with saved search
On the saved search, the date show 14/8/2026. Then I click the export excel button and open the file it shows 13/8/2026. However I export CSV and open the file, it shows 14/8/2026. It seem like happen after upgrade by the system. So what should I resolve it.
-
Date (Actual Date - not Format) is Changing Between NetSuite UI and Excel Export on Saved Search
I have a saved search that an employee runs each evening. The columns include Region, Territory, Month of Date, Invoiced Sales, and some others. The employee who uses the saved search for her report contacted me last night to let me know that yesterday's numbers were missing. That seemed odd, as we generate daily invoices…
-
Can we create excel file with formulae column?
Hello, We are creating excel file with suitescript having dynamic formulae column and it is shown properly like given below but when it is converted from xml to excel then it changes to different version and formulae does not work. We need this to work when excel is downloaded and values to shown as per given formulae when…
-
NetSuite .xls security issues
Security is requesting exporting data (reports, searches, lists, transactions) as .xlsx versus .xls due to security concerns. SuiteAnswers confirmed that .xls is the only supported format, other than .xlsx for Workbooks, pivot tables, and NSPB, NSAR, EPM modules. Recommendation was export and save as, or use the ODBC…
-
Excel Unable to Open Saved Search Export (.xls) – File Reported as Corrupted
Hi everyone, I’m experiencing an issue when exporting a Saved Search result as an .xls file. When I try to open the file in Microsoft Excel, it fails to open and displays a message indicating that the file is corrupted or unsafe. Has anyone else encountered this issue? If so, were you able to identify the cause or find a…
-
Export Excel in xlsx format
I have seen the enhancement 188904 being voted on and it has almost 800 votes and has been listed as a requested enhancement for almost 10 years? What does it it take for NetSuite to actually implement an enhancement especially one as important as this. This is highly frustrating and causes many issues due to the very old…
-
"USR REST API CALL" Error When Exporting SuiteAnalytics Workbook to Excel
We have a user who, when exporting tables and pivot tables to Excel from SuiteAnalytics, often gets the following error message: {"customerFacingMessage" : "Unexpected Error", "executionReference" : " USR REST API CALL", ' 'message" : "Unexpected Error"} This does NOT happen when he exports to CSV—only to Excel. And it…
-
Why does the exported Saved Search result is different from the UI?
I am doing a transacton search on invoices. The search results are what I expect, on the screen (70 results). When I export to either Excel or CSV, I am getting duplicate lines for every invoice. (732 results). If I select print to pdf, the correct lines show up but excel/csv is what I need. Criteria: Results: I see there…
-
Saved search export issue
Hi Team, I have created this opportunity, Saved Search. Step: 1 - In the Criteria, add the "Active" and "inactive" sales reps. Step: 2 - Add results fields Step: 3 - In the filter, add the sales rep field. Step: 4 - Now run the report Step: 5 - Export the results to Excel When we export the results, it's not exporting the…
-
Report > Export to Excel File > Format changes
Hi Guru's, When I generate an Inventory Report and use the Export to Excel File button the value of the quantity is changing. Generate Inventory Report When I use the Export to Excel File button the value is: If I open the the file in Notepad++ or a simple Notepad the number of quantity is correct. Why is the number of…