PeopleSoft Purchasing Reports: General Description

For samples of these PeopleSoft Purchasing reports, see the Portable Document Format (PDF) files published with your online documentation.

In addition to the standard reports that PeopleSoft delivers, PeopleSoft also provides reporting tools that you can use to create new reports.

This table lists the PeopleSoft Purchasing reports, sorted in alphanumerical order by report ID. These reports listed are Structured Query Reports (SQRs) or BI Publisher reports. If you need more information about a report, refer to the report details at the end of this topic.

This section discusses:

  • PeopleSoft Purchasing reports.

  • PeopleSoft Purchasing Cost reports.

Report ID and Report Name

Description

Navigation

Run Control Page

POCNT500

GPO Price Comparison (group purchase order price comparison)

Displays manufacturer prices, distributor prices, expected distributor markups, and actual item markups for all items on a GPO contract. All prices are displayed in the GPO manufacturer currency. (SQR)

Purchasing, GPO Contracts, Reports, GPO Price Comparison

RUN_POCNT500

POCNT505

GPO Price Exception

Lists all items for which the distributor markup on the actual price does not equal that on the GPO contract. (SQR)

Purchasing, GPO Contracts, Reports, GPO Price Exception

RUN_POCNT505

POCNT510

GPO Manufacturer Commitment

Lists the amount spent, by GPO manufacturer contract. The amounts in this report do not include distributor markup. The report is sorted by distributor (supplier) or item category. (SQR)

Purchasing, GPO Contracts, Reports, GPO Manufacturer Commitment

RUN_POCNT510

POCNT515

GPO Distributor Commitment

Displays the total amount spent with a GPO distributor for items supplied by a particular manufacturer. Compare this report to the contract commitments made to the distributor (amount purchased per quarter, for example). (SQR)

Purchasing, GPO Contracts, Reports, GPO Distributor Commitment

RUN_POCNT515

POCNT520

GPO Purchases

Displays the amount spent with a single group purchasing organization (GPO), including all current contracts. Amounts include distributor markups. The report is sorted by distributor (supplier) or item category code. (SQR)

Purchasing, GPO Contracts, Reports, GPO Purchases

RUN_POCNT520

PO_LGSP

PO Line Group Spend

Lists the spend activity for line groupings sourced on purchase orders. (BI Publisher)

Purchasing, Reports, Line Group Spend Report

RUN_PO_LGSPND

POPO005

PO Dispatch/Print

Prints a hard copy of the purchase order. (SQR)

Note: The PO_DISPATCH is the BI Publisher version of the POPO005.sqr report and the POXMLP_PRINT is the online printable version of the report. When you click the View Printable Version link for the purchase order, the system displays the report if you have the XMLP Template check box selected as an installation option. If the template is not selected, the popo005.sqr appears.

Purchasing > Purchase Orders > Review PO Information > Print POs > Purchase Orders Print

RUN_PRN_POPO005

POPO008

Close Purchase Order

Provides information about purchase orders that have been closed by the last run of the Close Purchase Order Application Engine process. (SQR)

Purchasing > Purchase Orders > Reconcile POs > Close Purchase Orders

RUN_PORECON

POPO009

PO Activity

Lists purchase order activity for the purchasing business unit, GL business unit, department, and dates that you select. Reviewing this report enables that you to perform comparisons and resolve discrepancies proactively. (SQR)

Purchasing > Purchase Orders > Reports > Purchase Order Activity

RUN_POPO009

POPO010

PO Acknowledgement

Lists specified purchase order acknowledgments sorted by either supplier name or buyer name. (SQR)

Purchasing > Purchase Orders > Reports > Purchase Order Acknowledgments

RUN_POPO010

POPO011

Non-Owned Purchase History

Lists utilization information for nonstock items for business units and departments listed in the item master. Analysis of this information can help you to evaluate supplier contracts, establish new supplier relationships, consolidate purchasing transactions, establish and maintain budgets, and anticipate supply needs. (SQR)

Purchasing > Purchase Orders > Reports > Non-Owned History Report

