Scenario:
The User attempts to import the following invoice record via CSV but receives an error:
Error: Invalid item reference key Item001
Solution:
This error typically indicates that one or more Item values included in the import file do not match the expected format or are referencing an Item that is either inactive or does not exist in the NetSuite environment. As a result, NetSuite is unable to match the provided Item value to a valid record during import.
This issue also occurs when the Item Name or identifier used in the CSV file does not correspond to the correct format that NetSuite recognizes. Alternatively, the Item may be inactive, which also prevents successful referencing during import.
To resolve the "Invalid item reference key xx." error during CSV import of an invoice, the User must verify that all Item values in the import file are valid, correctly formatted, and reference active Items in the system. Follow the steps outlined below:
- Confirm the Correct Item Name Format | Take note that the systemis case-sensitive and requires exact matches. For example, if the item is displayed as InventoryItem: Item001, the CSV file must also contain InventoryItem: Item001 and not just Item001.
- Use Internal ID Instead of Item Name (Optional). Ensure that the CSV file contains the correct Internal ID values for each Item being imported. The Internal ID can be retrieved from a saved search or via Lists > Accounting > Items, and exporting the list with the Internal ID field included.
- Verify Item Status – Ensure Item is Active| If the Item referenced in the CSV file is inactive, NetSuite will not allow it to be used in transactions, leading to the same error.
- Reattempt the Import
