2. Warehouse Management System & Strict FEFO Control (WMS)
First-Expired First-Out allocation, expiry risk radar, box unpacking & physical audits2.1 Batch Lot Tracking & FEFO Auto-Deduction Engine
Zero Expiry WasteThe FEFO engine sequences batches by expiration date, strictly preventing checkout of newer lots while older viable batches exist. Database-level row locking via select_for_update() eliminates race conditions during multi-terminal checkouts.
- Lot-Level Auditing: Every stock lot maintains a unique batch number, manufacture date, expiry date, landed unit cost, and precise aisle/shelf location.
- Multi-Tier Unit Unpacking: Deconstruct master cartons and primary boxes into individual blister strips or pills in one click while automatically recalibrating unit cost and digital shelf inventory.
2.2 Expiry Radar, Deficit Tracking & AI Min/Max Limits
Predictive RadarExpiry Horizon Radar
Calculates capital at risk across near-expiry tiers with one-click clearance discounts (20%) or Return-to-Vendor (RTV) drafting.
Adaptive Reorder Point Engine
Evaluates rolling 30-day sales velocity to automatically recalculate reorder points and prevent out-of-stock deficits.
2.3 Wall-to-Wall Physical Audits & Variance Reconciliation
Stocktake Audit- Continuous Stocktake Sessions: Scan items via hardware barcode scanners and log counted quantities; the engine instantly computes volume and financial variances.
- Automated Variance Reconciliation: Automatically generates audited StockAdjustment logs upon manager approval, updating physical WMS and doctor digital shelves.