RUN_POPO011

POPO012

Backorder Status

Part of the Backorder Status process displays backorder details for a supplier, business unit, item, or buyer within user-defined date parameters.

If you do not select the Include Backorders Received check box, the system only includes open (unreceived) backorder details. (SQR)

Purchasing > Purchase Orders > Reports > PO Backorder Status

RUN_POPO012

PORB7010

Supplier Claims

Provides a hard copy of the claim. (SQR)

See Printing a Vendor Rebate Claim.

Purchasing > Supplier Rebates > Vendor Rebate Claims > Vendor Rebate Claims Print

VRBT_CLAIMS_PRT_RC

PORC100

ASR

Provides information about staged receipts that have been created from ASR documents received by electronic data exchange. (SQR)

Purchasing > Receipts > Reports > Advanced Shipment Receipt Rpt

RUN_PORCV100

PORC200

Planned Receipt

Provides information about receipts generated from purchase order information to be used for electronic data collection transactions. (SQR)

Purchasing > Receipts > Reports > Planned Receipts > Planned Receipt Report

RUN_PORCV200

PORC700

Receipt Accrual

Lists all received items (sorted by ChartFields) that have been posted but not fully invoiced. It can help with monitoring and maintaining monthly budgets.

You can run this report for inventory items, expense items, or both. It might also include landed costs. (SQR)

Purchasing > Receipts > Reports > Receipt Accrual

RUN_PORC700

PORC910

Receiving Bar-code Labels

Create a flat file to produce receipt labels used to track received items. Receiving labels may be generated for each item on a receipt. (SQR)

Purchasing > Receipts > Reports > Receipt Labels > PO Receipt Labels

RUN_PORC910

PORC920

Receipt Item Usage Labels

Prints item usage labels for point-of-use locations against purchase order receipts. When items are delivered to a receiving dock, they are either put away in inventory storage or delivered to a point-of-use location. (SQR)

Purchasing > Receipts > Reports > Receipt Item Usage Labels > PO Receipt Item Usage Labels

RUN_PORC_USG_LBL

PORC930

Device Tracking Receipts

Displays device-tracked items that have been received. (SQR)

Purchasing > Receipts > Reports > PO/Receipt Device Tracking > PO/Receipt Dev Trk

RUN_PORC930

PORFQ01

RFQ Dispatch/Print

Provides a hard copy of the request for quote. (SQR)

Purchasing > Request for Quotes > Dispatch Quotes > Dispatch Quote Forms

RUN_PORFQ01

POROL001

Open Purchase Order

Review open purchase orders for the budget year-end process. The information for the purchase order distribution lines appear in this report if their encumbrances still remain on the KK_LIQUIDATION table. (SQR)

Purchasing > Purchase Orders > Budget Year End Processing > Open Purchase Order Report > Open Purchase Order

RUN_POREPORT

POROL002

PO Rollover

Review the four different roll statuses (Pending, Mid Roll, Roll Completed, and Disqualified) of the purchase orders during the budget year-end process. (SQR)

Purchasing > Purchase Orders > Budget Year End Processing > PO Rollover Activity Report > PO Rollover

RUN_PORO0011

POROLLEXP_PO

PO Rollover Exception List Sort by Type

Review non-qualified purchase orders and their associated documents. To produce the report listing, the PO Rollover View process must be run prior to producing the Non-Qualified PO Exception Listing. (SQR)

Note: The PO_POROLLEXP – PO Rollover Exception List Sort by PO report is also available for viewing purchase order rollover exceptions.

Purchasing > Purchase Orders > Budget Year End Processing > Non Qualified PO Listing

RUN_ROLL_EXCEPTION

PORQ009

Close Requisition

Provides information about requisitions that have been closed by the last run of the Close Requisition process (PO_REQRCON). (SQR)

Purchasing > Requisitions > Reconcile Requisitions > Close Requisitions

RUN_REQRECON

PORQ010

Requisition Print SQR

Provides a hard copy of your requisitions sorted by requisition ID. You can print a single requisition or multiple requisitions. (SQR)

