Save Vendor Bill with Error: Invalid Account reference key xxx for entity xxx

Written by
Pattranit Lakhan
Published on
December 22, 2023 at 10:01:13 AM PST December 22, 2023 at 10:01:13 AM PSTnd, December 22, 2023 at 10:01:13 AM PST

Scenario

There are two scenarios that could trigger the error:

  1. On theVendorrecord >Financialtab, either theDefault Expense AccountorDefault Payables Accountset is set toInactive. In this case, you can either:
    • Activate the Account or;
    • Change the Default Expense/Payable Account on the Vendor record
  2. On theAccountrecord >Subsidiariesbox, the Subsidiary of the Account is not included on the Subsidiaries added on the record of the Vendor selected on the Bill.In this case, you can either:
    • Include the Subsidiary of the Vendor on the Account's Subsidiary dropdown/list or;
    • Change the Account's Subsidiary restriction to Parent Subsidiary and mark theInclude Childrencheckbox

Solution

To verify the status of the Account:

I. Show the Internal IDs
  1. Navigate to Home > Set Preferences > General tab > Defaultssection
  2. Mark the Show Internal IDs check box
  3. Click Save
II. Check the Account affected
  1. Navigate to Setup > Accounting > Chart of Accounts
  2. Mark the Show Inactives checkbox
  3. On the Internal ID column, check the Account in question