Open Stock Requisition Item Issues Inquiry (OSRI)

Open Stock Requisition Item Issues Inquiry (OSRI) displays issue or return information about an item line from an open or recently closed Stock Requisition (SR) or Over the Counter (OC) documents.

A record is added to this screen for each Over the Counter (OC) document accepted by the system, for each Stock Requisition (SR) document that was picked by a Pick and Issue (PI) document, and for all Stock Return (SN) documents that reference an Over the Counter (OC) or Stock Requisition (SR) document. As modifications are submitted and accepted, records are changed. When an Issue Confirmation (CI) document is accepted for a requisition the Issue Date and Issue Quantity fields are updated as well as the Unit Cost and Unit Price fields.

Records are deleted from this table by the Inventory Subsystem Table Purge offline program when their corresponding Open Stock Requisition Header Inquiry (OSRH) is closed for more days than the number of retention days indicated on Warehouse Management (WHS2). For more information on the Inventory Subsystem Table Purge offline program, see the S ystem Administration Guide .


Requisition Document ID	Key field. Enter the unique number assigned to this stock requisition on the document.
Item Line Number	Key field. Enter the number of the item line from the document.
Issue/Return Document ID	Key field. Enter the unique transaction ID of the Over the Counter (OC) or the Stock Issue Confirmation (CI) created when the pick ticket was printed for this requisition, or the Stock Return (SN) created when the stock item was returned to the warehouse.
Description	Display only. The description of the item line is usually inferred from Inventory Inquiry (INVN).
Stock/Item	Display only. The stock item from a stock requisition or issue is displayed.
Job Type	Display only. If the Work Order Subsystem is installed, the job type for this stock item is displayed.
Released Quantity	Display only. The quantity of the stock item that was released from inventory and is ready for delivery is displayed.
Unit Price	Display only. The price for one unit of the stock item is displayed.
Issue Unit of Measure	Display only. The unit of measure used to issue this stock item is displayed.
Unit Cost	Display only. The wholesale price for one unit of the stock item is displayed.
Issue/Return Date	Display only. The date when the stock item was delivered, or when the stock item was returned to the warehouse is displayed.
Total Price	Display only. The computed price of the item line is displayed. ( Unit Price multiplied by the Issue/Return Quantity .)
Issue/Return Quantity	Display only. The quantity of the stock item that was delivered or returned is displayed.
Refund	Display only. The Total Price minus the Return Charge is displayed.
Return Charge	Display only. The amount deducted from the issue total price for a stock return is displayed.