AP Balance by GL Account

Form ID: (AP632000)

This report displays the balances of the AP accounts and activities on the accounts for the selected period. Documents are grouped by account, subaccount, and vendor.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Report Format: An indicator of the information to be shown in the report. Select one of the following options:
    • Account Summary: To view each vendor's total on documents that are open at the end of the reporting period, grouped by AP account and subaccount.
    • Vendor Summary: To view account documents total split by documents total of the of the vendors.
    • Open Documents: To view the list of the documents that are open at the end of the reporting period grouped by AP account, subaccount, and vendor account.
    • Open + Current Period: To view documents that are open at the end of the reporting period along with documents posted or closed during the reporting period, grouped by AP account, subaccount, and vendor account.
  • Company/Branch: The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access or leave the box blank to view information about all companies in the tenant.

    This parameter is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

  • Financial Period: The financial period for which balances will be shown. You must select a financial period from the list of periods, which contains all the periods (including the closed ones).
  • Include Applications: A check box you select to include applied documents. That is, for each vendor, outgoing payments that were applied against vendor bills are listed.
  • Use Master Calendar: A check box that you select to use the financial period from the master calendar. If the check box is cleared, the report will show data for the company calendar.

    This check box appears on the form only if the Multiple Calendar Support feature is enabled on the Enable/Disable Features form.

    For details on running consolidated reports and inquiries, see Consolidated Reports for Companies with Different Calendars.