AR Open Documents by Project

Form ID: (AR634100)

Note: This report is available only if the Projects group of features is enabled on the Enable/Disable Features (CS100000) form.

This report displays the list of accounts receivable documents that are open as of the current business date or a list of customers with their aggregated amounts, depending on the report format. Amounts of credit memos are shown with the negative sign. On the report form, you can also specify the company, branch, customer, and project for which you want to view data.

The Paid/Adjusted column in the report shows the part of paid retainage related to a specific original document. This column reflects the applications of payments and the direct applications of credit memos, if the document is not a reversing document.

The Net Balance column shows the part of the balance of a retainage document related to a specific original document.

In the report, the documents are grouped first by project and then by customer. Within each group, the documents are sorted by the document date, due date, document type, and reference number. All amounts are displayed in the base currency.

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 in the report:

  • Format: The format in which you want to review the report. The following options can be selected:
    • Detailed (default): The report shows individual documents
    • Summary: The report shows a list of customers with their aggregated amounts grouped by project
  • 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.

  • Customer: The customer whose documents will be included in the report. Either select a customer from the list of active customers or make no selection to view information about 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.
  • Project: The project whose documents will be included in the report. Either select a project from the list or make no selection to view information for all projects.