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
      • [1]AVcheck if any compliance info is also shown2023/01/2615:36:04+01:00
    • 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, [2]janice.paganiniSo the system does not insert the current date by default, even though it uses it?k3r_5t1_q2c2025/02/2820:53:20-05:00EFeoktistovaTested. Yes. The system used the current date if the date is not inserted in the box. Build 25.100.00492k3r_5t1_q2c22025/03/1017:44:28+01:00this 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.
    • [3]janice.paganiniKaty, if a project is selected, what happens with this element? Is that project's status filled in and the box is unavailable, or does the system simply ignore this parameter? iy4_bk3_q2c2025/02/2821:10:11-05:00EFeoktistovaI would leave the description as is (not to complicate it). The system doesn't fill the project's status automatically if we specify the project in the Project box. The box is always available.4iy4_bk3_q2c42025/03/1118:54:30+01:00
  • 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.
  • [4]EFeoktistovaLeft as is because of the typo (fixed the technical typo - see my tracked changes).2025/03/1017:39:05+01:00Include Pending CO in Revised Subcontract Amounts: T[5]janice.paganiniT2025/02/2821:22:04-05:00[6]janice.paganiniinsert2025/02/2821:22:04-05:00A check box that he user can[7]janice.paganinihe user can2025/02/2821:24:03-05:00[8]janice.paganiniinsert2025/02/2821:24:03-05:00you select whether [9]janice.paganiniwhether 2025/02/2821:22:14-05:00to include the change orders that have the Open, On Hold, and Pending Approval statuses in the revised subcontract amounts ([10]janice.paganini (2025/02/2821:22:39-05:00[11]janice.paganiniinsert2025/02/2821:22:39-05:00. Ii[12]janice.paganinii2025/02/2821:22:50-05:00I[13]EFeoktistovaI2025/03/1017:31:48+01:00f the check box is selected) or[14]janice.paganiniselected) or2025/02/2821:23:03-05:00[15]janice.paganiniinsert2025/02/2821:23:03-05:00cleared, these ch[16]EFeoktistovainsert2025/03/1017:31:32+01:00angeeck[17]EFeoktistovaeck2025/03/1017:31:34+01:00[18]janice.paganiniinsert2025/02/2821:23:03-05:00 [19]EFeoktistovainsert2025/03/1017:31:43+01:00ordersboxes[20]EFeoktistovaboxes2025/03/1017:31:41+01:00[21]janice.paganiniinsert2025/02/2821:23:03-05:00 are exclude[22]janice.paganiniinsert2025/02/2821:23:14-05:00d them (if the check box is cleared)[23]janice.paganini them (if the check box is cleared)2025/02/2821:23:09-05:00.