CSV Import: Sales Order > Error: Invalid item reference key xx.

Recommendations:

1. The CSV Import file should contain the same Item Name format as shown in Transactions > Sales > Enter Sales Orders > Items tab > Items subtab> Item drop down field. 

2. Internal ID can also be used instead of Item Name. Just make sure that on the field mapping page, click on the pencil icon beside the Item field and ChooseReference Type = Internal ID.

3. Verify if the item is Inactive. If the Item record is inactive, set it to active status before importing.

-Navigate to Lists > Accounting Items.

-Check the ShowInactives box.

-Uncheck the Inactive box beside the Item Name.

-Click on Submit.

Leave a comment

Your email address will not be published. Required fields are marked *