Purchasing > Requisitions > Reports > Print Requisition > Requisition Print

RUN_POY100

PORQ011

Requisition Template

Provides a listing of the items most commonly ordered, along with supplier and manufacturer information. It is used to facilitate data entry of commonly ordered items. (SQR)

Purchasing > Requisitions > Reports > Requisition Template

RUN_PORQ011

PORT001

RTV Dispatch/Print

Provides a hard copy of the selected return to vendor transactions. (SQR)

  • Purchasing > Return To Vendor > Dispatch RTVs

  • Purchasing > Return To Vendor > Print RTVs

RUN_PO_RTVDISP

POS8001

Procurement Budgetary Activity

Generate the Procurement Budgetary Activity Report. This report provides budgetary amount information for purchase orders according to report request parameters. (SQR)

Purchasing > Purchase Orders > Reports > Req & PO Budget Activity Req

RUN_POS8000

POS8002

Requisition Budgetary Activity

Generate the Requisition Budgetary Activity report. This report provides budgetary amount information for requisitions according to report request parameters. (SQR)

Purchasing > Purchase Orders > Reports > Req & PO Budget Activity Req

RUN_POS8000

POVR100

Vendor Rebate Dispatch

Prints a hard copy of the vendor rebate agreement. (SQR)

  • Purchasing > Supplier Rebates > Rebate Dispatch > Vendor Rebate Agreement Dispatch

  • Click the Dispatch button on the Rebate Agreement - Rebate Agreement page.

RUN_DISP_POVRBT100

POVRB200

Rebate Threshold Analysis

Provides vendor rebate agreement threshold analysis information for selected vendor rebate agreements. (SQR)

Purchasing > Vendor Rebates > Vendor Rebate Analysis > Rebate Analysis Workbench > Vendor Rebate Analysis Workbench - Workbench Filter Options page.

Click the View Workbench button on the Vendor Rebate Analysis Workbench - Workbench Filter Options page.

Select Rebate Threshold Report in the Select Rows For field on the Vendor Rebate Agreement Analysis Workbench and then click the OK button.

VRBT_SERVER_REPORT

POVRB300

PO Not Received

Provides open purchase order information that is associated with a vendor rebate agreement. (SQR)

Purchasing > Vendor Rebates > Vendor Rebate Analysis > Rebate Analysis Workbench > Vendor Rebate Analysis Workbench - Workbench Filter Options page.

Click the View Workbench button on the Vendor Rebate Analysis Workbench - Workbench Filter Options page.

Select PO Not Received Report in the Select Rows For field on the Vendor Rebate Agreement Analysis Workbench and then click the OK button.

VRBT_SERVER_RPT

PO_DISPATCH

PO_DISPATCH

Provides information about selected purchase orders. (BI Publisher)

Purchasing > Purchase Orders > Dispatch POs

RUN_PO_DISPATCH

POXMLP_PRINT

POXMLP_PRINT

Provides information about selected purchase orders. (BI Publisher)

Purchasing > Purchase Orders > Add/Update POs

Click the View Printable Version link on the Maintain Purchase Order - Purchase Order page.

RUN_POXMLP_PRINT

POX4006

Expediting Report by Buyer

Provides purchase order details such as late days and due date sorted by buyer. Use it to help determine which purchase orders may require expediting. (BI Publisher)

Purchasing > Purchase Orders > Reports > Expediting > Expediting Report

RUN_POY4006

POX4007

Expediting Report by Supplier

Provides purchase order details such as late days and due date sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Expediting > Expediting Report

RUN_POY4007

POX4008

Expediting Report by Due Date

Provides purchase order details such as late days and due date sorted by due date. (BI Publisher)

Purchasing > Purchase Orders > Reports > Expediting > Expediting Report

RUN_POY4008

POX4030

PO Detail Listing By PO Date 

Provides detailed purchase order information sorted by purchase order date. (BI Publisher)

Purchasing > Purchase Orders > Reports > Purchase Order Detail Listings

RUN_POY4030

