Stock Master

Inventory

AM
Inventory value (landed)MVR 134,027.70
Low stock5below minimum
needs reorder
Out of stock1SKU at zero
Dead stock64½+ weeks of cover

Warehouse capacity

Branches →
Malé Central WH78% full · MVR 82,082.20
Hulhumalé Store54% full · MVR 33,258.60
Addu Depot31% full · MVR 18,686.90

Expiring soon

1 SKU
🌹
Red Roses (stem)80 stem on hand · 7-day shelf life
7d

Perishables are FEFO-picked (first-expiry, first-out). Roses turn over in under a week at current velocity — the risk is over-ordering ahead of quiet weekends.

Stock levels

ProductOn handReservedIncomingAvailableMin → maxValue
🌹
Red Roses (stem)FLR-ROSE-R
80 24 +200 56
100 / 400 · below min
MVR 880.00
🏺
Glass Vase MediumVAS-GLS-M
12 2 +40 10
15 / 400 · below min
MVR 1,284.00
🎁
Gift Box LargeGFT-BOX-L
25 +60 25
30 / 400 · below min
MVR 682.50
🎀
Satin Ribbon Roll 25mRBN-SAT-25
6 +20 6
10 / 400 · below min
MVR 214.80
🫖
Electric Kettle 1.7LELC-KTL-17
44 44
12 / 400
MVR 11,484.00
🌀
Stand Fan 16"ELC-FAN-16
27 27
10 / 400
MVR 12,881.70
📄
A4 Paper 80gsm (ream)STA-A4-80
177 177
60 / 400
MVR 13,363.50
🖊️
Ballpoint Pen (box 50)STA-PEN-BL
54 54
20 / 400
MVR 6,091.20
🐟
Canned Tuna 185g (ctn)FSH-TUN-CN
81 81
30 / 400
MVR 26,244.00
💧
Mineral Water 500ml (case)BEV-WTR-500
330 330
120 / 400
MVR 27,951.00
🧴
Detergent 5LCLN-DET-5L
6 6
18 / 400 · below min
MVR 717.60
🧱
Building Blocks 120pcTOY-BLK-120
35 35
12 / 400
MVR 7,280.00
🧿
Oud Perfume 50mlPRF-OUD-50
23 23
8 / 400
MVR 9,600.20
🛠️
Cordless Drill 18VHRD-DRL-18V
14 14
6 / 400
MVR 12,233.20
🪴
Ceramic Plant PotGRD-POT-CER
48 48
15 / 400
MVR 3,120.00
🔋
AA Batteries (24pk)BAT-AA-24
0 +100 0
24 / 400 · below min
MVR 0.00

Low stock — reorder now

AI purchasing →
ProductAvailMinSuggestedSupplier · lead
🌹 Red Roses (stem)critical 56 100 320 🇹🇭 Bangkok · 5d
🏺 Glass Vase Mediumhigh 10 15 40 🇱🇰 Colombo · 9d
🎁 Gift Box Large 25 30 35 🇱🇰 Colombo · 9d
🎀 Satin Ribbon Roll 25mnormal 6 10 20 🇱🇰 Colombo · 9d
🧴 Detergent 5Lhigh 6 18 60 🇨🇳 Guangzhou · 24d

Out of stock — incoming

1 SKU
🔋
AA Batteries (24pk) Backorder open (SO-2026-0127) · 🇮🇳 Mumbai Stationers · lead 12 days
+100 inbound · ETA Jul 24, 2026

The shipment is confirmed against PO-0561 (raised Jul 12). Chase the forwarder rather than double-ordering — the AI reorder screen flags exactly this.

Dead stock

6 SKU
🫖
Electric Kettle 1.7L44 pcs held · 9/wk → 4.9 weeks of cover
Reprice →
🌀
Stand Fan 16"27 pcs held · 6/wk → 4.5 weeks of cover
Reprice →
🖊️
Ballpoint Pen (box 50)54 box held · 12/wk → 4.5 weeks of cover
Reprice →
🧱
Building Blocks 120pc35 pcs held · 7/wk → 5.0 weeks of cover
Reprice →
🧿
Oud Perfume 50ml23 pcs held · 5/wk → 4.6 weeks of cover
Reprice →
🪴
Ceramic Plant Pot48 pcs held · 10/wk → 4.8 weeks of cover
Reprice →

Stock transfers

RefDateRouteProductQtyReason
TR-00922026-07-14 Malé → Addu 💧 Mineral Water 500ml (case) 40Replenishment
TR-00912026-07-11 Malé → Hulhumalé 🫖 Electric Kettle 1.7L 6Customer order
TR-00902026-07-08 Hulhumalé → Malé 🏺 Glass Vase Medium 3Rebalance

Stock count (cycle count)

Enter what was physically counted — the sheet starts at system quantity. Variances post as adjustments with their landed-cost value impact.

ProductExpectedCountedVariance

Movement history

Receipts · sales · transfers · adjustments
WhenTypeRefDetailWarehouseQty
Jul 16 · 14:20 Sale INV-2026-0296 POS — Ballpoint Pen box ×1, A4 ream Malé Central WH −1.5
Jul 15 · 09:05 Receipt GRN-0089 Bangkok Flora — Red Roses ×200 Malé Central WH +200
Jul 14 · 16:40 Transfer TR-0092 Mineral Water ×40 → Addu Depot Malé Central WH −40
Jul 14 · 16:40 Transfer TR-0092 Mineral Water ×40 received from Malé Addu Depot +40
Jul 12 · 11:12 Sale INV-2026-0295 Mineral Water case ×4 — staff price Malé Central WH −4
Jul 11 · 10:30 Receipt GRN-0088 CTH Lanka consolidated — 4 lines Malé Central WH +126
Jul 09 · 15:00 Adjustment ADJ-0008 Cycle count — Glass Vase (1 broken, written off) Hulhumalé Store −1
Jul 08 · 13:25 Transfer TR-0090 Glass Vase ×3 → Malé Central Hulhumalé Store −3
Jul 05 · 17:44 Sale SO-2026-0126 Detergent 5L ×24 + A4 ×50 — Coral Reef Resort Malé Central WH −74
Jul 01 · 08:15 Adjustment ADJ-0007 Opening stock correction — Addu Depot Addu Depot +9