Scenario
User is trying to import a data through CSV but gets an error message stating: “Invalid entity reference key xx for subsidiary yy.”
Solution
The numbers (xx and yy) found in the error are the Internal IDs of the Entity record (Customer, Vendor, Employee, Other Name) and Subsidiary respectively that are found in NetSuite account
1. To view the records indicated in the error:
1.Navigate to Home > Set Preferences > General tab
2. Set Show Internal IDs = True
3. Click Save
2. Check Subsidiary record:
1. Navigate to Lists > Search > Saved Searches > New > Subsidiary
2. Under Criteria tab > Standard sub tab > add Internal ID (Number) = yy
3. Click the Preview button
3. Check Entity record:
1. Navigate to Lists > Search > Saved Searches > New > Entity
2. Under Criteria tab > Standard sub tab > add Internal ID (Number) = xx
3. Hit the Preview button
4. To resolve the issue:
1. Entity record referred to in the error:
- Must be Active
- Must have the same Subsidiary value as that of the transaction
2. For CSV Import:
- Entity value specified in the CSV file must have the same format as seen in the User Interface (UI) or
- Enter the Internal ID instead of the entity name in the CSV file
- Depending on what is on the file, during mapping, set the Reference Type to either Internal ID or Names by clicking on the Pencil Icon beside the Entity file