FR ENAR
User Manual Analytics · Stock Version 1.0 · Stable

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).

6
KPI scoreboard
3
Alert types
2
Management modes
TND
Valuation
1

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.

2

Access and navigation

Side menu: Stock and Manufacturing (or Stocks without the Manufacturing Orders option) → Stock Dashboard.

Swifto ERP — Stock menu
Global dashboard
Stock and Manufacturing
Stock Dashboard
Stocks
Inventory of stocks
Transfer notes
Manufacturing Orders
Settings
Bill of materials
Production Managers
Stock movements
Purchases
Need help? Click here...
The stock dashboard loads on the right.
3

Stock scoreboard

Six KPIs: stock value, total quantity, active references, items in shortage, below threshold and batches nearing expiry.

Stock › Stock dashboard
Stock value
486,300TND
Total quantity
12,480
Active references
642
In shortage
7
Below threshold
14
Nearing expiry
9
IndicatorMeaning
Stock valueTotal valuation (at cost or at selling price, depending on the chart).
Total quantitySum of the quantities in stock across all references.
Active referencesNumber of distinct references (sales + purchasing) present in stock.
In shortageReferences at zero quantity (to be replenished urgently).
Below thresholdReferences that have dropped below their minimum alert threshold.
Nearing expiryBatches whose expiry date is approaching (advanced stock).
4

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.

5

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.

Monthly stock flow: inflows and outflowsRotation

A month where outflows > inflows repeatedly signals upcoming strain: adjust your procurement.

6

Stock status (donut)

The "Stock status" donut splits references into three groups: available, below threshold and shortage — the quickest read of overall availability.

Stock status (availability)
Available — quantity above the threshold.
Below threshold — to monitor / reorder.
Shortage — zero quantity, immediate action.
7

Value & production

Two complementary analyses: purchase vs sale value (tied-up cost vs market valuation) and production yield: intact vs defective.

Purchase vs sale value
Production: intact vs defective

Other available charts

ChartReading
Movements by typeProcurement, sale, clearance, stocktake, transfer, return note…
Value by location / categoryWhere the tied-up value is concentrated.
Top items by quantityMost-stocked items.
Expiry bucketsExpired, expires ≤ 2 days, expires 3-5 days (advanced stock).
8

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.

Production capacity

Units still producible with the purchase stock, and the limiting material.

Average manufacturing lead time

Average duration of orders, per produced item.

Material cost of production

Value of consumed materials and unit cost price.

Scrap cost

Share of the material cost lost in defective units.

Variance from bill of materials

Actual consumption of hand-entered orders, compared with the bill of materials.

IndicatorCalculationDisplay
Production capacityMinimum, 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 timeEnd 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 costMaterial 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.

9

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.

Simple mode
  • Value, quantity, references
  • Shortage & below threshold
  • No expiry alerts
Advanced mode (batch / expiry)
  • Everything in simple mode
  • Expiry alerts & expiry buckets
  • Batch tracking
10

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.

11

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.

Swifto

Swifto ERP · Dashboards · User Manual v1.0

Stock dashboard — Overview · Home