Inquire Warehouse Stock

Warehouse Stock Information

This page allows you to inquire the stock details for item/variants stored in the warehouse of a stocking point or OU. You can specify the stocking point and the warehouse code for which you wish to make stock information inquiry. You can also specify item code, variant code and required UOM. Based on the entered details, the system retrieves the zone, bin, total stock quantity, stock status, lot details, manufacturing date, expiration date and retest date of the lots.

Select the " Inquire Warehouse Stock " link under the "Stock Maintenance" business component

The “Warehouse Stock Information” page appears.

Enter the following in the Header:

Stocking Point	Use the drop-down list box to select the stocking point or OU for which you wish to inquire the stock. All the OUs where the “Stock Maintenance” component is deployed will be displayed here in alphabetical order. The system displays the current login OU by default if the login OU is one of the values in the drop-down list box. Else, the system displays the first value from the list.
	Press <Enter> Key

The system displays the following details in the header:

Stocking Point Desc.	A textual description of the stocking point. The system retrieves the description for the corresponding OU or stocking point.
	Zoom facility available

Enter the following details in the header:

Stock Status	Use the drop-down list to indicate the status of the stock. It can be ”Accepted”, “Allocated”, “Bill-Hold”, “Conditionally Accepted”, “Consignment-In-Customer”, “Consignment-Out-Customer”, “Consignment-In-Supplier”, “Held”, “In-transit”, “Quarantined”, “Rejected” along with “All”. The system displays “All” by default on the launch of the page.
Warehouse Code	A unique code identifying the warehouse whose stock details you wish to inquire (Alphanumeric, 10).
	Press <Enter> Key
	Help facility available.

The system displays the following details in the header

Warehouse Desc.	A textual description of the warehouse. The system retrieves the description for the corresponding warehouse code.
Warehouse status	The status of the warehouse. The system retrieves the warehouse status from the corresponding warehouse code. The status can be “Active” or “Inactive” or “Frozen”.

Enter the following details in the header

Item Code	A unique code identifying the item (Alphanumeric, 32). This code must be applicable for the selected OU.
	Help facility available.
Variant Code	A unique code identifying the variant, if the item code supports variants (Alphanumeric, 8). .
	Help facility available
Required UOM	The unit of measurement in which you wish to inquire the stock details of the item (Alphanumeric, 10). If the stock UOM and required UOM are different, the system retrieves the conversion factor between the required UOM and stock UOM The system displays an error message if no conversion exists.
	Help facility available

The system displays the following:

Item Variant Desc.	The textual description of the item/variant.
	Zoom facility available
Stock UOM	The unit of measurement of the item stored in the warehouse.
Alternate UOM	The alternate unit of measurement of the item stored in the warehouse.

Click the “Get Stock” pushbutton to retrieve the total stock quantity, total stock value, unrestricted quantity, costing method and the stock status information.

The system also retrieves the zone, bin, total stock quantity, stock status, lot/sub-lot details, manufacturing date, expiration date and retest date of the lots and displays the values in the multiline.

The system displays the following in the “Stock Information” group box:

Total Stock Qty.	The total amount of stock quantity in various stock statuses in the selected warehouse. The quantity displayed here is the sum of all the stock status quantities in each zone/bin combination in the warehouse
Costing Method	The valuation or costing method used to calculate the value of the stock. The system displays one of the following values, “LFL”, LIFO”, “FIFO”, “Standard Cost” and “Weighted Average”.
Total Stock Value	The sum of the stock value in the selected warehouse. The value displayed here is the sum of the value of items in the various zones/bins warehouse.
Unrestricted Qty.	The total amount of free physical stock in the selected warehouse. Free physical stock is the stock available, which has not been reserved or allocated by any demand.
Unit Cost	The unit cost of the item. This cost will be displayed only for the items of Costing Method Weighted Average and Standard Cost. The current unit cost of the item will be displayed.

Click the “Get Pending Stock” pushbutton to retrieve the stock quantities pending against purchase order and production order.

The system displays the following in the “Stock Information” group box:

Pur. Order Pending Qty.	The sum of all stock quantities pending against release slip, purchase order, goods receipt and subcontract purchase order/release slip. The system retrieves these values only if the item is purchased and if any pending purchase order/release slip/goods receipt/subcontract purchase order exists.
Prod. Order Pending Qty.	The sum of all stock quantities pending against production and inventory receipt. The system retrieves these values only if the item is manufactured and if any pending production order/work order/inventory receipt exists.
Containerized Qty.	The total amount of stock that are containerized in the selected warehouse.
Non Containerized Qty.	The total amount of stock that are not containerized in the selected warehouse.
Total Alternate Qty.	The total amount of stock in alternate quantity in various stock statuses in the selected warehouse. The quantity displayed here is the sum of all the stock status quantities in each zone/bin combination in the warehouse
Containerized Alternate Qty.	The total amount of alternate stock that are containerized in the selected warehouse.
Non Containerized Alt Qty.	The total amount of alternate stock that are not containerized in the selected warehouse.

