To View Vendor Balances

You can use multiple reports to view vendor balances. This topic describes how to use the following reports and forms:

To Run the Vendor Summary Report

  1. Open the Vendor Summary (AP655000) report.
  2. On the report toolbar, click Run Report.

    The report lists all vendors, with each vendor's status, class, credit terms, default currency, tax zone, phone number, fax number, and current balance.

To Run the AP Balance by Vendor Report

  1. Open the AP Balance by Vendor (AP632500) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, select one of the following options:
      • Account Summary: To view the total of all documents that are open at the end of the reporting period.
      • Open Documents: To view all documents with the Open status.
      • Open + Current Period: To view all documents with the Open status, as well as documents of the current period, regardless of their status.
      • All Documents (Vendor Required): To view all of a specific vendor's documents. If you select this option, you must specify a vendor.
    2. In the Company/Branch box, select the company or branch for which you want to view vendor balances, or leave this box empty to view information on all branches.
    3. In the Financial Period box, select the financial period whose information you want to view.
    4. In the Vendor box, select the vendor whose information will be included in the report, or leave this box empty to view information about all vendors. Note that for the All Documents (Vendor Required) report format, you must select a vendor.
    5. To also view applied documents, select the Include Applications check box.
  3. On the form toolbar, click Run Report.

    The report lists the vendor balance for each account related to the vendor. All the amounts are displayed in the base currency.

To Run the AP Balance by Vendor MC Report

  1. Open the AP Balance by Vendor (AP632500) report.
  2. On the Report Parameters tab, do the following:
    1. In the Report Format box, select one of the following options:
      • Account Summary: To view the total of all documents that are open at the end of the reporting period.
      • Open Documents: To view all documents with the Open status.
      • Open + Current Period: To view all documents with the Open status, as well as documents of the current period, regardless of their status.
      • All Documents (Vendor Required): To view all of a specific vendor's documents. If you select this option, you must specify a vendor.
    2. In the Company/Branch box, select the company or branch for which you want to view vendor balances, or leave this box empty to view information on all branches.
    3. In the Financial Period box, select the financial period whose information you want to view.
    4. In the Vendor box, select the vendor whose information will be included in the report, or leave this box empty to view information about all vendors. Note that for the All Documents (Vendor Required) report format, you must select a vendor.
    5. To also view applied documents, select the Include Applications check box.
  3. On the form toolbar, click Run Report.

    The report lists the vendor balance for each account related to the vendor. All the amounts are displayed in the base currency.

To View Vendors' Balances Summary Information

  1. Open the Vendor Summary (AP401000) form.
  2. In the Company/Branch box, select the company or branch for which you want to view the data.
  3. In the Period box, select the financial period for which you want to view information, or leave this box empty so that information about all open periods will be displayed in the table.
  4. In the Vendor Class box, select the vendor class for which you want to view information, or leave this box empty so that information about vendors of all classes will be displayed in the table.
  5. In the AP Account box, select the AP account for which you want to view information, or leave this box empty so that information on all accounts will be displayed.
  6. In the AP Subaccount box (if this box appears), select a subaccount for the accounts payable account.
  7. In the Currency box, select the currency for which you want 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 Vendors with Balance Only check box to view vendors with non-zero balances, or clear the check box to view all vendors.

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