Committed Item

Does anyone have a report that will not only show invoice detail for commitments but also invoices billed over commitment?  I know it is backwards but we frequently process the commitments after the invoices are entered.  I then have to go in and attache the commitment.  Sometimes i see that a subcontractor has billed over the commitment.  I can tell this by looking at the commitment status and accounts payable reports but optimally would like to see it in one report.

  • 0

    You may be able to use a JC inquiry to see cases where the amount invoiced exceeds the commitment amount, and once you have gathered the commitment numbers can use the JC Committed cost status with invoice detail report (selecting Ranges to pick specific commitments) to see both the commitment and invoice information on one report.   The JC inquiry, Committed Cost, Contract Control has a BALANCE column that is calculated based on the Revised Contract minus the Amount Invoiced. If the BALANCE is negative then the amount invoiced exceeds the commitment amount. The JC Committed cost status with Detail report is found in Job Cost, Reports, Committed cost