Filters the report data by company code or name. All are selected by default.

Filters the report data by job number or name. All are selected by default.

Filters the report data by job cost center code or name. All are selected by default.

Filters the report data to include jobs that are coded as either Pending, Open, Soft Closed, or Hard Closed. All are selected by default.

Filters the report data by project manager name. All are selected by default.

Filters the report data by master job code or name. All are selected by default.

Filters the report data by phase code or name. All are selected by default.

Filters the report data for a specific cost type. All are selected by default.

Displays the filtered company code.

Displays the filtered job number and description.

Calculates the Job Materials Ordered Amount + Subcontract Revised Contract.

Calculates the Job Materials Received Amount + Subcontract Billed.

Calculates the Total Ordered - Total Received.

Calculates the cost of ordered materials. For Purchase Orders, it adds Received Extension materials plus the tax amount. For Job Requisitions, it multiplies the Transaction Quantity by the Standard Cost, then factors in any markups or taxes. For Job Requisition History, it references IM_TRANACTION_HISTORY_MC.Committed_Extension.

Calculates the cost of job materials received. For Purchase Orders, it references PO_PURCHASE_ORDER_DETAIL_MC.Received_Extension. For Job Requisitions, it multiplies the Transaction Quantity by the Standard Cost, then factors in any markups. For Job Requisition History, it references IM_TRANACTION_HISTORY_MC.Committed_Extension.

Calculates the amount due on job materials. For Purchase Orders, it subtracts the Received Extension from the Line Extension List. For Job Requisitions, it determines the material quantity by subtracting the Ship Quantity from the Transaction Quantity, then multiplies the difference by the Standard Cost and Markup Percentage. For Job Requisition History, the amount is always zero.

Displays the subcontract original contract from VN_SUBCONTRACT_PHASE_MC.Original_Contract_Amount.

Displays the subcontract change orders from VN_CHNG_REQ_SUB_DET_MC.CR_Amount.

Calculates the Sub Original Contract + Sub Change Orders.

Displays the subcontract amount billed from VN_GL_DISTRIBUTION_DETAIL_MC.Debit_Amount.

Displays the contract job manager from C_JOB_MASTER_MC.Project_Manager.

Displays the master job from JC_JOB_MASTER_MC.Master_Job+ JC_JOB_MASTER_MC.Job_Description.