Open AP/PO Report by Vendor/PO

How to print: The system generates this report when you complete the Print Open AP/PO Receipts Report Screen (PAPO) if By vendor and Sort by PO are selected and Summary only is not selected.

For more information: See the sample report in PDF format.

Contents:

• Selection criteria: Selection criteria from the Print Open AP/PO Receipts Report Screen:

• Vendor: The vendor specified for the report. ALL indicates you did not specify a vendor.

• Transaction date range: The transaction date range specified for the report. ALL indicates you did not specify a date range.

• Vendor: The vendor code and description associated with the purchase order.

For each received purchase order line:

• PO number: The purchase order number that includes received purchase order lines.

• Item: The item number on the purchase order that was received.

• SKU: The SKU code, if any, defined for the item.

• Description: A description of the item.

• Qty: The quantity of the item that was received on the indicated date that has not yet been posted to an A/P invoice. For example, if you received 20 units on 3/15, and have posted 5 units to an A/P invoice, the quantity is 10.

• Cost: The unit cost at which the item was received, net of any discounts.

• Extended cost: The extended cost at which the item was received, calculated by multiplying the quantity by the unit cost.

• GL #: The general ledger number credited by the purchase order receipt; this is the Account # field in the PO Detail table. 0 indicates the receipt is not associated with a general ledger number.

• Transaction date: The date when the item was received.

• Total for PO: The total extended cost that is not yet posted to an A/P invoice for the purchase order.

• Total for vendor: The total extended cost that is not yet posted to an A/P invoice for the vendor.

• Final total: The total extended cost that is not yet posted to an A/P invoice, across all purchase order and vendors.