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

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

Rookie Asked on December 2, 2020 in Accounting.
Add Comment
1 Answer(s)
  1. The CSV Import file shouldcontain the same Item Name format as shown in TransactionsSalesEnter Sales Orders > Items tab > Items subtab> Item drop down field.
  2. 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.
  3. 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.

Rookie Answered on December 2, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor