To Run AP Aging Reports

You can use multiple AP aging reports, depending on such factors as which currency 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:

To Run the AP Aging Report in the Base Currency

  1. Open the AP Aging (AP631000) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, select one of the following options:
      • Summary: To view the past due balances on the selected aging date.
      • Detailed: To view the past due documents on the selected aging date.
      • Detailed with Retainage: To view past due documents and their unreleased retainage on the selected aging date.
    2. In the Company/Branch box, select the company or branch for which you want to view information, or leave this box empty to view information on all branches.
    3. In the Vendor Class box, select the vendor class for which you want to view information, or leave this box empty to view information on all vendor classes.
    4. In the Vendor box, select the vendor you want to view information for, or leave this box empty to view information on all vendors.
    5. In the Age as of Date box, select the date the system will use to calculate the aging categories for documents.
  3. On the form toolbar, click Run Report.

    The report displays the list of vendors 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.

To Run the Multicurrency AP Aging MC Report

  1. Open the AP Aging MC (AP631100) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, select one of the following options:
      • Detailed: To view the past due documents on the selected aging date.
      • Summary: To view the past due balances on the selected aging date.
    2. In the Company/Branch box, select the company or branch for which you want to view information, or leave this box empty to view information on all branches.
    3. In the Vendor Class box, select the vendor class for which you want to view information, or leave this box empty to view information on all vendor classes.
    4. In the Vendor box, select the vendor to view information for, or leave this box empty to view information on all vendors.
    5. In the Age as of Date box, select the date the system will use to calculate the aging categories for documents.
  3. On the form toolbar, click Run Report.

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

To Run the AP Coming Due Report in the Base Currency

  1. Open the AP Coming Due (AP631500) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, 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.
    2. In the Company/Branch box, select the company or branch for which you want to view information, or leave this box empty to view information on all branches.
    3. In the Vendor Class box, select the vendor class for which you want to view information, or leave this box empty to view information on all vendor classes.
    4. In the Vendor box, select the vendor to view information for, or leave this box empty to view information on all vendors.
    5. In the Date box, select the date the system will use to calculate the aging categories for documents.
  3. On the form toolbar, click Run Report.

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

To Run the Multicurrency AP Coming Due Report

  1. Open the AP Coming Due MC (AP631600) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, 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.
    2. In the Company/Branch box, select the company or branch for which you want to view information, or leave this box empty to view information on all branches.
    3. In the Vendor Class box, select the vendor class for which you want to view information, or leave this box empty to view information on all vendor classes.
    4. In the Vendor box, select the vendor to view information for, or leave this box empty to view information on all vendors.
    5. In the Date box, select the date the system will use to calculate the aging categories for documents.
  3. On the form toolbar, click Run Report.

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

To Run the AP Aged Period Sensitive Report

  1. Open the AP Aged Period-Sensitive (AP630500) report.
  2. In the Financial Period box, select a financial period. The system uses the selected period to calculate the aging categories for the documents.
  3. In the Report Format box, 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 the vendor class for which you want to view information, or leave the Vendor Class box blank to view information on all the classes.
  5. Click Run Report.

    The report lists the vendors 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.