Aging Report
Jump to navigation
Jump to search
Overview of AP42
The A/P Aging Report is a list of all open (unpaid) vouchers and credit memos in the Accounts Payable system along with an aging breakdown: either "Current" or one of four aging periods. The report output displays the vendor number and name, voucher due date, voucher number, source, amount, total paid, current, 1-30 days, 31-60 days, 61-90 days and 91+ days overdue, along with the total amount due.
- From the DDI Connect main menu, double-click Accounts Payable
- Double-click Reports
- Double-click Aging Report. The parameters screen will launch:
The following fields are available on this screen:
| Field | Description |
|---|---|
| Reporting mode | Select either current or historical |
| # Days in aging period | Enter the number of days you wish to use for each reporting period (15, 30, 60, etc.) |
| Date on which vouchers are to be paid | Enter the date through which the vouchers are due to be paid. You can enter the date in mm/dd/yyyy format or click the calendar icon to select the date |
| Omit vouchers due after this date | If selected, open items that are dated beyond the date selected in the previous field will not appear on the report output |
| Report order | Select the sort order you wish to use for the report output |
| Checking account | Click the drop down arrow to select the checking account that you wish to report against |
| AP account | Click the drop down arrow to select the A/P account that you wish to report against |
| Voucher Status | Select the option for the voucher status that you wish to report against |
| Vendor ID | If you wish to report only on open items for a particular vendor, you can do that here. Type the vendor ID or click the list icon to select from a list of vendors in the system. Leave the field blank to report on all vendors |
| Print vendor address | If selected, the report output will contain the vendor address information |
| Group by checking account | If selected, the report output will be grouped by checking account |
| Approval level | Select the approval level you wish to report against |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
| Option | Description |
|---|---|
| Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
| Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
| Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
| View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
| Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
| Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
| Print via PDF | Prints directly to your printer. |
| This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
| Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
| Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
| Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
| No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
| Extra copies | If you want extra copies of the report generated, type the number in this field |
Click Start. The system will generate the report based on the parameters you selected, and display the results. Click below to view a sample of this report.
