Future Year Requisition Lines Report

Report Series Name
C-U-PS-List-Future-Req

Report Name
Future Year Requisition Lines

Library
Source code is located in PSPUBLIC

Use
To be used to list requisitions which have lines identified for future year budget activity. Based on the information contained in the report, buyers are notified of requisitions with a multi-year indicator that have not been converted to purchase orders. For this reason, the report will be most useful as the end of a fiscal year approaches.

Content
Lists Requisition Number, Line Number, Fiscal Year, Company, Account, Center and Line Amount for each Requisition Line in the Buying Entity. This report sorts by buying entity, future fiscal year and PO number.

Totals
N/A

Column Headings

  • BUYING ENTITY - the buying entity under which the requisition was created.
  • REQ. NUMBER - the requisition number
  • LINE NMBR - the requisition line number which is unique to each requisition.
  • FISCAL YEAR - the two-digit future fiscal year indicator entered on this requisition line
  • COMPANY - the GL Company charged for this item on the requisition.
  • ACCOUNT- the GL Account charged for this item on the requisition.
  • CENTER- the GL Center charged for this item on the requisition.
  • REQ AMOUNT - the requisition amount calculated by multiplying quantity requested by unit cost.

Run Statements
The run statement member name is C-U-PS-List-Future-Req-Run

000010 Options Library (Pspublic)
000100 Run C-U-Ps-List-Future-Req
000110 Into Library Xxxxxx
000200 Select Pur-Buying-Entity
000300 ('06BG' '42BS')

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