Print Aged Trial Balance (AP83)

The Print Aged Trial Balance (AP83) produces an aging report by Vendor in summary or listing all Invoice/Payment details.

The Aged Trial Balance uses the Invoice's GL Posting Date (stored inside the AP Invoice record) to qualify records selected for reporting. In cases where the Invoice's GL posting date is prior to the Invoice date, and the aging report specifies a date 'as of' or 'prior to' the GL Posting Date, the Invoice is not reported.

1. The Printer Selection screen automatically opens. Select the device destination and click OK.

2. The Report Parameters screen for AP83 opens.
   • The Format field defaults to 'Accounts Payable Aged Trial Balance'.

   • The Sequence field defaults to 'Vendor'.

   • If a New Page for each Break is required, select the check box.

   • The Levels list box displays the various Levels of detail available for the report. All Levels are automatically selected in AP83; the '>' before each Level option indicates the Level is selected. Double click on the line to remove the selector. AP83 includes the following Levels:
     • Detail Line
     • Vendor
     • Report

   • Select the Restrictions that apply to the Aged Trial Balance Report by double clicking on the line in the list box. Restrictions allow you to tailor AP83 to your specific needs. The '>' before a Restriction indicates the Restriction is selected. Once a Restriction is selected, it can be de-selected but the '>' remains. An '*' before a Restriction means the Restriction is mandatory. AP83 includes the following Restrictions:
     • Show Zero Balances - is a mandatory Restriction. This check box is selected by default so that all Invoices dated up to and including the 'As of Date' are reported even if their outstanding balance is zero (Invoice is paid). If you want to report only Invoices with an outstanding balance, de-select this field.

     • Bank Account String - the Aged Trial Balance reports Invoices across all AP Banks by default. This Restriction allows you to limit the reporting of Invoices to the specific AP Bank Codes you require. Enter or select from the query each Bank Code you want to see on the report. Click OK when all of the Banks are added.

     • Enter As of Date - is a mandatory Restriction. Enter or select from the query a Date which will set the date up to and including which Invoices are reported. This date also dictates how the aging of Invoices on the report is calculated; each Invoice's due date is compared to the 'As of Date' to determine its aging status for the 'Due by Date' summary at the end of the report.

     • Suppress Paid Detail - by default, the Aged Trial Balance reports the payment details (if any) as lines after each Invoice. If you want to suppress the details and produce a report with only one line per Invoice, then select this check box.

     • Invoices on Hold - select this check box to produce a listing of Invoices that are currently on Hold in the AP Open Invoices file. Invoices are put on Hold by Enter Invoices (AP30) during Invoice entry using the 'Hold Invoice' option.

     • Select Branch Code - enter or select from the query a Branch Code for this report. When an Invoice is posted in AP30, it can be assigned to a specific Branch. By default, the Aged Trial Balance reports the Invoices posted against ALL Branches. You can limit the reporting to a specific Branch using this Restriction.

     • Select Creditor Class - enter or select from the query a Creditor Class for this report. Vendors are assigned their Creditor Class in Maintain Vendors (AP13). By default, the Aged Trial Balance reports all Creditor Classes. You can limit the reporting to a specific Creditor Class using this Restriction.

     • Currency to Use - when foreign Invoices are posted by AP30, the Exchange Rate (from Maintain Currency Table (CC22) for the Currency Code associated with the Bank set in Maintain Bank Codes (AP01)) is recorded in the transaction. By default, the Aged Trial Balance reports the domestic equivalent value of an Invoice using the Exchange Factor. If you want to report the domestic equivalent using the current Exchange Factor in CC22, select the 'Current Currency Rate' option. If you want to report the domestic equivalent using the rate at the time the Invoice was posted, select the 'Invoice Currency Rate' option.

     Note: To modify a Restriction once it is set up, reselect the Restriction and make the necessary changes.

   • Select the Range From and To for the report. The Range must match the Sequence selected. Multiple Ranges may be entered.
     • In the From field, enter the starting 'code' for the report.

     • In the To field, enter the ending 'code' for the report.

     • The information displays in the list box below.

     • To add additional Ranges, repeat these steps.

       Note: To print the entire file (e.g. all Vendor Codes), simply tab through the From and To fields. The list box displays *Start and *End in the From and To fields.

     • To delete a Range from the list box, double click on the line. The following message displays, "Do you wish to delete this range? Yes/No". Click Yes to delete the range.

   • When all of the information on the Report Parameters screen is complete, click OK to run the report.

3. The Report Complete screen opens when the report is generated. Enter the Acceptance Codes to accept the report (if applicable), click Restart to restart the printing of the report, or click Abort to cancel the report.

^{Print Age Trial Balance Report Parameters screen (AP83)}