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