Chapter 20: Maintaining A/P Invoices | Contents | SCVs | Search | Glossary | Reports | XML | Index | 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 if By G/L # is selected and Summary only is not selected.
CWDirect Rel 4.0 Open AP/PO Report by G/L EKAPLAN APR0111 4/24/00 9:44:19 Page 1 EZK Mail Order Selection Criteria General Ledger ALL Transaction Date Range 7/01/99 to 12/31/00 General Ledger Number 99999 INV G/L JOKESHOP Vendor 12 JACK'S JOKE SHOP PO Number Item SKU Description Qty Cost Extended Cost Trans Date 1035 AN1234 ARTIFICIAL PICNIC ANTS 10 2.5000 25.00 9/07/99 Total for PO 25.00 Total for Vendor 12 25.00 Total for GL 99999 25.00 CWDirect Rel 4.0 Open AP/PO Report by G/L EKAPLAN APR0111 4/24/00 9:44:19 Page 2 EZK Mail Order Selection Criteria General Ledger ALL Transaction Date Range 7/01/99 to 12/31/00 General Ledger Number 10080100 INVENTORY Vendor 12 JACK'S JOKE SHOP PO Number Item SKU Description Qty Cost Extended Cost Trans Dat 995 SL4567 BLUE FUZZY SLIPPERS 2 3.2500 6.50 10/15/99 Total for PO 6.50 1027 PU6565 YELW 12 SENSIBLE 1-INCH HEEL PUMP 110 5.0500 555.50 9/02/99 Total for PO 555.50 1047 SH1000 NRML SPECIAL CARE SHAMPOO 20 1.5000 30.00 9/09/99 1047 SH1000 KIDS SPECIAL CARE SHAMPOO 50 1.5000 75.00 9/09/99 Total for PO 105.00 1048 GE9999 YELW GEL WRITER PEN 25 .5000 12.50 10/11/99 Total for PO 12.50 Total for Vendor 12 679.50 Total for GL 10080100 679.50 Final total for all GLs 704.50 |
Contents:
• Selection criteria: From the Print Open AP/PO Receipts Report Screen:
• General ledger: The general ledger number specified for the report. ALL displays if you did not specify a general ledger number.
• Transaction date range: The transaction date range specified for the report. ALL displays if 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 file. 0 displays for purchase order receipts 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 contains 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, a quantity of 10 displays here.
• 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.
Chapter 20: Maintaining A/P Invoices | Contents | SCVs | Search | Glossary | Reports | XML | Index | Open AP/PO Report by Vendor/PO |
AP02_09r CWDirect 18.0 August 2015 OTN