AR Balance by GL Account

Form ID: (AR632000)

This report displays the balances of the AR accounts and activities on the accounts for the selected period. The balance of documents with the Customer Refund and Voided Refund types is treated as a payment with a reverse sign. Documents are grouped by account and subaccount pair and listed by their reference numbers. You can view each document's dates, original amount, and balance after payment application.

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

You use the following parameters to select the information to be displayed on the report:

  • Report Format: The report format, which indicates the documents to be reported on. Select one of the following options:
    • Account Summary: To view each customer's total on the documents that are open at the end of the reporting period, grouped by AR account and subaccount
    • Customer Summary: To view the total of account documents, broken down by the document total of the customers
    • Open Documents: To view the list of documents that are open at the end of the reporting period, grouped by AR account, subaccount, and customer account
    • Open + Current Period: To view the documents that are open at the end of the reporting period along with the documents posted or closed during the reporting period, grouped by AR account, subaccount, and customer 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 you want to display data; you must specify a financial period. The list of periods contains all the periods, including closed ones.
  • Include Applications: A check box that you select to include applied documents.
  • Group by Parent Account: A check box that you select to group customer accounts that are involved in parent-child relationship under a parent account and display consolidated balance of the group. The system will group only those child accounts that have the Consolidate Balance check box selected.

    The box is available if the Parent-Child Customer Relationship feature is enabled on the Enable/Disable Features form.

    For details, see Managing Parent-Child Relationships.

  • 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 use the financial period from 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.