The system displays the following in the “Stock Status Information” group box:

Total Accepted Qty.	The quantity of stock in “Accepted” stock status in the warehouse.
Total Rejected Qty.	The quantity of stock in “Rejected” stock status in the warehouse.
Total Held Qty.	The quantity of stock in “Held” stock status in the warehouse.
Total Allocated Qty.	The quantity of stock in “Allocated” stock status in the warehouse.
Total Intransit Qty.	The quantity of stock in “In-Transit” stock status in the warehouse.
Total Quarantine Qty.	The quantity of stock in “Quarantine” stock status in the warehouse.
Total Consignment In-Supplier Qty.	The quantity of stock in “Consignment in supplier ” stock status in the warehouse. The supplier sends these stocks into the warehouse on consignment basis.
Total Consignment In-Customer Qty.	The quantity of stock, in “Consignment in customer” stock status in the warehouse. The customer sends these stocks into the warehouse on consignment basis.
Total Consignment Out-Customer Qty.	The quantity of stock in “Consignment out customer ” stock status in the warehouse. The customer receives these stocks from the warehouse on consignment basis.
Total Bill And Hold Qty.	The quantity of stock in “Bill-Hold” stock status in the warehouse.
Total Conditionally Accepted Qty.	The quantity of stock in “Conditionally Accepted” stock status in the warehouse.

The system displays the following in the “Alternate Qty. Information” group box:

Accepted Qty.	The alternate quantity of stock in “Accepted” stock status in the warehouse.
Rejected Qty.	The alternate quantity of stock in “Rejected” stock status in the warehouse.
Held Qty.	The alternate quantity of stock in “Held” stock status in the warehouse.
Intransit Qty.	The alternate quantity of stock in “In-Transit” stock status in the warehouse.
Quarantine Qty.	The alternate quantity of stock in “Quarantine” stock status in the warehouse.
Consignment In-Supplier Qty.	The alternate quantity of stock in “Consignment in supplier ” stock status in the warehouse. The supplier sends these stocks into the warehouse on consignment basis.
Consignment In-Customer Qty.	The alternate quantity of stock, in “Consignment in customer” stock status in the warehouse. The customer sends these stocks into the warehouse on consignment basis.
Consignment Out-Customer Qty.	The alternate quantity of stock in “Consignment out customer ” stock status in the warehouse. The customer receives these stocks from the warehouse on consignment basis.
Bill And Hold Qty.	The alternate quantity of stock in “Bill-Hold” stock status in the warehouse.
Conditionally Accepted Qty.	The alternate quantity of stock in “Conditionally Accepted” stock status in the warehouse.

Enter the following in the “Lot Selection Criteria” group box:

Lot No. From	The lot number from which you wish to inquire the lot details.
Lot No. To	The lot number till which you wish to view the lot details.

Click the “Get Specific Lot Stock” pushbutton to retrieve the zone, bin, quantity, stock status and sub-lots for the lots, which are in stock. The system also retrieves the manufacturing date, expiration date and retest date for the lots, which are in stock.

The system displays the following in the “Detailed Stock Information” multiline:

Zone	The number identifying the zone in the warehouse in which the item is stored.
Bin	The number identifying the bin in which the item is stored in the zone.
Qty.	The total amount of stock quantity in the zone/bin in the warehouse.
Stock Status	The stock status of the item stored in the zone/bin combination in the warehouse.
Lot No.	The unique number identifying the lot in the warehouse.
Ref. Lot No.	The lot number specified by the vendor or manufacturer.
Sub Lot No.	The number identifying the sub-lot under the lot.
Manufacturing Date	The date of manufacture of the lot.
Expiration Date	The date of expiry of the lot.
Retest Date	Date on which the item that is in “Accepted” stock status are expected to move to “Quarantined” status. Retest date should be a sum of manufacturing date and retest period. This date would be less than the lot expiration date.
Alternate Qty.	The alternate quantity of the stock.

Check the “Select” column in the multiline for viewing serial number information, inquiring stock details of lot controlled and serial controlled items based on their attributes and viewing item information.

To proceed, carry out the following

Select the “View Serial No. Information” link at the bottom of the page to view the details of serial numbered items.
Select the “Inquire Attribute Based Lot Stock” link at the bottom of the page to inquire stock of lot controlled items based on their attributes.
Select the “Inquire Attribute Based Serial No. Stock” link at the bottom of the page to inquire stock of serially controlled items based on their attributes.
Select the “View Item Information” link at the bottom of the page to view details of items.