Aged Accounts Payable Report

This report shows the aging of payable accounts. The program calculates aging from the due date, posting date or document date depending on your choice on the Options tab. You must specify the date you want aging calculated from and the length of the period each column will contain data for. If you leave the Print Amounts in LCY field blank, the report will summarize payables per currency code at the bottom of the report.

You can define what is included in the report by setting filters. You can add fields to the Vendor tab by clicking the Field field, pressing F3 and then clicking the AssistButton that appears to the right. Fill in the fields as follows:

Vendor

No.: Enter the numbers of the vendors you want to include in the report.

Options

Aged as of: Enter the date that you want the aging calculated for.

Aging by: Select whether the aging will be calculated from the due date, posting date or document date.

Period Length: Specify the length of each of the three periods, for example, enter "1M" for one month.

Print Amounts in LCY: Place a check mark in this field if you want the report to specify the aging per vendor ledger entry.

Heading Type: Select whether the column heading for the three periods will indicate a date interval or the number of days overdue.

New Page per Vendor: If you have chosen two or more vendors to be included in the report, enter a check mark to print each vendor balance on a separate page.



© 2009 Microsoft Corporation. All rights reserved.