Purpose: Use this report to review receipt information for a specific purchase order or for purchase orders received within a specified date range.
How to print: Select Print Report at the PO Receipts Report Screen.
For more information: See the sample report in PDF format.
Contents: This report page breaks by receipt date and sorts in ascending vendor number sequence. For a vendor, the report sorts receipts in ascending purchase order number/receipt control number/purchase order line sequence. If the same item is on multiple purchase order lines, the system displays the item for each line.
• Date range: The date range you entered at the PO Receipts Report Screen, limiting the report to received purchase order lines whose Receipt date in the PO Receipt table falls within this date range.
• Receipt Date: The date the purchase order line was received. From the Receipt date in the PO Receipt table.
• Vendor: The code and name of the vendor on the received purchase order line. From the Vendor # field in the PO Detail table and Name field in the Vendor table.
• PO#: The purchase order number received against. From the PO # field in the PO Receipt table.
• Receipt Control #: The receipt control number associated with the receipt. From the Control # field in the PO Receipt table. RF PO Receipt Transactions are assigned a control # of 9999999.
• Item: The code for the item on the purchase order line. From the ITM number field in the PO Detail table.
• SKU: The SKU code for the item on the purchase order line. From the SKU code field in the PO Detail table.
• Description: The description of the item on the purchase order line.
• Vendor Item: The vendor item code for the item. From the Item field in the PO Detail table.
• Qty Ordered: The quantity ordered for the purchase order line. From the Order qty field in the PO Detail table.
• Qty Open: The quantity remaining to receive for the purchase order line. The system uses the following calculation to determine the open quantity for a purchase order line: Order quantity in PO Detail - Received quantity in PO Detail = Open quantity. Note: 0 displays if the received quantity is greater than the order quantity.
• Qty Received: The quantity received for the purchase order line. From the Received qty field in the PO Detail table.
• Receipt Control Total: The total Quantity ordered, Quantity Open, and Quantity Received for all purchase order lines with the same receipt control number and receipt date.
• PO Total: The total Quantity ordered, Quantity Open, and Quantity Received for all purchase order lines with the same purchase order number and receipt date.
• Vendor Total: The total Quantity ordered, Quantity Open, and Quantity Received for all purchase orders for the same vendor and receipt date.
