Basic Information

The GL Account Verification Report in Accounts Payable identifies General Ledger 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 it can't find the assigned account in General Ledger.

It verifies the following fields:

• Expense Account
• Accounts Payable Account
• Retainage Payable Account
• Misc Deduction Credit Account (you may have renamed AP Misc Deduction in Custom Descriptions)

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 the correct fix for this issue:
   • Add the missing account to the invoice distribution
   • Delete the distribution if it's a "blank distribution line" (an extra distribution)
3. 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 doesn't exist in General Ledger.

1. Determine if the account number is the correct number to use.
2. If it's incorrect, use AP Tasks, Change Invoices to correct the account.
    NOTE: Depending on the account type, it may have been retrieved from an incorrect setup that you need to fix. 
3. If the account number is correct, determine if the account existed previously and was deleted, or if it hasn't been set up yet.
   • Did the account exist in General Ledger?
     1.  Go to General Ledger, Inquiry, Entries.
     2. Select the Current file.
     3. Add a condition for the account number.
     4. Repeat these steps, but select the History file.
     5. If you receive any results, then the account existed at some point in General Ledger. See steps to recreate a deleted General Ledger account.
     6. If you don't receive results, 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.