Issue/Symptom/Question

Standard Crystal Report - Purchase Order Status by PO Number

Applies To

Penta for Windows

Standard Crystal Report - Purchase Order Status by PO Number

Purchasing Module

Resolution/Fix/Answer

Use this report to view the status of purchase orders. This report includes ordered, received, and invoiced information for each purchase order line item.

Report Code: po_poStatus_p144_cr11.rpt

Available Parameters:

Example Report Results:

Fields

Job ID - ID of the job that the purchase order is for.

Vendor Name - The name of the vendor that the purchase order is for.

Line no. - ID of the purchase order’s line item.

Cost Code - The Costcode the purchase is charged to.

Line Item Description - Description of the line item.

Unit Price - The price per unit for the line number item.

Quantity Ordered - The number of items ordered for the line item.

Quantity Rcvd/Invcd - The number of items received for the line item as of the date the report was run.

Remaining Quantity - The amount that hasn’t been received yet for the line item. Calculated as: Quantity Ordered – Quantity Received 

$ Amount Ordered - The total $ amount ordered for the line item, job, and purchase order.

$ Amount Rcvd/Invcd - The $ amount of the purchase order that has been received/invoiced for the line, job, and purchase order.

Remaining Amount - Amount of line item, job total amount, and purchase order number that remains to be invoiced.