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.

  1. Vendor names in the CSV file must be entered the same way they appear in the Vendor field on the Transactions > Purchases > Enter Purchase Orders page. If auto-generated numbering is enabled, the format will be Vendor ID Vendor Name.

  2. The vendor record must be active. Go to List > Relationships > Vendors and check the Show Inactive box to see if the vendor is inactive.

  3. Internal IDs of the vendors can also be used. If the 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.

  4. External IDs of the vendors can also be used. If the CSV file contains the external IDs, on the Field Mapping page, click the edit icon beside the Vendor field, click Choose Reference Type, and select External Id.

Related Topics

General Notices