AI Assistant
Expiry Risk Alert
High Risk Batches
16
Urgent
Expiring within 30 days
Near Expiry Items
42
Expiring within 90 days
Stock Value At Risk
Rs. 684k
Based on current stock value
Recoverable Value
Rs. 410k
Possible sale before expiry
Expiry Risk Filters
Analyze expiry risk by branch, warehouse, category, supplier and risk level.
Expiry Risk Forecast
Estimated stock value at risk by expiry window.
AI Risk Summary
Expiry observations and suggested actions.
Critical Expiry Items
Expired and very near expiry batches.
| Product | Batch | Expiry | Risk |
|---|---|---|---|
| Amoxicillin 250mg | B-AX221 | 12 Jun 2026 | Critical |
| CoughClear Syrup | B-CS104 | 18 Jun 2026 | Critical |
| Vitamin C Drops | B-VC887 | 25 Jun 2026 | High |
| Calcium Plus | B-CP332 | 30 Jun 2026 | High |
Recovery Opportunities
Stock that can still be sold or returned.
| Product | Qty | Value | Action |
|---|---|---|---|
| Cefixime 400mg | 180 | Rs. 73,800 | Priority sale |
| Brufen 400mg | 420 | Rs. 63,000 | Retail discount |
| Multivitamin Syrup | 260 | Rs. 58,500 | Supplier return |
| ORS Sachet | 900 | Rs. 45,000 | Fast dispatch |
AI Expiry Risk List
Batch-wise expiry risk, value exposure and suggested action.
| Risk | Product | Batch No | Category | Warehouse | Qty | Expiry Date | Stock Value | AI Action | Status |
|---|---|---|---|---|---|---|---|---|---|
| Critical | Amoxicillin 250mg | B-AX221 | Antibiotics | Main Warehouse | 240 | 12 Jun 2026 | Rs. 62,400 | Block sale / return supplier | Action Required |
| Critical | CoughClear Syrup | B-CS104 | Syrups | Dispatch Store | 180 | 18 Jun 2026 | Rs. 54,000 | Fast dispatch discount | Pending |
| High | Vitamin C Drops | B-VC887 | Vitamins | Main Warehouse | 320 | 25 Jun 2026 | Rs. 48,000 | Bundle with child care items | Suggested |
| High | Calcium Plus | B-CP332 | Vitamins | Cold Storage | 210 | 30 Jun 2026 | Rs. 44,100 | Offer to hospital customers | Suggested |
| Medium | Brufen 400mg | B-BR901 | Pain Relief | Main Warehouse | 420 | 15 Jul 2026 | Rs. 63,000 | Priority sale | Recoverable |