Saturday, March 9, 2019

CSV Import of Purchase Orders > error: Invalid entity reference key xxx

1. Vendor names on the CSV file must be entered the same way they appear on the Vendor field of the Transactions > Purchases/Vendors > Enter Purchase Orders page. If Auto-Generated Numbering is set to True (Setup > Company > Auto-Generated Numbers > Entities tab > Enable box is checked for Vendor), the format will be Vendor Id<space>Vendor Name.

2. Internal Id's of the Vendors can also be used. If the CSV file contains the Internal Id's, make sure that on the Field Mapping page of the CSV import, click the pencil icon besides Vendor field mapping and choose Internal Id under the Choose Reference Type dropdown.

3. If Vendor records are entered via CSV Import and External Id's are assigned to them, this can also be used. On the Field Mapping page of the CSV Import, just click the pencil icon besides the Vendor field and choose External Id under the Choose Reference Type dropdown.

4. Vendor records should also be Active at the time of Purchase Order import. Navigate to Lists > Relationships > Vendors and check the Show Inactive box to see if there is a check mark besides the Vendor name.

No comments:

Post a Comment