Critical Stock on Hand dashboard
The Critical Stock on Hand dashboard has a report and a chart and Key Performance Indicators (KPIs).
KPIs on the dashboard are Unallocated Qty, Allocated Qty, On Order Qty, SOH Qty, Average Cost, Average SOH Qty.
To access Critical Item Supply reports, select .
The Critical Stock Status chart is a banded bar chart. Stocking Locations are on the Y axis, Unallocated (Available SOH), Intransit, Inspection On Hold, In process, and Backordered. Allocated quantity are on the X axis, and stacked per location. There is a 0 constant value to differentiate between negative (outgoing stock) and positive (coming into stock) net value per location.
The Critical Stock On Hand report lists items at stocking locations based on the filters selections. The report is a similar to the existing Stock on Hand report with additional fields. The locations in the report are Stocking Locations (IC Location Type = Inventory Location). This filtering is applied in the report itself. Other filters such as Company, Inventory Location Code, Item Number, Purchasing Class Major, Purchasing Class Minor, User Field 1 are also applied to the report..
Columns are arranged in this order:
| Report element | Source attribute - Inventory on hand |
|---|---|
| Company | Company.Company |
| Inventory Location Code |
Inventory Location.Inventory Location Code (filtered to display only Loc Type Inventory) |
| Item Number | Item.Item Number |
| Item Description | Item.Item Description |
| Stock UOM | Item.Stock UOM |
| Unallocated Quantity | Sum: Available SOH |
| Allocated Quantity | Sum: Allocated Quantity |
| Stock On Hand Quantity | Sum: Stock On Hand Quantity |
| In Process Quantity | Sum: In Process Quantity |
| In Transit Quantity | Sum: Intransit Quantity |
| Inspection Hold Quantity | Sum: Inspection Hold Quantity |
| Backordered Quantity | Sum: Backordered Quantity |
| On Order Quantity | Sum: On Ordered Quantity |
| Reorder Document | IOH Attributes.Reorder Document |
| Minimum Order Quantity | Sum: Minimum Order Quantity |
| Safety Stock | Sum: Safety Stock |
| Last Receipt Cost | Sum: Receipt Cost |
| Leadtime days | Sum: Leadtime Days |
| Last Leadtime | Sum: Last Leadtime |
| Average Stock On Hand Quantity | Sum: Average Stock On Hand Quantity |
| Average Cost | Sum: Average Cost |
| Current Inventory Value | Sum: Current Inventory Value |
| Reorder Point | Sum: Reorder Point |
| Reorder Quantity | Sum: Reorder Quantity |
| GTIN For Stock UOM | Item.GTIN For Stock UOM |
| Replacement Item | Item.Replacement Item |
| Manufacturer Number | Item.Manufacturer Number |
| Manufacturer Division | IOH Attributes.Manufacturer Division |
| Manufacturer Code | IOH Attributes.Manufacturer Code |
| UNSPSC Segment | Item.UNSPSC Segment |
| UNSPSC Family | Item.UNSPSC Family |
| UNSPSC Class | Item.UNSPSC Class |
| UNSPSC Commodity | Item.UNSPSC Commodity |