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 - Requesters 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.
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 agencys values.