📦 VGP Inventory — Management Dashboard
Diabetic Supplies · live from the VGP Inventory sheet (via backend mirror)
loading…
Loading KPIs…
🩺 Stock Health
📊 VGP Overview
🔴 Records & Alerts
🔍 VGP Products
🚚 Movements
🗂️ Category & Supplier
📦 UMS Inventory
⏳ Expiry Risk (money at risk)
🏥 Top Pharmacies (by movement $)
🏆 Top Products Sold
(units sold across all orders · from Orders)
📈 Trends
🔴 Reorder Alerts
Ranked by sell-through velocity ⚡ — fast-movers that are out/low first.
⏱️ Days of Cover
In-stock SKUs by how soon they run out at current sell-through.
≤14d
/
≤30d
flagged.
🔍 Product Inventory
All Categories
All Status
OK
Low
Out
⬇ Export CSV
SKU
Product
Category
Type
On Hand
Reorder Lvl
Unit Cost
Value
Status
🚚 Recent Movements (Stock In / Out)
All movements (In + Out)
⬇️ Stock In only
⬆️ Stock Out only
Date
SKU
Product
Type
Qty
Client / Pharmacy
Line Total
🗂️ Inventory by Category
🏭 Value by Supplier
⚠️
UMS Inventory
— Data sourced from the UMS Inventory sheet. Kept
fully separate
from VGP inventory records.
📦 UMS Stock Summary
#
Product Name
VGP Name
Total Mint
Stock Overall
Status
🚚 UMS Movements
(IN from Purchasing · OUT from Order Scan · Returns)
All Types
⬆️ IN (Purchased)
⬇️ OUT (Dispatched)
🔄 Returns
#
Date
Product
Type
Qty
Customer / Supplier
Price