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. |
|
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) |
|
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) |
|
RUN_POPO009 |
POPO010 PO Acknowledgement |
Lists specified purchase order acknowledgments sorted by either supplier name or buyer name. (SQR) |
|
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) |
|
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) |
|
RUN_POPO012 |
PORB7010 Supplier Claims |
Provides a hard copy of the claim. (SQR) |
|
VRBT_CLAIMS_PRT_RC |
PORC100 ASR |
Provides information about staged receipts that have been created from ASR documents received by electronic data exchange. (SQR) |
|
RUN_PORCV100 |
PORC200 Planned Receipt |
Provides information about receipts generated from purchase order information to be used for electronic data collection transactions. (SQR) |
|
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) |
|
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) |
|
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) |
|
RUN_PORC_USG_LBL |
PORC930 Device Tracking Receipts |
Displays device-tracked items that have been received. (SQR) |
|
RUN_PORC930 |
PORFQ01 RFQ Dispatch/Print |
Provides a hard copy of the request for quote. (SQR) |
|
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) |
|
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) |
|
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. |
|
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) |
|
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) |
|
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) |
|
RUN_PORQ011 |
PORT001 RTV Dispatch/Print |
Provides a hard copy of the selected return to vendor transactions. (SQR) |
|
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) |
|
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) |
|
RUN_POS8000 |
POVR100 Vendor Rebate Dispatch |
Prints a hard copy of the vendor rebate agreement. (SQR) |
|
RUN_DISP_POVRBT100 |
POVRB200 Rebate Threshold Analysis |
Provides vendor rebate agreement threshold analysis information for selected vendor rebate agreements. (SQR) |
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) |
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) |
|
RUN_PO_DISPATCH |
POXMLP_PRINT POXMLP_PRINT |
Provides information about selected purchase orders. (BI Publisher) |
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) |
|
RUN_POY4006 |
POX4007 Expediting Report by Supplier |
Provides purchase order details such as late days and due date sorted by supplier. (BI Publisher) |
|
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) |
|
RUN_POY4008 |
POX4030 PO Detail Listing By PO Date |
Provides detailed purchase order information sorted by purchase order date. (BI Publisher) |
|
RUN_POY4030 |
POX4031 PO Detail Listing By Supplier |
Provides detailed purchase order information sorted by supplier. (BI Publisher) |
|
RUN_POY4031 |
POX4032 PO Detail Listing By Buyer |
Provides detailed purchase order information sorted by buyer. (BI Publisher) |
|
RUN_POY4032 |
POX4100 PO Detail Listing By Buyer |
Provides a cross-reference between requisitions and the purchase orders created from those requisitions. (BI Publisher) |
|
RUN_POY4100 |
POX5001 Receiver Summary |
Provides a summary listing of receipts within a specified date range. (BI Publisher) |
|
RUN_POY5001 |
POX5010 Receiver Shipto Detail |
Provides a summary listing of receipts shipments within a specified date range. (BI Publisher) |
|
RUN_POY5010 |
POX5020 Receiver Account Detail |
Provides a detailed list of shipments by receiver ID. (BI Publisher) |
|
RUN_POY5020 |
POX1100 Requisition to PO XREF |
Provides information about selected requisitions and the purchase orders that have been created from them. (BI Publisher) |
|
RUN_POY1100 |
POX3031 Contract Activities |
Displays line level information about procurement documents associated with a contract. (BI Publisher) |
|
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) |
|
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) |
|
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) |
|
RUN_POY4008 |
POX4010 PO Listing by PO Date |
Provides purchase order information sorted by purchase order date. (BI Publisher) |
|
RUN_PO4010 |
POX4011 PO Listing By Supplier |
Provides purchase order information sorted by supplier. (BI Publisher) |
|
RUN_POY4010 |
POX4012 PO Listing By Buyer |
Provides purchase order information sorted by buyer. (BI Publisher) |
|
RUN_POY4010 |
POX4013 PO Listing By Status |
Provides purchase order information sorted by status. (BI Publisher) |
|
RUN_POY4010 |
POX4020 Order Status By Supplier |
Provides purchase order status information sorted by supplier. (BI Publisher) |
|
RUN_POY4020 |
POX4021 Order Status by Item |
Provides purchase order status information sorted by item. (BI Publisher) |
|
RUN_POY4020 |
POX4030 PO Detail Listing By PO Date |
Provides detailed purchase order information sorted by purchase order date. (BI Publisher) |
|
RUN_POY4030 |
POX4031 PO Detail Listing By Supplier |
Provides detailed purchase order information sorted by supplier. (BI Publisher) |
|
RUN_POY4031 |
POX4032 PO Detail Listing By Buyer |
Provides detailed purchase order information sorted by buyer. (BI Publisher) |
|
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) |
|
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) |
|
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) |
|
RUN_POY4042 |
POX5001 Receiver Summary |
Provides a summary listing of receipts within a specified date range. (BI Publisher) |
|
RUN_POY5001 |
POX5010 Receiver Ship to Detail |
Provides a summary listing of receipts shipments within a specified date range. (BI Publisher) |
|
RUN_POY5010 |
POX5020 Receiver Account Detail |
Provides a summary listing of receipts with account distribution. (BI Publisher) |
|
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) |
|
RUN_POY5030 |
POX5035 Shop Floor Receipt Delivery |
Provides a detailed list of shop floor receipts. |
|
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. |
|
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. |
|
RUN_POY5060 |
POX5070 Bill of Entry Worksheet |
Provides a bill of entry worksheet. (BI Publisher) |
|
RUN_POY5070 |
POX6100 REQ/RFQ Cross Reference |
Provides a cross-reference between requests for quotes and the requisitions created from those requests for quotes. |
|
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) |
|
RUN_POY8000 |
POX8010 Exceed Limit per Transaction |
Provides information about employee procurement card expenditure amount limits per transaction. (BI Publisher) |
|
RUN_POY8010 |
POX8011 Exceed Limit per Cycle |
Provides information about employee procurement card expenditure amount limits per cycle. (BI Publisher) |
|
RUN_POY8010 |
POX8012 Exceed Transactions per Day |
Provides information about employee number of procurement card transactions per day limits. ((BI Publisher) |
|
RUN_POY8010 |
POX8013 Exceed Transactions per Cycle |
Provides information about employee number of procurement card transactions per cycle limits. (BI Publisher) |
|
RUN_POY8010 |
POX8014 Unauthorized Commodity |
Provides information about employee procurement card purchases involving unauthorized commodity codes. (BI Publisher) |
|
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) |
|
RUN_POY8020 |
POX8030 Purchase Detail by Issuer |
Provides procurement card expenditures made using a particular credit card provider. (BI Publisher) |
|
RUN_POY8030 |
POX8031 Purchase Detail by Merchant |
Provides procurement card expenditures for a specific merchant. (BI Publisher) |
|
RUN_POY8030 |
POX8032 Purchase Detail by Employee |
Provides procurement card expenditures of a single cardholder or all of the cardholders. (BI Publisher) |
|
RUN_POY8030 |
POX8050 Purchase Summary by Issuer |
Provides a summary of all procurement card purchases sorted by supplier. (BI Publisher) |
|
RUN_POY8050 |
POX8051 Purchase Summary by Merchant |
Provides a summary of all procurement card purchases sorted by merchant. (BI Publisher) |
|
RUN_POY8050 |
POX8052 Purchase Summary by Employee |
Provides a summary of all procurement card purchases sorted by employee. (BI Publisher) |
|
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) |
|
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) |
|
RUN_POY8061 |
POX8062 Top Supplier Chains |
Lists the supplier chains based on the volume during the reporting period for the selected MCGs. (BI Publisher) |
|
RUN_POY8062 |
POX8063 Top Merchant Category |
Lists the merchant categories based on the volume during the reporting period for the selected MCGs. (BI Publisher) |
|
RUN_POY8063 |
POX8064 MCC Exceptions |
Provides Merchant Category Code Exceptions. (BI Publisher) |
|
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) |
|
RUN_CMS3000 |
CMS3010 Total Purchase Variance |
Provides purchase price variance and exchange rate variance for landed cost elements. (SQR) |
|
RUN_CMS3010 |
CMS3020 Standard Purchase Variance |
Provides purchase price variance at receipt of landed cost elements for standard costed items only. (SQR) |
|
RUN_CMS3020 |