Run ageing reports

You can use multiple Supplier ledger ageing reports, depending on such factors as the currency in which you would like to view outstanding and past due balances in, and whether balances will be broken down by days outstanding or days past due.

Introduction

You can use multiple Supplier ledger ageing reports, depending on such factors as the currency in which you would like to view outstanding and past due balances in, and whether balances will be broken down by days outstanding or days past due. This topic provides instructions for using the following reports:

Run Aged past due

  1. Go to the Aged past due (AP631000) window.

  2. In the Report format field, select one of the following options:

    • Detailed: To view the past due documents on the selected ageing date
    • Summary: To view the past due balances on the selected ageing date

  3. Select a supplier class, or leave the Supplier class field blank to view information on all the classes.

  4. Select a supplier, or leave the Supplier field blank to view information on all the suppliers.

  5. In the Ageing date field, select the date the system will use to calculate the ageing categories for documents.

  6. Click Run report.

    The report displays the list of the suppliers with past due balances. Balances are broken down by days past due on the specified date, and all amounts are displayed in the base currency.

Run Aged past due (MC)

  1. Go to the Aged past due MC (AP631100) window.

  2. In the Report format field, select one of the following options:

    • Detailed: To view the past due documents on the selected ageing date
    • Summary: To view the past due balances on the selected ageing date

  3. Select a supplier class, or leave the Supplier class field blank to view information on all the classes.

  4. Select a supplier, or leave the Supplier field blank to view information on all suppliers.

  5. In the Ageing date field, select the date the system will use to calculate the ageing categories for documents.

  6. Click Run report.

    The report displays the list of the suppliers with past due balances, which are broken down by days past due on the specified ageing date. The amounts are displayed in the documents’ currencies and in the base currency.

Run Aged outstanding

  1. Go to the Aged outstanding (AP631500) window.

  2. In the Report format field, select one of the following options:

    • Detailed: To view outstanding documents on the selected aging date
    • Summary: To view outstanding balances on the selected aging date

  3. Select a supplier class, or leave the Supplier class field blank to view information on all the classes.

  4. Select a supplier, or leave the Supplier field blank to view information on all suppliers.

  5. In the Ageing date field, select the date the system will use to calculate the ageing categories for documents.

  6. Click Run report.

    The report displays the list of the suppliers with outstanding balances, which are broken down by days outstanding with respect to the specified ageing date. The amounts are displayed in the base currency.

Run Aged outstanding (currency)

  1. Go to the Aged outstanding (currency) (AP631600) window.

  2. In the Report format field, select one of the following options:

    • Detailed: To view outstanding documents on the selected ageing date
    • Summary: To view outstanding balances on the selected ageing date

  3. Select a supplier class, or leave the Supplier class field blank to view information on all the classes.

  4. Select a supplier, or leave the Supplier field blank to view information on all suppliers.

  5. In the Ageing date field, select the date the system will use to calculate the ageing categories for documents.

  6. Click Run report.

    The report displays the list of the suppliers with outstanding balances, which are broken down by days outstanding with respect to the specified ageing date. The amounts are displayed in the documents currencies and in the base currency.

Aged period sensitive

  1. Go to the Aged period sensitive (AP630500) window.

  2. Select the financial period. The system uses the selected period to calculate the ageing categories for the documents.

  3. In the Report format field, select one of the following options:

    • Detailed: To view past due documents on the last day of the selected financial period
    • Summary: To view past due balances on the last day of the selected financial period

  4. Select a supplier class, or leave the Supplier class field blank to view information on all the classes.

  5. Click Run report.

    The report lists suppliers with past due balances, which are arranged by days past due on the last day of the specified period.

    All the amounts are displayed in the base currency.

Last modified February 19, 2026