A/P Diagnostics (AP70)

Additional Information
Diagnostics Programs

The AP Diagnostic (AP70) program is used to verify that the Accounts Payable sub-ledger balances to the Accounts Payable control accounts in the General Ledger. Although running this program is optional, good accounting practice dictates that you perform this check as part of your normal month end closing procedure.

AP70 reads through the Outstanding Invoice file and calculates the outstanding balances by bank account as of the Aging Date (i.e., you may wish to run the diagnostic as of a month end even though you are already into the next calendar month). Balances for the AP control accounts in the General Ledger are then calculated as of the Aging Date. Both totals, GL and sub-ledger, are then displayed by bank code.

Note: No printout is generated by AP70.

You may encounter timing issues that result in a out-of-balance condition or in Registers not printing. For more information on balancing issues, see Balance AP to GL.

The following list defines every field on AP70:

  • Aging Date - enter or select from the query the Aging Date required. The AP Diagnostic is typically set to the period ending date of the current period. If the AP Diagnostic reports an out of balance result, you may want to set the Aging Date to the period ending date of the next period or further into the future to troubleshoot the AP sub-ledger/General Ledger timing issues.

  • Diagnostic List Box - displays the balances by bank account from the AP Outstanding Invoice File compared against the AP control accounts in the General Ledger as of the Aging Date entered. This list also includes the Payables Account:

    • Multiple banks can be associated with each payable GL account, and when the payable account is presented for a second (or third, etc.) bank, an asterisk appears beside the payable account number.
    • In the case of multiple payable account records, the GL Balance displays for the first instance of the payable account; the GL Balance for the second (or third, etc.) instance is set to 0.00.

The following table outlines the functionality of each button in AP70:

Button Label Icon Functionality
Start Diagnostic Start Diagnostic Starts the AP Diagnostic. When the Diagnostic program is complete, the Diagnostics list box is updated with the bank balances and company total.
Return to Menu Return to Menu Closes the AP70 program and allows you to return to the Enterprise Main Menu.

AP70
AP Diagnostic (AP70)