POX4031

PO Detail Listing By Supplier 

Provides detailed purchase order information sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Detail Listings > PO Detail Listings

RUN_POY4031

POX4032

PO Detail Listing By Buyer 

Provides detailed purchase order information sorted by buyer. (BI Publisher)

Purchasing > Purchase Orders > Reports > Detail Listings > PO Detail Listings

RUN_POY4032

POX4100

PO Detail Listing By Buyer 

Provides a cross-reference between requisitions and the purchase orders created from those requisitions. (BI Publisher)

Purchasing > Purchase Orders > Reports > Requisition/PO Xref > PO To Requisition Xref

RUN_POY4100

POX5001

Receiver Summary

Provides a summary listing of receipts within a specified date range. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Summary

RUN_POY5001

POX5010

Receiver Shipto Detail 

Provides a summary listing of receipts shipments within a specified date range. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Ship To Details

RUN_POY5010

POX5020

Receiver Account Detail

Provides a detailed list of shipments by receiver ID. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Account Details

RUN_POY5020

POX1100

Requisition to PO XREF

Provides information about selected requisitions and the purchase orders that have been created from them. (BI Publisher)

Purchasing > Requisitions > Reports > PO/Requisition Xref > Requisition to PO XREF

RUN_POY1100

POX3031

Contract Activities

Displays line level information about procurement documents associated with a contract. (BI Publisher)

Procurement Contracts > Reports > PO Contract Activities Report

RUN_POY3030

POX4006

Expediting Report by Buyer

Provides purchase order details such as late days and due date sorted by buyer. Use it to help determine which purchase orders may require expediting. (BI Publisher)

Purchasing > Purchase Orders > Reports > PO Expediting Report

RUN_POY4006

POX4007

Expediting Report by Supplier

Provides purchase order details such as late days and due date sorted by supplier. Use it to help determine which purchase orders may require expediting. (BI Publisher)

Purchasing > Purchase Orders > Reports > Expediting > Expediting Report

RUN_POY4007

POX4008

Expediting Report by Due Date

Provides purchase order details such as late days and due date sorted by due date. Use it to help determine which purchase orders may require expediting. (BI Publisher)

Purchasing > Purchase Orders > Reports > Expediting > Expediting Report

RUN_POY4008

POX4010

PO Listing by PO Date

Provides purchase order information sorted by purchase order date. (BI Publisher)

Purchasing > Purchase Orders > Reports > Purchase Order Listings Report

RUN_PO4010

POX4011

PO Listing By Supplier

Provides purchase order information sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Listings > PO Listings

RUN_POY4010

POX4012

PO Listing By Buyer

Provides purchase order information sorted by buyer. (BI Publisher)

Purchasing > Purchase Orders > Reports > Listings > PO Listings

RUN_POY4010

POX4013

PO Listing By Status

Provides purchase order information sorted by status. (BI Publisher)

Purchasing > Purchase Orders > Reports > Listings > PO Listings

RUN_POY4010

POX4020

Order Status By Supplier

Provides purchase order status information sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Status Listings > PO Status Listings

RUN_POY4020

POX4021

Order Status by Item

Provides purchase order status information sorted by item. (BI Publisher)

Purchasing > Purchase Orders > Reports > Status Listings > PO Status Listings

RUN_POY4020

POX4030

PO Detail Listing By PO Date

Provides detailed purchase order information sorted by purchase order date. (BI Publisher)

Purchasing > Purchase Orders > Reports > Detail Listings > PO Detail Listings

RUN_POY4030

POX4031

PO Detail Listing By Supplier

Provides detailed purchase order information sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Detail Listings > PO Detail Listings

RUN_POY4031

POX4032

PO Detail Listing By Buyer

Provides detailed purchase order information sorted by buyer. (BI Publisher)

Purchasing > Purchase Orders > Reports > Detail Listings > PO Detail Listings

RUN_POY4032

POX4040

PO Schedule Listing By PO Date

Provides purchase order schedule information such as ship to and due date sorted by purchase order date. (BI Publisher)

