Stock Tracking
How inventory stock levels are calculated, alert thresholds, and budget monitoring.
- Stock formula: Current Stock = Total Delivered (approved) − Total Consumed ± Manual Adjustments
- Only approved deliveries count — pending and flagged are excluded
- Low stock alert at < 10% of planned quantity
- Over budget alert when total delivery cost > budgeted amount (rate × planned quantity)
- Consumed progress bar = usage ÷ planned quantity (percentage, not remaining stock)
- Stock updates immediately when deliveries are approved, usage is logged, or adjustments are made
Full Guide
The Stock Formula
Your material's stock level is computed automatically from three inputs:
Each of these updates in real time:
| Input | What Affects It | Direction |
|---|---|---|
| Total Delivered | Approved deliveries only | Increases stock |
| Total Consumed | Usage log entries | Decreases stock |
| Manual Adjustments | Stock adjustments (add or remove) | Either direction |
Why Only Approved Deliveries?
Pending deliveries haven't been verified yet — the quantity, spec, or vendor might be wrong. Flagged deliveries have known issues. Including them in your stock count would give you unreliable numbers.
When you approve a delivery, its quantity is added to stock immediately. If a delivery is later flagged (e.g., discovered a spec mismatch), the stock adjusts accordingly.
Budget Alerts
Two types of alerts appear automatically:
Low Stock
- Triggers when: current stock drops below 10% of your planned quantity
- What to do: check if new deliveries are scheduled, or place a new order
- Example: Planned quantity is 100 m³, current stock drops to 8 m³ → low stock alert
Over Budget
- Triggers when: total delivery costs exceed your budgeted amount
- Budgeted amount = unit rate × planned quantity
- What to do: review delivery costs, check if rates have increased, adjust budget if needed
- Example: Rate is ₹5,000/m³, planned 100 m³ = ₹5,00,000 budget. Delivery costs hit ₹5,20,000 → over budget
Understanding the Consumed Progress Bar
The Consumed column shows a progress bar with a percentage. This represents:
Consumed % = Total Consumed ÷ Planned Quantity × 100
This tells you how far you are through your planned material usage for the project — not how much stock remains.
If planned quantity is not set, the Consumed column shows the raw quantity consumed instead of a percentage.
| Consumed % | Status | Typical Action |
|---|---|---|
| 0–50% | Normal | On track |
| 50–80% | Watch | Verify remaining stock covers the plan |
| 80–100% | Attention | Low stock likely, check delivery schedule |
| >100% | Over plan | Usage exceeded the original estimate |
Stock History
Every change to stock is recorded with a full audit trail:
- Deliveries: Who approved, when, how much
- Usage logs: Who logged, when, quantity consumed, remarks
- Adjustments: Who adjusted, direction (add/remove), quantity, reason
These records are visible in the material's detail page under the respective tabs.
Related
- Usage Logging — How consumption is recorded
- Stock Adjustments — Manual corrections
- Adding Materials — Setting up budget rate and planned quantity