Does anyone know how to import related items via CSV? I swear, I figured it out once years ago, but I’ve tried and given up on it ever since and ended up doing it manually…

hate to cross post but i posted this one on performance earlier and think it would be a good fit here as well

In a customer invoice import does the customer field need to be a name or an ID? I've tried both and it still says invalid reference

I'm sure this has been asked a million times, but what is the proper format for importing item images (which have already been uploaded to the file cabinet?) I tried including references to the file objects but this failed.

InternalId,1,2,3,4
10495,5101079,4991422,8356092,8356116

The error I get is

Invalid storedisplayimage reference key "5101079"

I also got the same error when I tried using the paths to the files

Hi all - what's the best way to mass update entity names at the line level of existing JEs? What are the Do's and Dont's? Thanks!

Hi Everyone - I am trying to have a clear out of my saved CSV import templates and clear the ones that are no longer used. Is there a way I can pull data showing when they were last used? I don't seem to be able to even edit the list in the UI. Any ideas? Thanks!

Hello! Is there a way for me to import an update to item fulfillments? I want to update a custom field on the item fulfillments and looking for the best way to update this.

Hi folks - I am in CSV import remapping and upload hell. It is giving me this error. What am i doing wrong?

Hi folks - I am importing trial balances into NS, and i have run into an issue - this upload file format - has worked to import the beginning balance. Now I am doing this for the following month (and have to import the activity rather than the month ending balance). The format is the same, the Credits and Debit match up. I am getting an import error “The amounts in a journal entry must balance.” I am attaching the results file here. What am i missing?

Hi all! We have a script that prevents JE to be uploaded without department value on any of the lines if a certain account is selected. But there are instances where we have some exceptions for certain allocation corrections where a JE is imported without department and class. I was thinking there would be an easy way for avoiding execution of scripts and workflows for JE imports but does not look like that NetSuite give that option. So we end up having to temporarily disable the script deployment for JE records, import & approve the JEs; then redeploy the script deployment. Is there a way to skip running of scripts & workflows for JE import (this is a different navigation path compared to the regular csv import for all other records)

Does anyone know how to get Work Orders as an option to csv import under Transactions? None of my clients before today have had this, but i'm working with a new client who has this available in the list of transactions to CSV import. I don't understand how. Any ideas?

Is it possible to update customer invoice subsidiary via csv import?

Is there a maximum amount of lines you can Inventory Transfer on one Inventory Transfer via CSV? Slack Conversation

Hi All, I have client(AU) based who gets SO (USA customers - US tax) via shopify integration. It create the SO with a tax code of

10.25%

. We then manually invoice the line and the tax code reverts to

0.25%

(same tax code as SO .same address). The client has asked me to update the Invoice tax rate to match the SO line rate. This is to repair the data while we try to figure out why tax rate changed. I have tried to do a CSV import which didn't allow me to update it. Then I tried the Script (load and save) which gave me Internal Server Error. Question: Any idea how I can fix the invoice tax rate to match the SO rate (CSV or script wise) . P.S if I enter a SO line manually for the item it defaults to the tax rate that is shown on the invoice. Slack Conversation

Is there a native restriction for non-Administrator roles to not be able to use the Employee > Imported Employee Expenses CSV import function? Administrator role has Full on this permission but I am only able to give View to any other role. Is there something I am missing? Thank you for the help

Trying to import invoice against opportunities but get this error: Invalid opportunity reference key 18425261 for entity <NULL>. The mapping looks like this:

Does anyone know if it's possible to use a CSV import to apply multiple unapplied payments to existing JEs for customers? Trying to avoid having to manually edit/adjust all of the existing payments

What format does the

Credit Memo : Customer (Req)

field need to be on CSV imports of credit memos?

We're trying to update some journal record lines Entity (Name) fields via CSV Import but on this particular subset of journals the field is readonly and it doesn't seem like we can overwrite it, has anyone experienced this / know how to work around it? We edit/saved the journals to unapply everything but no luck.

This message was deleted.

Hi - would anyone know why I'm not able to update the salesrep via CSV Import? The field is not listed in the mapping....

Anyone else have all of their shared CSV import maps unshared once the 2025.1 upgrade was applied?

hello, I would like to do csv import to create expense reports with specific taxes. I have SuiteTax. I'm importing 3 files at the same time: Primary File - Expense Report and Linked File (Optional) - Expense Report - Expenses are OK. But I'm strugling importing the Linked File (Optional) - Expense Report - Taxes. I need to set the required field "Tax Details Reference (Req)" but how is it possible to know it when you create a new expense report ? It's autogenerated isn't it ? thank you for your help.

Could you please clarify how long it takes to import a single invoice and/or credit memo? My client is complaining about performance degradation when importing CSV files. They import a large number of transactions (thousands). However, each transaction only consists of 1-3 lines. So currently it takes about 8 seconds to import a single invoice and 17 seconds to import a single credit memo.

can you csv import work order completions?