Inquire BU Stock Information

BU Stock Information

This page allows you to inquire the stock details for item/variants stored in all the warehouses of a business unit. You can specify whether you wish to inquire stock only for capital warehouses or all warehouses inclusive of or exclusive of capital warehouses in the business unit. 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 available in shop floor (WIP) for the specified item-variant.

Select the " Inquire BU Stock" link under the "Stock Maintenance” business component

The “BU Stock Information” page appears.

Enter the following in the Header:

Stock Inquiry For	Use the drop-down list box to select the type of warehouses in the BU for which you wish to inquire the stock details. The system displays the following options: Including Capital Warehouses – Indicates that all warehouses in the BU must be considered for stock information inquiry. Excluding Capital Warehouses – Indicates that all warehouses, except warehouses of “Capital” type, must be considered for stock inquiry. Only Capital Warehouses – Indicates that only warehouses of “Capital” type must be considered for stock inquiry.
Item Code	A unique code identifying the item (Alphanumeric, 32). The system retrieves the variant code, item description, and stock UOM for the corresponding item code and displays them. 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

Note: If the calculated quantity is in fractions, the system checks whether the required UOM supports functions from the “UOM Administration” component. If the required UOM does not support fractions, the calculated quantity is rounded off to the nearest integer and displayed.

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, quarantined 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 stocking points in the BU. The quantity displayed here is the sum of all the stock status quantities in each stocking point.
Total Stock Value	The sum of the stock value in the entire stocking points in the BU. The value displayed here is the sum of the value of items in each OU.
Unrestricted Qty.	The total amount of free physical stock in all stocking points in the BU. The quantity displayed here is the sum of all the free physical stocks in each OU. (Free physical stock is the stock available which has not been reserved or allocated by any demand)

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 stocking points in the BU.
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 stocking points in the BU.
Prod. Order Pending Qty.	The sum of all stock quantities pending against production and also for which inventory receipt is to be made. The production order pending quantity displayed here is the sum of all the quantities pending for all stocking points in the BU.
Qty. In WIP	The quantity of stock issued from the stocking point for production in the various plants , which are yet to be consumed. 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 stocking points in the BU.

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

Stocking Point	The organizational unit within the BU whose stock details you wish to inquire.
Accepted Qty.	The quantity of stock in “Accepted” stock status in all warehouses in the stocking point.
Rejected Qty.	The quantity of stock in “Rejected” stock status in all warehouses in the stocking point.
Held Qty.	The quantity of stock in “Held” stock status in all warehouses in the stocking point.
Allocated Qty.	The quantity of stock in “Allocated” stock status in all warehouses in the stocking point.
Intransit Qty.	The quantity of stock in “In-Transit” stock status in all warehouses in the stocking point.
Quarantine Qty.	The quantity of stock in “Quarantine” stock status in all warehouses in the stocking point.
Consignment In-Supplier Qty.	The quantity of stock in “Consignment in supplier ” stock status in all warehouses in the stocking point. The supplier sends these stocks into the stocking point on consignment basis.
Consignment In-Customer Qty.	The quantity of stock in “Consignment in customer ” stock status in all warehouses in the stocking point. The customer sends these stocks into the stocking point on consignment basis.
Consignment Out-Customer Qty.	The quantity of stock in “ Consignment out customer ” stock status in the stocking point. The customer receives these stocks from the stocking point on consignment basis from the company
Bill And Hold Qty.	The quantity of stock in “Bill-Hold” stock status in all warehouses in the stocking point.
Conditionally Accepted Qty.	The quantity of stock in “Conditionally Accepted” stock status in all warehouses in the stocking point.
Total Qty.	The total quantity of stock in all different stock statuses in the stocking point.
Total Value	The total value of the stock stored in the stocking point.
Unrestricted Qty.	The amount of free physical stock in all warehouses in the OU. 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 or subcontracted and 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 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 “Select” column in the multiline for viewing OU stock information and item details.

To proceed, carry out the following

Select the “View Stock Information for Stocking Point” link at the bottom of the page to inquire information on the stock stored in the OU.
Select the “View Item Information” link at the bottom of the page to view details of items.