AP Retained Balance

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

The report is available for users to which the Administrator, AP Viewer, AP Clerk, AP Admin, or AcumaticaSupport 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 Bills and Adjustments (AP301000) 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

Amounts of debit adjustments, which have the negative sign, are considered in the calculation of aggregated amounts.

All amounts in the report are shown in the base currency of the selected company. The amounts of debit adjustments 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 vendor or for all vendors, if the Vendor parameter is empty
  • Summary: To view the total balance of unreleased retainage for a particular vendor or for all vendors, if the Vendor 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.
• Vendor: The vendor whose balances will be included in the report. Either select a vendor from the list of active vendors or make no selection to view information about all vendors.
  The list of vendors 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 Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true:

  • The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted.
  • A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, 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 selected branch, or the Company Details tab of the Companies (CS101500) form for the selected 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 list of related retainage documents 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.