List of Open Requisition Lines by Buyer Report

Report Series Name
C-U-PS-Requisition-Aging

Report Name
List Of Open Requisition Lines By Buyer

Library
Source code is located in PSPUBLIC

Use
This report series is used by purchasing managers to review open requisition lines assigned to agency buyers. This report should be run monthly.

Content
This report lists all open requisition lines assigned to each buyer and the number of days since the line was approved. Unlike the other two reports in this series, this report includes split lines and lines with RFQ pending. This report is used to find requisition lines that have been open for an extended period of time.

The other reports produced by this report series are the Contents of Buyers Queue by Buyer report and the Contents of Buyers Queue by Division report.

Totals
N/A

Column Headings

  • BUYING ENTITY - Code which represents the buying entity under which the requisition was created
  • REQUISITION NUMBER - Unique number that identifies the requisition
  • LINE NUMBER - Requisition line number
  • LINE STATUS - Status of the requisition line which may be Unresolved, Approved, Split, or Request For Quote (RFQ) pending
  • REQUESTER NAME - Requester’s name and ID
  • REQUESTER PHONE NO. - Phone number associated with the requester ID as entered on the Requester Definition (RED) screen
  • REQUESTER ENTERED DATE - Date the requisition was entered
  • REQUESTER APPROVAL DATE - Date the requisition was approved
  • DAYS SINCE APPROVAL - Number of days between system date and requester approval date.

Run Statements
The run statement member name is C-U-PS-Requisition-Aging-Run

000010 Option Library(Pspublic)
000020 Run C-U-Ps-Requisition-Aging
000100 Into Library Xxxxxxxx
000200 Select Pur-Buying-Entity
000300 ('42BE' '42BS')

Type over the displayed variable values with your agency’s values.