Skip to content
  • There are no suggestions because the search field is empty.

Reviewing Accounts Payable Reports

This job aid contains step-by-step instructions you can use when preparing and analysing MYOB Acumatica reports.

Generating the AP Aged Past Due 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:

      1. Summary: To view the past due balances on the selected aging date.

      2. Detailed: To view the past due documents on the selected aging date.

      3. 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 supplier Class box, select the supplier class for which you want to view information, or leave this box empty to view information on all supplier classes.

    4. In the supplier box, select the supplier you want to view information for, or leave this box empty to view information on all suppliers.

    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 suppliers with past-due balances. On the specified date, the system breaks down balances by days past due and displays all amounts in the base currency.

 

Generating the Multicurrency AP Aged Past Due 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:

      1. Detailed: To view the past due documents on the selected aging date.

      2. 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 supplier Class box, select the supplier class for which you want to view information, or leave this box empty to view information on all supplier classes.

    4. In the supplier box, select the supplier to view information for, or leave this box empty to view information on all suppliers.

    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 suppliers with past-due balances, which breaks down by days past due on the specified aging date. The amounts display in the documents' currencies and in the base currency.

 

Generating the AP Aged Outstanding 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:

      1. Detailed: To view outstanding documents on the selected aging date.

      2. 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 supplier Class box, select the supplier class for which you want to view information, or leave this box empty to view information on all supplier classes.

    4. In the supplier box, select the supplier to view information for, or leave this box empty to view information on all suppliers.

    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 suppliers with outstanding balances, breaking them down by days outstanding with respect to the specified aging date. The system displays the amounts in the base currency.

 

Generating the Multicurrency AP Aged Outstanding 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:

      1. Detailed: To view outstanding documents on the selected aging date.

      2. 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 supplier Class box, select the supplier class for which you want to view information, or leave this box empty to view information on all supplier classes.

    4. In the supplier box, select the supplier to view information for, or leave this box empty to view information on all suppliers.

    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 suppliers with outstanding balances, which breaks down by days outstanding with respect to the specified aging date. The system displays the amounts in the documents' currencies and in the base currency.

 

Generating the AP Balance by supplier Report in the Base Currency

  1. Open the AP Balance by Supplier (AP632500) report.

  2. On the Report Parameters tab, do the following:

  3. In the Report Format box, select one of the following options:

    1. Account Summary: To view the total of all documents that are open at the end of the reporting period.

    2. Open Documents: To view all documents with the Open status.

    3. Open + Current Period: To view all documents with the Open status, as well as documents of the current period, regardless of their status.

    4. All Documents (supplier Required): To view all a specific supplier's documents. If you select this option, you must specify a supplier.

  4. In the Company/Branch box, select the company or branch for which you want to view supplier balances, or leave this box empty to view information on all branches.

  5. In the Financial Period box, select the financial period whose information you want to view.

  6. Select the supplier in the supplier box whose information will be included in the report or leave this box empty to view information about all suppliers. Note that for the All Documents (supplier Required) report format, you must select a supplier.

  7. To also view applied documents, select the Include Applications check box.

  8. On the form toolbar, click Run Report.

The report lists the supplier balance for each account related to the supplier. The report displays all the amounts in the base currency.

 

Generating the Multicurrency AP Balance by Supplier Report

  1. Open the AP Balance by supplier MC (AP633000) report.

  2. On the Report Parameters tab, do the following:

    1. In the Report Format box, select one of the following options:

      1. Account Summary: To view the total of all documents that are open at the end of the reporting period.

      2. Open Documents: To view all documents with the Open status.

      3. Open + Current Period: To view all documents with the Open status, as well as documents of the current period, regardless of their status.

      4. All Documents (supplier Required): To view all specific supplier's documents. You must specify a supplier if you select this option.

  3. In the Company/Branch box, select the company or branch for which you want to view supplier balances, or leave this box empty to view information on all branches.

  4. In the Financial Period box, select the financial period whose information you want to view.

  5. Select the supplier in the supplier box whose information will be included in the report or leave this box empty to view information about all suppliers. Note that for the All Documents (supplier Required) report format, you must select a supplier. To also view applied documents, select the Include Applications check box.

  6. On the form toolbar, click Run Report.

The report lists the supplier balances in each of the currencies used (including the base currency) for each account related to the supplier.

 

Viewing Suppliers' Summary Information

  1. Open the Supplier Summary (AP401000) form.

  2. In the Company/Branch box, select the company or branch for which you want to view the data.

  3. Select the financial period in the Period box to view information or leave this box empty to display information about all open periods in the table.

  4. In the supplier Class box, select the supplier class for which you want to view information, or leave this box empty so that the table displays information about suppliers of all classes.

  5. Select a subaccount for the accounts payable account in the AP Subaccount box (if this box appears).

  6. In the AP Subaccount box (if this box appears), select a subaccount for the accounts payable account.

  7. Select the currency in the Currency box to view information or leave this box empty so that the data in the table will be displayed for all currencies.

  8. If needed, select the Split by Currency check box if you want to view balances in each currency separately (if you left the Currency box empty).

  9. Select the suppliers with Balance Only check box to view suppliers with non-zero balances or clear the check box to view all suppliers.

In the table, you can view suppliers' outstanding balances and other information that matches the criteria you specified.