Resolve Error: "Invalid Reference Key XXX Accounts Payable for Subsidiary X" on Purchase Order CSV Import
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:
Create a Purchase Order via the User Interface:Transactions>Purchases>Enter Purchase Orders
Use theStandard FormunderCustom Form
UnderVendor> Select a Vendor
Subsidiarywill be automatically populated
UnderExpensestab >Accountsub tab > look for theAccounts Payablementioned in the error > this would not be existing
To resolve:
Use an expense/asset Account for Purchase Order Expenses: Account field