Articles tagged #IMPORT
Articles tagged
#IMPORT
Import Expense Reports with Multiple Files > CSV Response Error: This record already exists
Customer added a Custom field in their Expense Report form named 'Reference Number' with function that is the same as Document Number but is assigned by the User and not by the System. This Reference Number field is located at the main line of the form.
CSV Import Inventory Transfer Error: Invalid Item Reference key XXX for Subsidiary XXX
User is trying to import Inventory Transfer records for Inventory Items via CSV Import and getting an error: "Invalid Item Reference key XXX for Subsidiary XXX".
Importing Work Instructions in Work Instructions and Traveler SuiteApp
You can import the work instructions by mapping the fields in the manufacturing routing record of the Work Instructions & Traveler SuiteApp with the mappings in the CSV file.
Resolve error:"You have entered an Invalid Field Value xxx for the following field: debit" on Journal Entry CSV Import
CSV import of Journal Entry throws the error in the CSV Response file.
CSV Import Error: A Saved Search with Internal ID xxx Does Not Exist
The error "A saved search with the internal id xx does not exist" when running a CSV import is triggered by a custom field on the form that pulls its value from the result(s) of a saved search.
CSV Import Update of Assembly Item Results to an Unexpected Error
User is updating Assembly Item via CSV Import by navigating to Setup > Import/Export > View CSV Import Status.
Resolve Error: "Invalid Reference Key XXX Accounts Payable for Subsidiary X" on Purchase Order CSV Import
When uploading a Purchase Order via CSV Import and the errorInvalid Reference Key XXX Accounts Payable for Subsidiary Xis encountered, this is because the Accounts Payable used is not available on the User Interface. This is usually populated by an Asset or an Expense account. Field mapping as follows:
Update Hold Field on Customer Record in Bulk Via CSV Import
Scenario
Solution
- Create a CSV File with the Internal ID of the Customers to be updated
- Navigate toSetup>Import/Export>Import CSV Records
- Scan & Upload CSV File:
- Import Type:SelectRelationships
- Record Type:SelectCustomers Only
- Select the CSV File
- ClickNext
- Import Options:
- Data Handling:SelectUpdate
- ClickNext
- Field Mapping:
- NetSuite Fields: SelectInternal ID
- Your Fields: SelectInternal ID
- NetSuite Fields: SelectHold
- Click thePencil Icon
- Default Value:SelectProvide Default Value
- SelectOn
- ClickDone
- ClickNext
- Save Mapping & Start Import:
- Import Map Name:EnterName
- ClickSave & Run
Special Characters Are Not Displayed Correctly in the CSV Error File for Failed Bank Data Import
You are using a non-English language as your preferred language in the NetSuite user interface, or your bank statement file contains special characters. Example, .
Bank Statement CSV File Upload Failure Reason: Unexpected Error
A Microsoft Excel CLEAN function can help to efficiently check and remove all the nonprintable characters from string in the Memo column.