Supplier Balance Aging Report

Use the aging report to view the supplier balances according to specified aging periods. The report provides the breakdown of the Payables supplier balance across aging buckets that you configure in the aging periods.

If you use multiple currencies, the report converts the invoice amounts to the ledger currency using the conversion rate provided on the invoice.

You can run this report from the Manage Scheduled Processes page.

Before running this report, create the invoice aging periods on the Create Aging Periods page and run the Create Accounting process with the option to transfer the balances to General Ledger.

Parameters

Ledger (Required)

Specify the name of the ledger.

Business Unit

Specify the business unit.

Include Invoice Detail

  • Yes: Lists invoice detail when showing invoice payments due to a supplier

  • No: Summarizes the total invoice payments due to a supplier without listing each invoice.

Include Supplier Site Detail

  • Yes: Lists supplier site detail.

  • No: List the name of the supplier.

Invoice Type

Select an invoice type, such as Standard or Credit Memo, or leave blank to run the report for all invoice types.

Party Name

Specify the name of a supplier or party.

Aging Period (Required)

Specify the name of an aging period that was defined on the Create Aging Periods page.

Balance As-of Date (Required)

Enter the balance effective date for the supplier invoice status that you want to analyze.

Account Range

Enter the supplier liability accounts that you want to be considered for the report.