Resolve Error: "Invalid Reference Key XXX Accounts Payable for Subsidiary X" on Purchase Order CSV Import

Written by
Pattranit Lakhan
Published on
May 30, 2023 at 2:56:34 AM PDT May 30, 2023 at 2:56:34 AM PDTth, May 30, 2023 at 2:56:34 AM PDT

Scenario

When uploading a Purchase Order via CSV Import and the errorInvalid Reference Key XXX Accounts Payable for Subsidiary Xis encountered, this is because the Accounts Payable used is not available on the User Interface. This is usually populated by an Asset or an Expense account. Field mapping as follows:

XXX Accounts Payable =Purchase Order Expenses: Account field

Solution

To verify:

  1. Create a Purchase Order via the User Interface:Transactions>Purchases>Enter Purchase Orders

  2. Use theStandard FormunderCustom Form

  3. UnderVendor> Select a Vendor

  4. Subsidiarywill be automatically populated

  5. UnderExpensestab >Accountsub tab > look for theAccounts Payablementioned in the error > this would not be existing

To resolve:

  1. Use an expense/asset Account for Purchase Order Expenses: Account field