AR Retained Balance

Form ID: (AR635000)

Note: This report appears in the system only if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.

This report displays the balance of open retainage in the AR subledger for a selected financial period.

The report is available for users to which the Administrator, AR Viewer, AR Clerk, AR Admin, or Acumatica Support role is assigned on the User Roles (SM201005) form.

The report amounts are calculated based on the documents that match the following criteria:

  • The Apply Retainage check box is selected for the document on the Invoices and Memos (AR301000) form.
  • The document has unreleased retainage at the end of the selected financial period.
  • The closed period of the document is later than the selected financial period, and the post period is earlier than or the same as the selected financial period

On the printed report form, the Retainage Amount displayed for a consolidated retainage document is shown as a part of the total document amount that is related to a specific original document. The retainage amount includes taxes, if they are applicable.

All amounts in the report are shown in the base currency of the selected company. The amounts of credit memos are shown as negative numbers.

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:

  • Report Format: The format of the report. Select one of the following options:
    • Detailed (default): To view documents with unreleased retainage in the specified period for a particular customer or for all customers, if the Customer parameter is empty
    • Summary: To view the total balance of unreleased retainage for a particular customer or for all customers, if the Customer parameter is empty
  • 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 the data in the report should be displayed. This is a required parameter. By default, this parameter is filled in with the period of the business date.
  • Customer: The customer whose balances 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.
  • Include Retainage Details: A check box that you select to include retainage documents in the report. If this check box is selected together with the Detailed format, below each original document, a consolidated retainage document is displayed. If this check box is selected together with the Summary format, the state of the check box does not affect the report data.