Aged A/P Detail


Accounts Payable Menu -> A/P Reports -> Aged A/P Detail

This report can be run for the current period or with past dates. It uses the payment history to reconstructs the past" status of the invoices.
For each vendor, it lists the invoices owing vendor, then it prints the amounts owing in the four aging categories: Current, 31-60 days, 61-90 days, and over 90 days, that can be based on the Invoice, Posting, or Due date.
On the report output Totals are provide by aging period along with percentage totals for each period.
Aging Totals at the invoice level are also print on the spreadsheet output but totals at the Vendor level are optional.

Note: This report does respect the operators's Divisional Restricted Views.

The prompts are:

CUT-OFF DATE
Accept today's date for the cut-off date or over-type it with the correct date.
This date determines which invoices are included in the report according to the selection made for the Date To Use below.

AGE AS OF MONTH END
Aging refers to the grouping of the invoices by date, as in Current, 31-60, 61-90 and Over 90 days.

Check this box to age the invoices as of the end of the current month.
Uncheck this box to age the invoices by the actual date instead of month end.


DATE TO USE
When invoices are entered in A/P Invoices, three different dates can be captured for each invoice.
Select one of those three dates to determine how the vendor account aging is reflected on this report:
  • Click Posted to base the aging categories on the date entered as the date the invoice was posted.
    i.e. Invoices with a Posting Date later than the Cut-Off Date will NOT be included on the report.
  • Click Invoice to base the aging categories on the date entered as the invoice date.
    i.e. Invoices with an Invoice Date later than the Cut-Off Date will NOT be included on the report.

  • Click Due to base the aging categories on the due date entered for each invoice.
    i.e. Invoices with a Due Date later than the Cut-Off Date will NOT be included on the report.


STARTING NAME
Leave this field blank to print all accounts, or select a starting Vendor Name from the Vendor Search window.

ENDING NAME
Leave this field blank to print all accounts, or select an ending Vendor Name from the window, for the report selection.

CURRENCY CODE
Check this box to include all currencies.

Uncheck this box to specify a single currency for the report.

CURRENCY CODE
Enter the desire currency or select one from the drop-down list.

DIVISION, "ALL" OR "SEL"
  • Type ALL to include all divisions in the report.
  • To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
  • Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined in Division Select By Region.

The divisions included in the report output are restricted by the Access Values assigned to the operator.
For more information on this security feature refer to Divisional Restricted Views.


PRINT ZERO BALANCE TRX
Uncheck this box to omit vendors with outstanding balances if the account total nets zero.

Check this box to include all vendors with outstanding invoices in the selected range even if the total account balance is zero.
A report printed including these transactions will match the Prior Date Summary Report for the same period.


REPORT OPTIONS
This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

An additional column for the P.O. numbers is included on the spreadsheet output.


INCL VENDOR AGING LINE
This selection option is only available with the Excel spreadsheet output.

Check this box to print an extra line for each Vendor with the Aging Totals. The aging at the invoice level will always print.
Uncheck this box if the summarized Aging Totals by Vendor is not required on the output.


Finished?
Click ACCEPT to generate the report, or CANCEL to abort.

Topic Keyword: APAP11
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)