Open AP/PO Report by G/L

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

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

Contents:

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

General ledger: The general ledger number specified for the report. ALL indicates you did not specify a general ledger number.

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

General ledger number: The general ledger number credited by the purchase order receipt; this is the Account # field in the PO Detail table. 0 indicates a purchase order receipt not assigned to a general ledger number.

Vendor: The vendor defined for 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, if any defined for the item.

Description: A description of the item.

Qty: The quantity of the item that was received but 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 here 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.

Trans date: The date when the item was received.

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

Total for vendor: The total extended cost received but not yet posted to an A/P invoice for the vendor.

Total for GL: The total extended cost received but not yet posted to an A/P invoice for the general ledger number, across all vendors.

Final total for all GLs: The total extended cost received but not yet posted to an A/P invoice across all general ledger numbers selected for the report.

AP02_09r Serenade 5.0 March 2015