CSV Import Inventory Transfer Error: Invalid Item Reference key XXX for Subsidiary XXX

Written by
Pamela Caringal
Published on
June 30, 2023 at 9:29:57 AM PDT June 30, 2023 at 9:29:57 AM PDTth, June 30, 2023 at 9:29:57 AM PDT

Scenario

User is trying to import Inventory Transfer records for Inventory Items via CSV Import and getting an error: "Invalid Item Reference key XXX for Subsidiary XXX".

Solution

There are instances when doing CSV Import involving Inventory Items where Item Name/Number column in the CSV file is not going through resulting to the aforementioned error message. An alternative solution is to re-process the import with the Item Name/Number column updated/revised to include the Display Name/Code.

If the user already have an existing Item Saved Search of the items included in the Inventory Transfer being imported, the user may include the Display Name field in the results. Afterwards, user will export the file and concatenate the column for Item Name/Number and Display Name/Code to combine them in one column.