The Payables Aging Report gives you a current Accounts Payable Aging Analysis. Use this report before paying bills to help you decide what should be paid.

The Gross and Net amounts displayed on the reports denotes the Original amounts before any payments were applied. The Check and Check Date columns show a check number and date if a payment has been applied. This is only a reference item and does not affect the amounts shown. If more than one check has been applied (or a check has been applied and then voided) the message "Multiple Checks" will be displayed rather than the check number and date. To see what checks have been applied, please refer to "Payables Review" (7.3.1).

You may have this report Age by Due Date, Invoice Date or Discount Date. This report may be sorted by the Date, Invoice Number or Payable Number.

The First Date is defaulted to the system date. The Second, Third, and Forth Dates are defaulted to one-week intervals. This allows you to view what is due now, next week, etc.

You have an option to include Discounts amounts on the Report. This shows the remaining Net (Gross - Discount) rather than just the Gross Amounts. An asterisk (*) will indicate those items that a discount is taken off the Gross Amounts.

You may print the report for a specific Accounts Payable Account and Accounts Payable Location. The AP Location criterion is very useful if you enter an AP Account with the location number (example: 2000-2).

Using this selection effectively requires entering “All Vouchers” in “Voucher Entry” (7.1.1 field 12) with the AP Account and AP Location. You must enter “Y” to Multiple Account Payable Accounts in “Accounts Payable Setup” in SYSTEM MANAGEMENT (10.2.1 field 5) to make the AP Account field accessible.

The following 2 prompts are available in the Payable Aging Report:

Age Report as of Acct Period

Age Report as of Date Posted

These options allow you to recreate an Aging report for a previous period, or prior to a particular date. If all things were perfect, the report would match a report run previously at the end of the same period. However, due to the nature of A/P and an open item system in general, it is likely that the reports will not be identical. Examples:  Payables posted into future accounting periods could be paid early. When checks are voided, the resulting journal could be placed into any accounting period that the user desires, including a future period. Some notes have been added to the <D>etail version of the report when individual Payable Amounts are not "normal", such as those situations in the examples just listed.

The primary goal of “As of Accounting Period” is to balance to the General Ledger. Barring other Non-A/P Journal Entries to the Accounts Payable account(s), this should be an accurate reflection of the A/P Detail that comprises the A/P Ending Balance in G/L for the requested Accounting Period. The "As of Date Posted" version would be most useful for checking the aging for a recent date, perhaps if the user normally runs the aging once per week, and forgot to run it the previous week. This specific option is not recommended as a balancing tool to G/L for prior periods.

The Payable Aging Report may be sent to the <P>rinter, viewed on the <S>creen or download to a <F>ile.

Since this report is a 132-column report, you must have an AccuTerm© station or a terminal (example: ADDS) capable of viewing this size report for this feature to work. Compress codes must be setup in “Port Entry” in POINT OF SALE (1.10 or 10.2.6.1) for viewing to work properly.

You may download the Payable Aging Report to a Windows© file. The purpose for downloading is for integration with MS Word©, Excel©, or other programs you want to use the data in.

Enter an <F> to capture the file - DISP.RPT.RAW. The ID will be the program concatenated to the port (example ORDER.RPT10, where 10 is the port number). Once the file is displayed on the screen, enter <D> to download. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” in POINT OF SALE (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example:  PAYABLE.AGING.RPT10.TXT, where 10 is the port number or PAYABLE.AGING.RPT10TAB.TXT for the TAB Delimited file name.