AR Balance by Customer

Form ID: (AR632500)

This report displays the outstanding balances of the selected customer (or all customers) during the selected period. The balance of documents with the Customer Refund and Voided Refund types is treated as a payment with a reverse sign. For each customer, documents are grouped by account–subaccount pair and listed by reference number. You can easily see 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: An indicator of the documents to be reported on. Select one of the following options:
    • Account Summary: To view each customer's total on documents that are open at the end of the reporting period, grouped by AR account and subaccount.
    • Open Documents: To view the list of documents that are open at the end of the reporting period.
    • 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.
    • All Documents (Customer Required): To view all documents that have been posted before the end of the reporting period. You must specify a customer if you select this option.
  • 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 the closed ones.
  • Project: The project for which you want to view information. You can select the project to view only documents related to this project, or leave the box blank to view the documents related to all projects.
  • Customer: The customer the report will cover. Either select a customer or leave the box blank to view data on all customers.
    The list of customers available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Customers (AR303000) form. With the feature enabled, a customer is available for selection if one of the following is true:
    • The Restrict Visibility To box is empty for the customer—that is, the customer’s visibility is not restricted.
    • A branch, company, or company group is specified in the Restrict Visibility To box for the customer, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
  • Include Applications: A check box that you select to include applied documents.
  • Consolidate Data by Parent Account: A check box that you select to view consolidated information about balances of customer accounts involved in a parent-child relationship. The system will display balance details for only parent accounts along with the consolidated balance of the group.

    The box is available if the Parent-Child Customer Relationship feature is enabled on the Enable/Disable Features (CS100000) 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.