Tag: csv import error

CSV import error – Invalid account reference key ___ for subsidiary ___

While importing journal entries, the error “Invalid account reference key ___ for subsidiary ___” may sometimes occur. To resolve this error, Check the below conditions:  Verify the format of the Account field.  Ensure that the account is active in NetSuite.    To verify the format of the Account field in the CSV file by comparing with NetSuite: … Continue reading CSV import error – Invalid account reference key ___ for subsidiary ___

Resolve Special Character error on importing webstore description

Scenario: When we upload files that contains special characters for ex: importing values of html description field having <html> tags. After uploading the file an error will display regarding the special characters. Solution: Choose import character encoding. On the Scan & Upload File page of the Import Assistant, choose the type of character encoding for… Continue reading Resolve Special Character error on importing webstore description

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 parent reference key’ on Item Record Import

The error occurs when the parent item being referenced is of a different item type (for example, Inventory, Description, and so on) than the item being imported. The parent item must be the same type (for example, Inventory, Non-Inventory, Description, and so on) as the items being imported. There are two ways to resolve this… Continue reading ‘Invalid parent reference key’ on Item Record Import

Error in Advanced Intercompany Journal Import

Issue – The user is doing a CSV import for intercompany journal entries but encounters this error: “Transaction was not complete. An intercompany journal entry must have at least four lines: one debit line and one credit line for each subsidiary. Debits and credits must balance within each subsidiary.” Solution – Remove zeros from the Debit and Credit columns of… Continue reading Error in Advanced Intercompany Journal Import