-
Formula for excluding non-summary inactive COA
We usually use datasets instead of saved searches for COA export as several fields like ‘Eliminate Intercompany transactions’ and ‘Reconcile bank statements’ options are not available in Saved Searches. While preparing the dataset, we cannot directly put the criteria as exclude inactive as the inactive accounts include…
-
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…
-
Search Exports in Prod but Not Sandbox
Hello, I have a rather large saved search that exports and opens in XLS just fine in Production. However, in Sandbox the file doesnt open, instead errors with "The file is corrupt and cannot be opened" message. This seems to be effecting a handful of users at the moment. The same saved search even errors out in Production.…
-
SuiteTip: Extract Rich Text Field Values without HTML Tags using Saved Search Formula
Welcome back to SuiteTip, your ultimate guide to mastering NetSuite's capabilities! In this article, we tackle a common challenge and offer a clever solution to streamline your data export process. The Challenge: HTML Tags in Exported Data When exporting data from Rich Text fields, NetSuite includes the HTML formatting…
-
Saved Search Export Does Not Match the Results (Different Transaction Type Entirely)
What would cause the results of a saved search export to be COMPLETELY DIFFERENT from the results of the search itself that you see onscreen? I want to export this list of Sales Orders, but when I export the results (whether CSV, Excel, or PDF), the results are for Item Fulfillments. It's as if the system is exporting the…
-
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…
-
Item Line description to Expense Report PDF
Hi All, Is there any way to accommodate the item line description in an export report pdf? Thanks Aby
-
MRP Demand Planning - How to see which components need to be expedited?
We are using MRP and pushing Planned Purchase Orders to our procurement group very successfully. When we release a Planned Purchase Order it includes the expected receipt date that is based on the items lead time. This does not tell the purchaser if the item needs to be expedited or not. From the planning workbench it is…
-
Better ways to export stock inventory data out of NetSuite?
We went live with NetSuite in February this year. Once of the tasks I do each day is to update the stock inventory files on our ftp sites. I run reports in NetSuite, export them out to csv files save them as an Excel macro files and then use VBA code to put the data in the format I need it in. I then use FileZilla to…
-
Unexpected error when exporting a PDF from saved search after 2023.2 update
I have a saved search that we use more or less weekly, and after the 2023.2 update while the search still runs we can't export it to a PDF file. When we try we get the dreaded Unexpected Error. The search is somewhat complex, so I've tried removing a couple of things (in a test version of the search) I thought might be…