Save Vendor Bill with Error: Invalid Account reference key xxx for entity xxx
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:
- 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
- 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
I. Show the Internal IDs
- Navigate to Home > Set Preferences > General tab > Defaultssection
- Mark the Show Internal IDs check box
- Click Save
- Navigate to Setup > Accounting > Chart of Accounts
- Mark the Show Inactives checkbox
- On the Internal ID column, check the Account in question