Manual Stock dashboard
Inventory tracking: valuation, quantities, active references, shortages / below threshold, movements and expiry alerts. The indicators adapt to the management mode (simple or advanced by batch/expiry).
Overview
The Stock dashboard gives a real-time view of inventory: how much the stock is worth, how many units and active references there are, which references are in shortage or below threshold, and — in advanced management — which batches are approaching their expiry date. It also reports the flows (inflows / outflows) and the valuation by nature and by location.
Goal
- Value tied-up stock
- Prevent shortages
- Anticipate expiries
- Track inflows / outflows
Target audience
- Logistics / warehouse
- Procurement
- Finance — valuation
The 4 strategic stock KPIs (value, shortage, returns, expiry) also feed into the Global dashboard.
Access and navigation
Side menu: Stock and Manufacturing (or Stocks without the Manufacturing Orders option) → Stock Dashboard.
Stock scoreboard
Six KPIs: stock value, total quantity, active references, items in shortage, below threshold and batches nearing expiry.
| Indicator | Meaning |
|---|---|
| Stock value | Total valuation (at cost or at selling price, depending on the chart). |
| Total quantity | Sum of the quantities in stock across all references. |
| Active references | Number of distinct references (sales + purchasing) present in stock. |
| In shortage | References at zero quantity (to be replenished urgently). |
| Below threshold | References that have dropped below their minimum alert threshold. |
| Nearing expiry | Batches whose expiry date is approaching (advanced stock). |
Alerts: shortage, threshold, expiry
Shortage — items at zero quantity, highlighted in red. To be replenished without delay.
Below minimum threshold — quantity has dropped below the stock line's alert threshold: an order needs to be prepared.
Expiry alerts — expired batches or batches nearing expiry (≤ 2 days = urgent, 3-5 days = near). To be cleared as a priority. Advanced stock only.
Valued defective returns — value of defective returns by item, valued at the ex-works price. See stock return notes.
Monthly flow (inflows/outflows)
The grouped bar chart contrasts, month by month, inflows (procurement) and outflows (sales, transfers, issue-note picking…) to visualize stock rotation.
A month where outflows > inflows repeatedly signals upcoming strain: adjust your procurement.
Stock status (donut)
The "Stock status" donut splits references into three groups: available, below threshold and shortage — the quickest read of overall availability.
Value & production
Two complementary analyses: purchase vs sale value (tied-up cost vs market valuation) and production yield: intact vs defective.
Other available charts
| Chart | Reading |
|---|---|
| Movements by type | Procurement, sale, clearance, stocktake, transfer, return note… |
| Value by location / category | Where the tied-up value is concentrated. |
| Top items by quantity | Most-stocked items. |
| Expiry buckets | Expired, expires ≤ 2 days, expires 3-5 days (advanced stock). |
Manufacturing indicators
When the company uses advanced stock and the Manufacturing Orders option, the dashboard adds a Manufacturing block on three rows: capacity and lead time, cost and scrap, variance from bill of materials. Figures cover the chosen period.
Units still producible with the purchase stock, and the limiting material.
Average duration of orders, per produced item.
Value of consumed materials and unit cost price.
Share of the material cost lost in defective units.
Actual consumption of hand-entered orders, compared with the bill of materials.
| Indicator | Calculation | Display |
|---|---|---|
| Production capacity | Minimum, over the materials of the bill of materials, of (purchase stock ÷ quantity for 1 unit), rounded down to the unit. | Per item: producible units and limiting material. Counters "Items with a bill of materials" and "Impossible to produce" (0 in red). |
| Average manufacturing lead time | End date − start date, in days (same day = 0 d). | Average lead time, number of orders, and the 10 items with the longest lead times. |
| Material cost of production | Σ consumed quantity × material unit price. Unit cost price = cost ÷ intact quantity. | Material cost and unit cost price, per month. |
| Scrap cost | Material cost × defective ÷ (intact + defective). | Scrap cost and share of the material cost, per month. |
| Variance from bill of materials | (Actual − expected) ÷ expected, with expected = bill of materials quantity × (intact + defective). | Overall variance, orders analysed, and the 10 largest variances per material (actual, expected, variance). |
Capacity example. Plain yogurt 500ml, bill of materials: milk 0.500 L, cultures 0.010 g, pot 1. Purchase stock: 1,200 L, 15 g, 600 pots → 2,400, 1,500 and 600 possible units. Capacity = 600, limiting material = the pot.
Which price for the cost?
The material price is recorded on the order row at manufacturing time. For orders saved before this change, the dashboard uses the current price of the purchase stock.
Which orders are compared?
The variance only covers traditional orders (components entered by hand) whose item has a bill of materials: an order from bill of materials consumes the expected quantity by design. A material consumed outside the bill of materials counts with an expected quantity of 0.
Block absent in simple stock mode or without the Manufacturing Orders option.
Simple vs advanced mode
The dashboard adapts to your company's management mode. In simple mode, cards and charts related to batches / expiry are hidden; in advanced mode, they appear.
- Value, quantity, references
- Shortage & below threshold
- No expiry alerts
- Everything in simple mode
- Expiry alerts & expiry buckets
- Batch tracking
Calculation rules
References — counted distinctly between sales and purchasing items (the same quantity is not counted twice).
Shortage / below threshold — determined stock line by stock line, based on the quantity and the minimum alert threshold defined on the item.
Defective returns — valued at the item's ex-works price.
Expiry — buckets: expired, ≤ 2 days (urgent), 3-5 days (near). Reserved for advanced stock.
FAQ & Tips
Expiry alerts aren't showing?
Your company is on simple stock. Expiry dates are only tracked in advanced management (by batch / expiry).
A reference in shortage is still visible for sale?
The shortage KPI reflects the zero quantity; the check at delivery time depends on the Stock module's configuration.
Tip — procurement routine
Filter weekly on shortage + below threshold to build your replenishment list, and clear batches nearing expiry first.