Inventory On-hand
The Inventory On-Hand dashboard provides visibility into current stock levels, inventory valuation, and inventory movement. It helps businesses manage stock availability, monitor inventory cost, and support procurement and replenishment decisions.
Benefits of this dashboard
- Monitor stock levels: Provides real‑time visibility into available inventory.
- Control inventory costs: Tracks unit costs and valuation to support efficient procurement.
- Optimize warehouse distribution: Assesses stock placement across multiple locations to improve storage efficiency.
- Analyze inventory movement: Monitors inflows and outflows to reveal operational trends.
- Support data‑driven decisions: Informs purchasing and restocking strategies with accurate inventory insights.
Key performance indicators (KPIs)
| KPI | Description |
|---|---|
| Valuation | Total value of inventory on hand. |
| Unit Cost | Average cost per unit of inventory. |
| Quantity In | Total quantity received into inventory. |
| Quantity Out | Total quantity issued or sold from inventory. |
| Quantity On Hand | Current quantity available in inventory. |
| Quantity Invoiced | Total quantity invoiced. |
Visual components
| Title | View type | Description |
|---|---|---|
| Inventory Value by Product Group | Doughnut | Shows inventory value distribution by product group. |
| On-hand Inventory Quantity | Stacked Bar | Shows on-hand quantity distribution by warehouse. |
| Detailed Inventory Item Listing / Valuation | Worksheet | Shows item details by item group, including unit cost, quantities in and out, quantity on hand, quantity invoiced, valuation (average, latest, and manual), and latest cost. |
Filters
You can filter the dashboard with these panels:
- Company Code
- Warehouse
- Item Group
- Item
- Supplier Group Code
- Supplier