Issue/Symptom/Question

Standard Crystal Report - Job Bid Price Comparison

Applies To

Penta for Windows

Crystal Report - Job Bid Price Comparison

Resolution/Fix/Answer

Use this report to monitor price differences between the requisition bid, purchase order, and vendor invoice. You can review these transactions by OU, project manager, and job.

Report Code: po_bidPriceComp_p161_cr11.rpt

Available Parameters:

Example Report Results: 

Report Fields

Requisition/Bid: Line - Requisition line number for the requested product.

Requisition/Bid: Units - Number of units of the product, per the line item on the requisition/bid.

Requisition/Bid: Bid Price - Product bid price on the requisition/bid.

Requisition/Bid: Total - Total amount for the product line item for the requisition/bid.

Purchase Order: ID - This column displays the purchase order ID resulting from the requisition/bid.

Purchase Order: Line - This column displays each line item number for the product on the purchase order.

Purchase Order: Description - This column displays—for each line item—the description of the Product for the purchase order.

Purchase Order: Units - This column quantifies the line item’s units for the purchase order.

Purchase Order: Unit Price - This column displays—for each line item—the price per unit for the Product on the purchase order.

Purchase Order: Total - This column displays each line item’s total amount committed to the job from the purchase order, then displays the sum of the totals in bold.

Req to PO Variance: Units - This column displays—for each line item—the variance between the requisition’s units and the purchase order’s units.

Req to PO Variance: Unit Price - This column displays—for each line item—the variance between the requisition’s unit price and the purchase order’s unit price.

Req to PO Variance: Total - This column displays—for each line item—the variance between the requisition’s total amount and the purchase order’s total amount. The sum of the totals display in bold.

Invoice: Units - This column quantifies the purchase order’s invoiced product units for each line item.

Invoice: Unit Price - This column displays each line item’s price per unit of the invoiced product.

Invoice: Total - This column displays each line item’s total, then displays the sum of the totals in bold.