CSV Import > Customer > Custom Multi-Select Field > Error: Invalid CustEntity Reference Key xxx

Scenario

User is getting an error whenever a CSV Import to update a multi-select field is done.

Solution

1. Open the CSV file.

2. Check the values entered in the CSV file.

3. Make sure the values are consistent with the values in NetSuite:

   • Consistency of spaces before and after the values.

   • Ensure values are spelled correctly.

   • Check consistency of uppercase and lowercase letters

   • Make sure values exist in NetSuite, and add to the list if necessary

   • When importing multi-select fields, check that the multi-select value delimiter specified in the import advanced options matches the delimiter used in the CSV file.