Stock Information For Stocking Point

This page allows you to inquire the stock details for item/variants stored in all the warehouses of a stocking point or OU. You can specify the stocking point and whether you wish to inquire stock only for capital warehouses or all warehouses inclusive of or exclusive of capital warehouses. You can also specify item code, variant code and required UOM. Based on the entered details, the system retrieves total stock quantity, costing method, total stock value, unrestricted quantity, stock available with subcontractor, quantity pending against purchase order and production order depending on whether the item/variant is purchased or manufactured and quantity of stock consumed by work in progress (WIP).

Select the “Inquire Stock For Stocking Point” link under the “Stock Maintenance” business component.

The “Stock Information For Stocking Point” 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.
Stocking Point Desc.	A textual description of the stocking point. The system retrieves the description for the corresponding OU or stocking point.
Stock Inquiry For	Use the drop-down list box to select the type of warehouses for which you wish to inquire stock information. The system displays the following values:
	Including Capital Warehouses – Indicates that all the warehouses in the selected OU must be considered for stock information inquiry. Excluding Capital Warehouses – Indicates that all the warehouses except “Capital” type warehouses in the selected OU must be considered for stock information inquiry. Only Capital Warehouses – Indicates that only warehouses of type capital must be considered for stock information inquiry
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
Item Variant Desc.	The textual description of the item/variant.
Stock UOM	The 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 and costing method.

The system also retrieves the accepted quantity, rejected quantity, held quantity, allocated quantity, in-transit quantity, quarantine quantity, consignment in supplier quantity, consignment in customer quantity, consignment out customer quantity, bill and hold quantity, conditionally accepted quantity and warehouse description 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 all the selected warehouses in the OU. The quantity displayed here is the sum of all the stock status quantities in each 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 all the selected warehouses in the OU. The value displayed here is the sum of the value of items in all warehouses.
Unrestricted Qty.	The total amount of free physical stock of all the selected warehouses in the OU. The quantity displayed here is the sum of all the free physical stocks in each warehouse.

Click the “Get Pending Stock” pushbutton to retrieve the stock quantities pending against purchase order and production order, stock with subcontractor, and stock consumed by WIP in both the group box and multiline.

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 purchase order pending quantity displayed here is the sum of all the quantities pending for all warehouses in the OU.
SC Order Pending Qty	The total quantity of stock issued and available with the subcontractor against the Sub Contract Order. This value is equal to the sum of all the stock supplied to the subcontractor from various warehouses in the OU.
Prod. Order Pending Qty.	The sum of all stock quantities pending against production and inventory receipt. The production order pending quantity displayed here is the sum of all the quantities pending for all warehouses in the OU.
Qty. In WIP	The quantity of stock used up from the warehouse for production/fabrication in the various plants. The system retrieves the stock in WIP or shop floor stock from the “Shop Floor” component. The quantity displayed here is the sum of all the quantities in WIP in various warehouses in the OU.

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

Warehouse Code	A unique code identifying the warehouse.
Accepted Qty.	The quantity of stock in “Accepted” stock status in the warehouse.
Rejected Qty.	The quantity of stock in “Rejected” stock status in the warehouse.
Held Qty.	The quantity of stock in “Held” stock status in the warehouse.
Allocated Qty.	The quantity of stock in “Allocated” stock status in the warehouse.
Intransit Qty.	The quantity of stock in “In-Transit” stock status in the warehouse.
Quarantine Qty.	The quantity of stock in “Quarantine” stock status in the warehouse.
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.
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.
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
Bill And Hold Qty.	The quantity of stock in “Bill-Hold” stock status in the warehouse.
Conditionally Accepted Qty.	The quantity of stock in “Conditionally Accepted” stock status in the warehouse.
Total Qty.	The total quantity of stock in all different stock statuses in the warehouse.
Total Value	The total value of the stock stored in the warehouse.
Unrestricted Qty.	The amount of free physical stock in the warehouse. Unrestricted quantity is the stock available for the item variant, for which no reservation or allocation has been made
Pur. Order Pending Qty.	The quantity of stock pending against purchase order, release slip, goods receipt and subcontract purchase order/release slip. The system retrieves the quantity pending for movement into the warehouse from “Purchase Order”, “Purchase Release Slip”, “Goods Receipt”, “Subcontract Purchase Order” and “Subcontract Release Slip” components. The system retrieves these values only if the item is purchased and if any pending purchase order, release slip, goods receipt, and subcontract purchase order/release slip exists. The system calculates the sum of all pending quantities and displays it.
Prod. Order Pending Qty.	The quantity of stock pending against production order/work order and inventory receipt. The system retrieves the quantity pending for movement into the warehouse from “Production Order”, and “Shop Floor” components. The system retrieves these values only if the item/variant is manufactured and if any pending production/work order or inventory receipt exists. The system calculates the sum of all pending quantities and displays it.
Warehouse Desc.	The textual description of the warehouse.

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

To proceed, carry out the following

Select the “View Warehouse Stock Information” link at the bottom of the page to inquire information on the stock stored in the warehouse.
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.