Purchase Order and Query Tool
Users may use the Requisition and Purchase Orders Query tool to view the status of requisitions, purchase orders, and invoice payments.
To view one requisition, purchase order or invoice status at a time, see How To: View Requisitions, Purchase Orders or Invoices. To view or supress commitments, see How To: View or Suppress Commitments.
To view multiple requisitions or purchase orders in one report, see iProcurement reports found in ReportMart3 listed below:
|Report Title||Report Description|
|FIN_PO_209_AP_Supplier_Info||Provides a listing of all vendors, 3rd party payees and Stanford payees (staff, faculty, affiliates) stored in the Oracle ERP system for purchase order, non-purchase order and reimbursement payments.|
|FIN_PO_207_AP_Requisition_Detail||Run this report to see all the information pertinent to your requisitions, including Purchase Order, Invoice, and Payment information.|
|FIN_PO_206_AP_Purch_Order_Detail||Use this report to find and display information specific to Purchase Orders. This report is searchable by PO Number, Supplier Name, or Buyer Name. Provides detailed information associated with a given Purchase Order, including Receiving, Invoice, and Payment information.|
|FIN_EXP_148_Purch_Order_Recon||This report can be used to aid in the detailed review of Purchase Orders. The report includes information related to the Purchase Order including any PO Change Order Number, Receiving information, Invoice information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling to the purchase order information.|
|FIN_PO_201_AP_Invoice_Detail||Provides detailed information associated with invoices based on the search criteria provided. Includes Supplier, Invoice, and Payment information.|
|FIN_EXP_138_Invoice_Detail_Recon||This report can be used to aid in the detailed review of invoices. It can also be used to provide additional details to facilitate PI Quarterly Certification for Sponsored Projects. The report includes information related to the Invoice including Supplier Information, Invoice Information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling all the way to the Invoice information and image of the actual vendor invoice.|
|FIN_PO_205_AP_Remittance_Advice||Provides complete information about checks generated from the Accounts Payable system. Displays check number, date, and amount, and all invoices and invoice amounts related to that check.|