Tag: csv import issue

Common NetSuite CSV import errors and how to solve them

Invalid Field Mapping: Error: This error occurs when the CSV file contains column headers that do not match the field names in NetSuite. Solution: Ensure that the column headers in your CSV file match the field names exactly as they appear in NetSuite. Check for any typos or extra spaces. You can use the NetSuite… Continue reading Common NetSuite CSV import errors and how to solve them

Invalid custitem reference key error on item update import

While updating item record using import, some times error occurs as follows. Here download details 1 is mapped to Specification sheet 1(custitem_jj_spec_sheet_1) field in Netsuite. Mapping is given below. Solution: Update the csv template , add internal id of the pdf file instead of name. Map the id to the corresponding field . Click on… Continue reading Invalid custitem reference key error on item update import

Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry

To correct the error message “Invalid subsidiary reference key xxx” when importing Journals: 1. Verify that the subsidiary is an active and existing subsidiary by navigating to Setup > Company > Subsidiaries. The subsidiary should be spelled the way it is spelled in the record. It is also possible to export the list of subsidiaries to get the correct format. If the Subsidiary… Continue reading Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry

Rectify Error: The Record can only be edited/created through User Interface

When Importing the Landed Cost template, may encounter the error “the record can only be edited/created through User Interface” This can be avoided by unchecking the “Run Server Suitescript & trigger workflows” box in the import assistant “Advanced Options”. This is also applicable for landed cost template Detail and Landed cost Template mapping imports.