Queries - Supporting P2P
The Procure to Pay (P2P) business process will result in greatly increased Purchase Order (PO) activity. To support Financial Shared Services and School/Department Finance Personnel in the management of this activity new queries have been developed and existing queries adjusted. This quick reference guide shows how these queries can be utilised to support P2P management and analysis.
PeopleSoft Queries
|
Name |
Description |
P2P Purpose |
Prompts |
|---|---|---|---|
|
eProcurement Requisition / PO Details |
Displaying Requisition/PO activity. Accessed by School's delivery/receiving personel to confirm goods delivered belong to the school and identify what PO for receipting. |
Date (Range), RC (Range), Entered By ID(Drop Down Box) |
|
|
eProcurement |
Displaying variances between PO & suppliers invoice. Triggering requests to Accounts Payable to put a voucher on hold using the Voucher on Hold Procedure. |
Date (From), RC (Range), Entered By ID |
|
|
eProcurement |
Displaying unconfirmed accounts payable receipts. Triggering the confirming of receipts allowing for payment of suppliers invoices. |
Date (Range), RC (Range) |
Hyperion Queries
|
Name |
Description |
P2P Purpose |
Prompts |
|---|---|---|---|
|
General Ledger |
Displaying balance of outstanding PO commitments. Review of PO's with balances for extended periods. Triggering requests to Purchasing for PO's to be closed off using the Close Order Procedure which reverses remaining commitments. |
RC's, Project(Range), Date (As At) |