Commitment Summary Report

This report summarizes the Commitment Log, the CCO Log, the Pay Request Detail Log and the Compliance Log.

Commitment Summary Report

Note: although the image above does not show the Output drop-down, you can select an output method (PDF/Excel/CSV) for this report.

Filters:

  • Project – the Project ID.  You can look up or type a specific project, or use the % mask for multiple projects.
  • Vendor – the vendor on the Commitment.  You can select a specific vendor or keep the (any) default.
  • Show Detail – whether or not the report should include Pay Request Item information line by line.
  • Show Compliance – whether or not the report should include Compliance information line by line.

Columns

Commitments
  • Project-Doc # – the Commitment document number.
  • Description – the Commitment’s Description.
  • Type – the Commitment’s subtype, in code.
  • Status – the Commitment’s document status.
  • Value: Original Amount – the Commitment’s Original amount.
  • Value: Approved COs – the amount on approved CCOs related to the Commitment.
  • Value: Revised Amount – the Original amount plus approved CCO amount.
  • Value: Pending COs – the amount on CCOs which are pending.
  • Value: Total w/Pending – the Revised amount plus the Pending amount.
  • Approved Payment Requests: Amount Requested – the amount requested on an approved Pay Request associated with the Commitment.
  • Approved Payment Requests: Retention Amount – the retention amount on the approved Pay Request.
  • Approved Payment Requests: Net Paid – the payment amount on the approved Pay Request.
  • Pending Payment Requests: Request Amount – the amount requested on a pending Pay Request.
  • Pending Payment Requests: Retention Amount – the retention amount on the pending Pay Request.
Change Orders
  • DocNo – the CCO document number.
  • Description – the CCO title.
  • Status – the CCO’s document status.
  • Source – the Source of the change.
  • Approved Date – the date on which the CCO was approved.
  • Schedule Impact: Requested – the number of days on the CCO’s Schedule Impact: Req field.
  • Schedule Impact: Approved – the number of days on the CCO’s Approved Days field.
  • Estimate Amount – the Total Estimate amount on the CCO’s Detail tab.
  • Quote Amount – the Total Quote amount on the CCO’s Detail tab.
  • Amount – the Amount on the CCO’s Detail tab.

Note: all dollar amount columns are subtotaled by Commitment and then project and then totaled.

Pay Requests
  • Ref # – the Pay Request document number.
  • Type – the document subtype, in code.
  • Status – the document status of the Pay Request.
  • Invoice Date – the Invoice date on the Pay Request.
  • Final/PreF for final payment or PP for pre-payment.
  • Lien Waivers – the number of lien waivers received or expected for the Commitment.
  • Approved –the date the Pay Request was approved.
  • Approver – the person who approved the Pay Request.
  • Lines (if Show Detail checkbox is off) – the number of lines in the Pay Request.
  • Line # (if Show Detail checkbox is on) – the Item number of the Pay Request line.
  • Requested Amount – the requested amount on each Pay Request Item.
  • Retention Amount –the retention amount on each Pay Request Item.
  • Net Pay Amount –the amount to be paid to the vendor for each Pay Request Item.

Note: project totals for Request Amount, Retention Amount and Net Pay Amount appear at the end of each project list.

Compliance
  • Doc Description – a) the vendor name and ID or b) the Commitment or Pay Request header information.
  • Type/ID – the Doc type associated with the compliance item and its ID or Doc number.
  • Compliance Description – the Description as entered on the Compliance tab.
  • Compliance Type – the description of the Compliance type.
  • Project – the Project ID associated with the compliance requirement.
  • Required By – the date by which the compliance requirement is/was required.
  • Expiration – the date on which the compliance requirement expires or expired.
  • Status – the status of the compliance requirement.
  • Last Alert – the latest date on which a compliance alert was sent out and also whether an out-of-compliance trigger is warning (w) or blocking payment (!).

Last updated: October 19, 2016 at 9:04 am;