Purchase Order Import Errors
This section describes errors that you may see on a purchase order import. For more information, see Invalid entity reference key xxx.
Invalid entity reference key xxx
To correct the error, verify the following.
-
VMake sure vendor names in your CSV match exactly what you see in the Vendor field on the Transactions > Purchases > Enter Purchase Orders page. If auto-generated numbering is enabled, use the format Vendor ID Vendor Name.
-
The vendor record must be active. Go to List > Relationships > Vendors and check the Show Inactive box to see if the vendor is inactive.
-
You can also use vendor internal IDs. If your CSV file contains the internal IDs, on the Field Mapping page, click the edit icon beside the Vendor field, click Choose Reference Type, and select Internal Id.
-
External IDs of the vendors can also be used. If the CSV file contains the external IDs, do the same, but select External Id instead.