PeopleSoft eProcurement Reports

Appendix: PeopleSoft eProcurement Reports

This appendix provides:

A summary table listing all PeopleSoft eProcurement reports.
Detailed information for individual reports.

Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with the documentation.

PeopleSoft eProcurement Reports: General Description

This table lists the PeopleSoft eProcurement reports, sorted alphanumerically by report ID. The reports listed are Crystal reports. If you need more information about a report, refer to the report details at the end of this appendix.

Report ID and Report Name	Description	Navigation	Run Control Page
APY1090 Matching Exceptions Report	Lists the match exceptions with voucher data, purchase order data, receiver data, and match error information.	eProcurement, Reports Click the Match Exceptions link to access the Match Exceptions page.	RUN_APY1090
APY3000 Vendor Detail Listing Report	Lists vendors by status along with their associated detail data including address information and payment options.	eProcurement, Reports Click the Vendor Detail Listing link to access the Parameters page.	RUN_APY3000
APY3001 Vendor Summary Listing Report	Lists the vendors by status along with basic summary information.	eProcurement, Reports Click the Vendor Summary Listing link to access the Parameters page.	RUN_APY3001
POY1100 Requisition to PO XREF Report	Provides information about selected requisitions and the purchase orders that were created from them.	eProcurement, Reports Click the Requisition to PO Xref link to access the Requisition to PO XREF page.	RUN_POY1100
POY4005 Expediting Report	Provides purchase order details such as late days and due date sorted by buyer. You can use this report to help determine which purchase orders might require expediting.	eProcurement, Reports Click the Expedite Report link to access the Expediting Report page.	RUN_POY4005
POY4100 PO to Requisition XREF Report	Provides information about selected purchase orders and the requisitions that they were created from.	eProcurement, Reports Click the PO to Requisition Xref link to access the PO to Requisition Xref page.	RUN_POY4100
POY4010 PO Listing Report	Provides purchase order information sorted by purchase order date.	eProcurement, Reports Click the PO Listing Report link to access the PO Listings page.	RUN_POY4010
POY4020 PO Status Listings	Provides purchase order information sorted by status.	eProcurement, Reports Click the PO Status Listing to access the PO Status Listing page.	RUN_POY4020
POY4030 PO Detail Listings	Provides detailed purchase order information sorted by purchase order date.	eProcurement, Reports Click the PO Details Listing to access the PO Details Listing page.	RUN_POY4030
POY4040 PO Schedule Listings	Provides purchase order schedule information such as ship to and due date sorted by purchase order date.	eProcurement, Reports Click the PO Schedules Listing to access the PO Schedules Listing page.	RUN_POY4040
POY5001 Receiver Summary Report	Provides a summary listing of receipts within a specified date range.	eProcurement, Reports Click the Receipt Summary link to access the Receiver Summary page.	RUN_POY5001
POY5010 Receiver Shipto Detail Report	Provides a summary listing of receipts shipments within a specified date range.	eProcurement, Reports Click the Receipt Shipto link to access the Receiver Shipto Detail page.	RUN_POY5101
POY5020 Receiver Account Detail Report	Provides a summary listing of receipts with account distribution.	eProcurement, Reports Click the Receipt Account Details link to access the Receiver Account Detail page.	RUN_POY5020
POY5050 RTV Details (return to vendor details)	Provides the vendor's return address, shipping method, and line item return information.	eProcurement, Reports Click the RTV Details link to access the RTV Details page.	RUN_POY5050
POY5060 RTV Credits (return to details credit)	Provides RTV details, sorted by vendor and RTV ID, and lists the buyer, line details, and the distribution information selected on the return.	eProcurement, Reports Click the RTV Credits link to access the RTV Credits page.	RUN_POY5060
PVY1000 Requisition Costing Summary	Provides information about the accounting distribution for each requisition. For each requisition, the accounting distribution lines are summarized by GL (general ledger) business unit, account, and department. This report also lists the requisition name, requester, amount, and date.	eProcurement, Reports Click the Requisition Costing Summary link to access the Requisition Costing Summary page.	RUN_PVY1000
PVY1100 Requisition Cost Distribution Detail	Provides information about the accounting distribution for each requisition down to the distribution level. By requisition distribution line, each accounting distribution is listed, including GL business unit, account, department, and amount.	eProcurement, Reports Click the Requisition Cost Distribution Details link to access the Requisition Cost Distribution Details page.	RUN_PVY1100
PVY2000 Catalog Item Usage	Provides information about the items ordered on requisitions. Sorted by business unit and item catalog, this report lists the items ordered and other information, including quantity ordered, average price, currency, and number of requisitions ordering this item.	eProcurement, Reports Click the Category Item Usage link to access the Category Item Usage page.	RUN_PVY2000
PVY4000 PO Item Category Usage	Provides information about the items ordered for the purchase orders within one business unit and one item catalog. This report lists the total quantity ordered of each item and other information, including item ID, item description, item category description, category code, vendor ID, vendor name, contract ID (if any), average price, total amount, currency, and percentage of total. This report is sorted by catalog ID and category code.	eProcurement, Reports Click the PO Items Category link to access the PO Items Category page.	RUN_PVY4000

PeopleSoft eProcurement Selected Reports: A to Z

This section provides detailed information about individual reports, including important fields and tables accessed. The reports are listed alphanumerically by report ID.

Common Elements Used in This Appendix

From Date and Through Date	Enter the dates to provide the date range for the requisitions that you want to include in the report. If you leave these fields blank, all requisitions are included regardless of their dates.
SetID	Enter the TableSet ID of the items that you want to include on the report. A setID is required for this report.

PVY2000 - Catalog Item Usage Report

Tree Name

Enter the name of the item catalog (PeopleSoft tree) that you want to include in the report.

PVY 4000 - PO Item Category Usage Report

Catalog ID	Enter the name of the item catalog (PeopleSoft tree) that you want to include on the report. A catalog ID is required for this report.
Tree Node	Enter the name of the PeopleSoft tree node to limit this report to items from this node.
Vendor ID	Enter a vendor ID if you want to limit this report to the purchase orders generated for this vendor.