Invoice Aging Report (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Invoice Aging Report

Use this report to analyze the cash flow of your unpaid invoices. This report provides information about invoice payments due within four time periods you specify in the Aging Periods window.

The report does not include cancelled invoices.

Prerequisite

Aging Periods

Report Submission from Payables

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Sort Invoices by. Enter the sort option for this report.

Invoice Type. Sort the Invoice Aging Report by invoice type. Payables displays each invoice type in a separate supplier grouping.

Supplier Name. Sort the Invoice Aging Report alphabetically by supplier name. Payables displays different invoice types in the same supplier grouping.

Summary Type. Enter the summary option for this report:

Invoice. Payables displays each invoice number when calculating the total invoice payments due to a supplier.

Supplier. Payables displays the total invoice payments due to a supplier without displaying each invoice.

Report Format. Enter the format for this report:

Brief. Payables displays the name of each supplier without displaying a supplier's city and state.

Detailed. Payables displays the city and state for each supplier in addition to the supplier name.

Minimum Amount Due. Payables includes invoice information for invoices that have invoice amounts greater than this Minimum Amount Due and that fall within the aging period you specify.

Maximum Amount Due. Payables includes invoice information for invoices that have invoice amounts less than this Maximum Amount Due and that fall within the aging period you specify.

Invoice Type. Enter the type (Credit Memo, Debit Memo, Expense Report, Interest, Mixed, Prepayment, or Standard) for the invoices you want to review, or leave this field blank to print this report for invoices with all invoice types.

Supplier Name. If you want to submit this report for only one supplier, enter the supplier name.

Aging Period Type. Enter the aging period you want to use for your Invoice Aging Report. The report displays invoice payment information for the first four periods that you defined for this Aging Period in the Aging Periods window.

Selected Report Headings

Due Date. Date an invoice is due, assuming no discounts are taken.

Payment Number. Scheduled payment number of an invoice.

Days Due. Number of days until an invoice is due. For example, 30 Days Due describes an invoice that was due 30 days ago, and -30 Days Due describes an invoice that will be due 30 days after today.

% Unpaid. Percent of an invoice that remains unpaid. The total amount of an invoice equals the Amount Remaining divided by the % Unpaid.

Amount Remaining. Amount remaining for payment. The total amount of an invoice equals the Amount Remaining divided by the % Unpaid.

If you are using multiple currencies, Payables converts invoice amounts into your functional currency for this report.