Purchasing > Purchase Orders > Reports > Schedule Listings > PO Schedule Listings

RUN_POY4040

POX4041

PO Schedule Listing By Supplier

Provides purchase order schedule information such as ship to and due date sorted by supplier. (BI Publisher)

Purchasing > Purchase Orders > Reports > Schedule Listings > PO Schedule Listings

RUN_ POX4041

POX4042

PO Schedule Listing By Buyer

Provides purchase order schedule information such as ship to and due date sorted by buyer. (BI Publisher)

Purchasing > Purchase Orders > Reports > Schedule Listings > PO Schedule Listings

RUN_POY4042

POX5001

Receiver Summary

Provides a summary listing of receipts within a specified date range. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Summary > Receiver Summary

RUN_POY5001

POX5010

Receiver Ship to Detail

Provides a summary listing of receipts shipments within a specified date range. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Ship To Details > Receipt Shipto Detail

RUN_POY5010

POX5020

Receiver Account Detail

Provides a summary listing of receipts with account distribution. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Account Details > Receiver Account Detail

RUN_POY5020

POX5030

Receipt Delivery Detail

Provides a detailed list of shipments by receiver ID, including deliveries made through the Mobile Inventory Management application. (BI Publisher)

Purchasing > Receipts > Reports > Receipt Delivery

RUN_POY5030

POX5035

Shop Floor Receipt Delivery

Provides a detailed list of shop floor receipts.

Purchasing > Receipts > Reports > Receipt Delivery

RUN_POY5030

POX5050

Return To Vendor Detail

Provides the supplier's return address, shipping method, and line item return information. (BI Publisher)

This report is available anytime after you enter and save the supplier return in PeopleSoft Purchasing.

Purchasing > Return To Vendor > RTV Details Report

RUN_POY5050

POX5060

RTV Credits

Provides details of return to vendor transactions, sorted by supplier and return to vendor ID, and lists the buyer, line details, and the distribution information selected on the return. Totals are provided for each return to vendor ID and supplier. (BI Publisher)

This report is available at any time after you enter and save the supplier return in PeopleSoft Purchasing.

Purchasing > Return To Vendor > Supplier RTV Credits Report

RUN_POY5060

POX5070

Bill of Entry Worksheet

Provides a bill of entry worksheet. (BI Publisher)

Purchasing > Receipts > Reports > Bill of Entry Worksheet > BOE Worksheet

RUN_POY5070

POX6100

REQ/RFQ Cross Reference

Provides a cross-reference between requests for quotes and the requisitions created from those requests for quotes.

Purchasing > Requests for Quotes > Requisition/RFQ Xref Report > REQ/RFQ Cross Reference

RUN_POY6100

POX8000

Cardholder Information

Provides information relating to each cardholder and the cardholder's assigned procurement card. The information printed in the report includes card number, transaction and monthly limits, and authorized purchasing categories. (BI Publisher)

Purchasing > Procurement Cards > Reports > Cardholder Information

RUN_POY8000

POX8010

Exceed Limit per Transaction

Provides information about employee procurement card expenditure amount limits per transaction. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Exceptions

RUN_POY8010

POX8011

Exceed Limit per Cycle

Provides information about employee procurement card expenditure amount limits per cycle. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Exceptions

RUN_POY8010

POX8012

Exceed Transactions per Day

