Friday, February 22, 2019

CSV Import update of an Item record generates the CSV Response error: Invalid stockunit reference key xx for unitstype <NULL>

CSV Import update of an Item record generates the CSV Response error: Invalid stockunit reference key xx for unitstype <NULL>.

The error is received when the Stock Units field is updated without mapping the Units Type field. This is based on the scenario that the Units Type field = Null (Blank) on the Item record. To resolve this include the Units Type field in the Field Mapping as shown below:

Internal ID
        ó        Internal ID
Stock Units      
ó        Stock Units  
Units Type       
ó        Units Type

In the UI a user won't be able to select values for Stock, Purchase and Sale Units without first selecting a value in the Units field.

No comments:

Post a Comment