Queries - Supporting P2P


P2P Reports


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

SUPOQ320

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)

SUPOQ196

eProcurement  
PO vs Invoice Variance

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

SUPOQ184

eProcurement
Accounts Payable receipted not confirmed

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

SUGLQ130

General Ledger
Outstanding Orders

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)