Reviewing Payables Aging Balances

The payables aging balance feature computes in real time the open invoices, credit notes, and prepayments based on the invoice due date. This page automatically displays the aging for all buyers to which the user has access. Buyers can review aggregate payables or drill down to view, for example, a buyer's aging balance. The system displays amounts in various date range categories to enable in-depth analysis of outstanding balances.

Note: The delivered aging categories are fixed to quickly provide consistent, clear aging information.

This section discusses how to review payables aging balances.

Page Name

Definition Name

Usage

Payables Aging Balance - Inquiry Page

EM_BUY_AGING_BAL

Review the payables aging balance.

Use the Payables Aging Balance - Inquiry page (EM_BUY_AGING_BAL) to review the payables aging balance.

Navigation:

eSettlements > Invoices > Payables Aging Balance > Payables Aging Balance - Inquiry

This example illustrates the fields and controls on the Payables Aging Balance - Inquiry page. You can find definitions for the fields and controls later on this page.

 Payables Aging Balance - Inquiry page

Search Criteria

Field or Control

Description

Buyer and Supplier

Select the buyer and supplier codes. You can populate these fields with partial search information. For example, suppose that the following buyers (business units) exist: BUY01, BUY02, and BUY03. You can search for BUY to view the aging balance for all of the business units that begin with those letters.

Display Currency

Displays the default currency type. The amounts initially appear in the user's preferred currency, which is specified in the user's profile. If you select a new currency, click Convert to display the amounts in that type.

Rate Type

Displays the type of exchange rate used to convert currencies. This is tied to the buyer user's profile and can be changed by the buyer administrator.

As Of Date

Displays the date used to sort the open invoices into aging categories. The system compares the net due date on the invoice against this date.

Chart Style

Specify the chart style. If you select a new style, click Draw Chart to view the chart in that style.

Past Due and Current

Click any amount to view the related payment installments. Open invoices appear in past due and current categories.

Field or Control

Description

Invoices-Approved

Displays the converted amounts of approved invoices by aging date. Attributes of approved invoices are:

  • Approval status A (approved).

  • Positive regular invoices.

  • Not paid.

  • No payment hold enabled.

  • Valid (passed Voucher Build Application Engine process (AP_VCHRBLD) and is in postable status).

  • Not canceled or closed.

Invoices-Not Approved

Displays the converted amounts of unapproved invoices by aging date. Attributes of unapproved invoices are:

  • Approval status P (pending).

  • Positive regular invoices.

  • Not paid.

  • No payment hold enabled.

  • Valid (passed Voucher Build process and is in postable status).

  • Not canceled or closed.

Credit Note

Displays the converted amounts of credit notes by aging date. Attributes of credit notes are:

  • Negative amount regular invoices.

  • Not paid (applied to another invoice in pay cycle).

  • No payment hold enabled.

  • Valid (passed Voucher Build and is in postable status).

  • Not canceled or closed.

Disputed Invoices

Displays the converted amounts of disputed invoices by aging date. Attributes of disputed invoices are:

  • Regular invoice.

  • Not paid.

  • No payment hold enabled.

  • Valid (passed Voucher Build process and is in postable status).

  • Not canceled or closed.

Prepaid Not Applied

Displays the converted amounts of prepayments that have been paid but not yet applied to the final invoice, by aging date. Prepayments are applied when the Voucher Posting Application Engine process (AP_PSTVCHR) is run. Attributes of unapplied prepayments are:

  • Prepayment style invoices.

  • Valid (is in postable status).

  • Paid.

  • Posted.

  • Not applied against invoices.

  • Not canceled or closed.

Note: Prepayment vouchers are applied to invoices when vouchers are posted in PeopleSoft Payables.

Total

Displays the buyer's total outstanding payables, net of credit notes, and prepayments. Click a link in this column to view installment details.