Provides information about employee number of procurement card transactions per day limits. ((BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Exceptions

RUN_POY8010

POX8013

Exceed Transactions per Cycle

Provides information about employee number of procurement card transactions per cycle limits. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Exceptions

RUN_POY8010

POX8014

Unauthorized Commodity

Provides information about employee procurement card purchases involving unauthorized commodity codes. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Exceptions

RUN_POY8010

POX8020

Expected Credits

Provides a list of disputed procurement card transactions.

Statement lines listed on the Expected Credits report are those for prior periods where a dispute amount has been entered, and the credit collected indicator has not been selected. (BI Publisher)

Purchasing > Procurement Cards > Reports > Expected Credits

RUN_POY8020

POX8030

Purchase Detail by Issuer

Provides procurement card expenditures made using a particular credit card provider. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Details

RUN_POY8030

POX8031

Purchase Detail by Merchant

Provides procurement card expenditures for a specific merchant. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Details

RUN_POY8030

POX8032

Purchase Detail by Employee

Provides procurement card expenditures of a single cardholder or all of the cardholders. (BI Publisher)

Purchasing > Procurement Cards > Reports > Purchase Details

RUN_POY8030

POX8050

Purchase Summary by Issuer

Provides a summary of all procurement card purchases sorted by supplier. (BI Publisher)

Purchasing > Procurement Cards > Reports > Account Summary

RUN_POY8050

POX8051

Purchase Summary by Merchant

Provides a summary of all procurement card purchases sorted by merchant. (BI Publisher)

Purchasing > Procurement Cards > Reports > Account Summary

RUN_POY8050

POX8052

Purchase Summary by Employee

Provides a summary of all procurement card purchases sorted by employee. (BI Publisher)

Purchasing > Procurement Cards > Reports > Account Summary

RUN_POY8050

POX8060

Credit Detail by MCG

Provides information about cardholders credit activity and summarizes the transaction amount for each account number. Lists all credit transactions grouped by MCG. (BI Publisher)

Purchasing > Procurement Cards > Reports > Credit Detail By MCG

RUN_POY8060

POX8061

Non-Preferred Supplier

Identifies all purchases involving nonpreferred suppliers within an MCC. Indicates whether cardholders are adhering to organizational policy in the use of preferred suppliers. (BI Publisher)

Purchasing > Procurement Cards > Reports > Non-Preferred Supplier

RUN_POY8061

POX8062

Top Supplier Chains

Lists the supplier chains based on the volume during the reporting period for the selected MCGs. (BI Publisher)

Purchasing > Procurement Cards > Reports > PCard Top Supplier Chains Rpt

RUN_POY8062

POX8063

Top Merchant Category

Lists the merchant categories based on the volume during the reporting period for the selected MCGs. (BI Publisher)

Purchasing > Procurement Cards > Reports > Top Merchant Category

RUN_POY8063

POX8064

MCC Exceptions

Provides Merchant Category Code Exceptions. (BI Publisher)

Purchasing > Procurement Cards > Reports > MCC Exceptions Report

RUN_POY8064

PO_ITMSUBU

Item Substitution Usage

Provides a listing of Purchase Order Lines whose items have been substituted.

Purchasing, Purchase Orders, Reports, Item Substitution Usage

RUN_POITMSUBU

PO_ITEMSUBS

Item Substitution Summary

Provides a summary usage listing of substitute items.

Purchasing, Purchase Orders, Reports, Item Substitution Usage Summary

RUN_POITMSUBS

POX3010

Contract Release by BU

Lists of order contract releases based by business unit.

Procurement Contracts, Reports, Order Contract Releases

RUN_POY3010

POX1052

Recurring Voucher Contract Details

Lists recurring voucher contract details by SetID and contract ID.

Procurement Contracts, Reports, Recurring Voucher Details

RUN_POY1052

POX3020

Contract Release by SetID

Lists order contract releases based by SetID.

Procurement Contracts, Reports, Order Contract Releases

RUN_POY3010

Report ID and Report Name

Description

Navigation

Run Control Page

CMS3000

Estimate vs. Actual Landed Cost

Provides purchase price variance for landed cost elements. (SQR)

Purchasing > Receipts > Reports > Estimate/Actual Landed Cost > Estimate vs Actual

RUN_CMS3000

CMS3010

Total Purchase Variance

Provides purchase price variance and exchange rate variance for landed cost elements. (SQR)

Purchasing > Receipts > Reports > Total Purchase Variance > Total Variance

RUN_CMS3010

CMS3020

Standard Purchase Variance

Provides purchase price variance at receipt of landed cost elements for standard costed items only. (SQR)

Purchasing > Receipts > Reports > Standard Purchase Variance > Standard Variance

RUN_CMS3020