AP Retainage Register

Form ID: (AP634500)

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

This report displays the list of all AP bills and debit adjustments with retainage for the selected company, branch, and vendor posted within the selected period range. The documents are grouped by project if the Require Single Project per Document check box is selected on the Accounts Payable Preferences (AP101000) form, and by vendor. All amounts are displayed in the base currency.

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

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:

  • 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.

  • From Period: The financial period that starts the range of periods for which you want to view information. The list of periods contains all the periods, including the closed ones.

    By default, the financial period of the current business date is selected.

  • To Period: The financial period that ends the range of periods for which you want to view information.

    By default, the financial period of the current business date is selected.

  • Project: The project whose balances will be included in the report. Either select a project from the list or make no selection to view information for all projects.
    Note: This parameter appears on the report form only if the Require Single Project per Document check box is selected on the Accounts Payable Preferences (AP101000) form.
  • 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 Unreleased Documents: A check box that you select to include unreleased bills with retainage and debit adjustments in the report.