How to interpret the results of the GL Account Verification Report in Accounts Payable
Description
Cause
Resolution

The GL Account Verification Report in Accounts Payable is used to identify GL account errors on invoice distributions. (AP Reports, GL Reconciliation, GL Account Verification Report)

The report checks if a distribution is missing a GL account or if the account assigned is not found in General Ledger. The account fields it is verifying are:

  • Expense Account
  • Accounts Payable Account
  • Retainage Payable Account
  • Misc Deduction Credit Account (you may have named AP Misc Deduction to something else in Custom Descriptions, such as, Workers' Comp)

Account column shows XXXX:

  1. If the report shows XXXX under the account column, this means this field is blank on the distribution line referenced under the Seq column.
  2. Determine if the missing account should be added to the invoice distribution or if this is a "blank distribution line" (an extra distribution) that should be deleted. Use AP Tasks, Change Invoices to correct the invoice.

Account column shows an account number:

If the report shows an account number under an account column, this means that the account number shown is not found in General Ledger.

  1. Determine if the account number is the correct number to use.
  2. If it is incorrect, use AP Tasks, Change Invoices to correct the account. Depending on which type of account it is, the account may have been retrieved from somewhere in the setup that will also need to be corrected (i.e. AP Settings, GL Entry Settings).
  3. If the account number is correct, determine if the account previously existed in General Ledger but was deleted or if it has not been set up yet.
    • To determine if the account has ever been used, in General Ledger select Inquiry, Entries, select the Current file, then add a condition for the account number. Then repeat these steps but select the History file. If you receive any results, that means this account has been used. Refer to article 17701 DocLink: How do I recreate a deleted General Ledger account?
    • Otherwise, simply set up the account in General Ledger. (GL Setup, Accounts)

Account column is blank:

If an account column is blank, there are no issues found with this account field on the distribution.


[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles