Listing of Requisitions by Account Distribution Report

Report Series Name
C-U-PS-Commitment-Listing

Report Name
Listing Of Requisitions By Account Distribution

Library
Source code is located in PSPUBLIC

Use
Use this report to identify the open requisition lines included in the Available Funds File (AFF) committed funds balance. This report should be generated whenever questions arise concerning the transactions affecting the AFF committed funds balance.

Content
The report lists the amount of the commitment remaining on the AFF for each requisition line, sorted by company, account, center, and requisition. Each account distribution is listed on a separate page.

Totals
This report gives totals for account distribution and report.

Column Headings

  • REQUISITION NUMBER- a number which uniquely identifies a requisition within this buying entity
  • LINE NBR - requisition line number, identifies a particular line on a requisition. This number is unique within each requisition.
  • SPL NBR - requisition line split number. A maximum of 5 splits are allowed per requisition.
  • REQ LINE STATUS -indicates the status of the requisition line. (unresolved, unapproved, approved, split, delete, request for quote pending or closed)
  • REQ ID - the requisitioner identification code
  • REQUIRED SKU - the quantity required in stock keeping units.
  • ITEM DESCRIPTION - description of the item being requisitioned.
  • UNIT PRICE - the unit price of the item being ordered in stock keeping units.
  • EXT LINE VALUE - extended line value.

Run Statements
The run statement member name is C-U-PS-Commitment-Listing-Run

000010 Option Library(Pspublic)
000020 Run C-U-Ps-Commitment-Listing
000100 Into Library Xxxxxxxx
000200 *Select Pur-Req-Gl-Company-Id
000300 *Select Pur-Req-Gl-Account-Id
000400 *Select Pur-Req-Gl-Center-Id

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