Subcontract Audit

Form ID: (SC644000)

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

The report displays summary or detailed information about the subcontracts for a particular date range. This information includes subcontract balances and the documents that have affected these balances, such as change orders, bills, and applied payments. Additionally, it shows the current outstanding balance, the budgeted and retainage amounts for each subcontract, and the unbilled, billed-to-date, and paid-to-date amounts. The report shows summary or detailed information broken down by subcontract.

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, use the following parameters to select the information to be displayed on the report:

  • Report Format: The format of the report to be displayed. Select one of the following options:
    • Summary: To view summary information for each document (subcontract, AP bill, payment, or change order) included in the report
    • Detailed: To view information for each document in the report by document line
  • Project: The project for which you want to view subcontract information. You can select a project to view only subcontracts created for this project or leave the box blank to view a broader range of data.
  • Vendor: The vendor for which you want to view subcontract information. You can select a vendor to view only subcontracts created for this vendor or leave the box blank to view a broader range of data.
  • Subcontract Nbr.: The reference number of the subcontract for which you want to view information. You can select a particular subcontract or leave the box blank to view a broader range of data.
  • Report Date: The date as of which the report is created. The report displays documents whose dates are earlier than or the same as the report date. By default, this box is empty, which means that the report is prepared for the current business date. The user can select a date to prepare the report for this date.
  • Project Status: The status of the projects whose subcontracts will be listed in the report. The default option is All, which means that projects with all statuses are included. A user can select any other option (Active, Completed, Canceled, or Suspended) to include only the projects with the selected status.
  • Subcontract Status: The subcontracts that will be included in the report. The default option is Open, which means that subcontracts with open statuses are included. A user can select any other parameter option (All, Closed, Open and Closed, or Pending Approval) to include only the subcontracts with the selected status in the report.
  • Include Pending CO in Revised Subcontract Amounts: A check box that you select to include the change orders that have the Open, On Hold, and Pending Approval statuses in the revised subcontract amounts. If the check box is cleared, these change orders are excluded.