View supplier balances

In this topic

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

  1. Go to the Balance by supplier (AP63250S).
  2. On the Report parameters tab, in the Report format field, select one of the following options:
    • Account summary

      To display the balance by supplier account.

    • 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 (supplier required): To view all the documents of a specific supplier. If you select this option, you must specify a supplier.
  3. Select the branch for which you want to view supplier balances.
  4. Select the financial period whose date you want to view.
  5. To view applied documents, select the Include applications check box.
  6. Optional: Select a supplier by its ID, or leave the Supplier no. field blank to display information on all suppliers.
    For the All documents report format, you must select a supplier.
  7. Click Run report.
    The report lists the supplier balance for each account related to the supplier. All the amounts are displayed in the base currency.
  1. Go to the Balance by supplier (currency) (AP63300S) report.
  2. In the Report format field, select one of the following options:
    • Account summary

      To display the balance by supplier account.

    • 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 (supplier required): To view all the documents of a specific supplier. If you select this option, you must select a supplier.
  3. Select the financial period you want to run the report for.
  4. To view applied documents, select the Include applications check box.
  5. Optional: Select a supplier, or leave the Supplier field blank to display information on all suppliers.
    For the All documents report format, you must select a supplier.
  6. 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.
  1. Go to the Supplier summary (AP401000) window.
  2. In the Branch field, select the branch for which you want to view the data.
  3. Optional: In the Period field, select a financial period. If do not select any period, information about all open periods is displayed in the table.
  4. Optional: Select a supplier class. If you leave the Supplier class field blank, information about suppliers of all classes is displayed in the table.
  5. Optional: Select a currency. If the Currency field is blank, the data is displayed for all currencies.
  6. Optional: If you left the Currency field blank, select the Split by currency check box to view balances in each currency separately.
  7. Optional: Select a supplier account. If you leave the Supplier account field left, information on all accounts is displayed.
  8. Optional: Select the corresponding supplier subaccount for the Supplier ledger account.
  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.
  10. In the table, view suppliers' outstanding balances and other information that matches the criteria you specified in the top part.