How To CSV Import: Sales Order > Error: Invalid item reference key xx.
How To CSV Import: Sales Order > Error: Invalid item reference key xx.
- The CSV Import file shouldcontain the same Item Name format as shown in Transactions> Sales> Enter Sales Orders > Items tab > Items subtab> Item drop down field.
- Internal ID can also beused instead of Item Name. Just make sure that on the field mapping page, clickon the pencil icon beside the Itemfield and ChooseReference Type = Internal ID.
- Verify if theItem is Inactive. If the Item record is inactive, set it to active statusbefore importing.
-Navigate to Lists > Accounting > Items.
-Check the ShowInactives box.
-Uncheck the Inactive boxbeside the Item Name.
-Click on Submit.