Friday, February 22, 2019

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

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

The error is received when the Sale 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
Sale Units      
ó        Sale Units  
Units Type      
ó        Units Type

Note:
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