31
Store & Deliver

GxP Warehouse, Expiry & FEFO Allocation

Distribution center → warehouse → zone → aisle → rack → bin, with every lot held in a controlled GxP state until QC and QA clear it for sale.

Inventory value
EGP 349.7M
Released stock
EGP 92.0M
Quarantine
14 lots
Near expiry (120 d)
EGP 71.6M
Blocked / hold
0 lots

Stock lot register

BatchProductWarehouseBinQtyExpiryDays leftValueState
B-782Losartan 1 g SachetMain DCD-24-6-6133.9K2027-07-20336EGP 2.8MQuarantine
B-785Diclofenac 40 mg CapsulesFactory 1 FG StoreC-4-4-1178.7K2026-11-30104EGP 18.5MNear Expiry
B-788Salbutamol 10 mg/5 ml SachetCairo DCC-4-7-2177.5K2027-02-16182EGP 18.6MReleased
B-791Insulin Glargine 1 g Oral SuspensionMain DCB-9-3-376.2K2027-06-23309EGP 4.6MQuarantine
B-794Salbutamol 1 g CapsulesCairo DCD-21-2-340.5K2027-07-10326EGP 2.4MQC Testing
B-797Omeprazole 20 mg InjectionCairo DCD-9-6-523.6K2027-10-31439EGP 968KReleased
B-800Atorvastatin 500 mg CreamFactory 1 FG StoreB-17-6-1107.2K2027-08-16363EGP 4.3MReleased
B-803Amoxicillin 500 mg SachetCairo DCB-11-3-4113.1K2027-02-06172EGP 9.7MQuarantine
B-806Diclofenac 1 g Oral SuspensionFactory 1 FG StoreC-9-3-590.1K2027-09-20398EGP 4.4MQuarantine
B-809Ceftriaxone 40 mg Eye DropsCairo DCC-7-1-655.7K2028-04-25616EGP 6.1MQuarantine
B-812Ceftriaxone 1 g TabletsMain DCD-2-8-242.4K2028-05-19640EGP 4.3MQuarantine
B-815Atorvastatin 250 mg SachetMain DCB-22-1-6203.0K2027-05-23278EGP 6.4MQuarantine
B-818Metformin 1 g Oral SuspensionCairo DCA-5-4-5126.6K2026-09-0316EGP 6.1MNear Expiry
B-821Salbutamol 10 mg/5 ml SachetCairo DCA-19-7-3134.5K2027-01-20155EGP 14.1MReleased
B-824Salbutamol 10 mg/5 ml SachetFactory 1 FG StoreD-24-6-621.6K2028-04-22613EGP 2.2MQC Testing
B-827Diclofenac 500 mg CreamCairo DCD-12-1-357.8K2026-10-1255EGP 3.3MNear Expiry
B-830Insulin Glargine 10 mg/5 ml SachetFactory 1 FG StoreC-21-2-4169.4K2027-10-06414EGP 5.4MSampling
B-833Losartan 1 g CapsulesFactory 1 FG StoreA-15-4-3218.9K2027-03-25219EGP 21.6MQuarantine
B-836Diclofenac 20 mg TabletsFactory 1 FG StoreC-17-8-4106.5K2028-06-22674EGP 6.5MReleased
B-839Diclofenac 1 g Oral SuspensionMain DCA-2-8-3186.5K2028-05-27648EGP 9.2MSampling
B-842Diclofenac 20 mg CreamFactory 1 FG StoreC-22-4-3206.7K2027-01-23158EGP 2.2MQC Testing
B-845Amoxicillin 500 mg SachetCairo DCB-6-5-2208.7K2027-03-02196EGP 17.8MQuarantine
B-848Metformin 10 mg/5 ml Eye DropsCairo DCB-4-4-3128.7K2027-06-26312EGP 2.0MQuarantine
B-851Metformin 20 mg TabletsAlexandria DCA-4-6-285.6K2027-04-05230EGP 7.8MQuarantine

FEFO allocation engine

Allocation picks first-expired-first-out, then filters by customer minimum shelf-life requirement, batch status (released only), recall/hold flags, warehouse and route. Lots below a customer's shelf-life rule are re-routed to channels that accept them instead of being written off.

  • B-785Diclofenac 40 mg Capsules
    178.7K packs · 104 days shelf life · Factory 1 FG Store · EGP 18.5M at risk
  • B-818Metformin 1 g Oral Suspension
    126.6K packs · 16 days shelf life · Cairo DC · EGP 6.1M at risk
  • B-827Diclofenac 500 mg Cream
    57.8K packs · 55 days shelf life · Cairo DC · EGP 3.3M at risk
  • B-884Ceftriaxone 1 g Tablets
    174.8K packs · 50 days shelf life · Cairo DC · EGP 17.7M at risk
  • B-785Ceftriaxone 1 g Cream
    117.7K packs · 116 days shelf life · Main DC · EGP 13.4M at risk

Records & transactions

Goods receipt (GRN) · Stock movement · Cycle count

No records posted in this module yet. Use “New record” to create one — it is saved to the shared database with an audit entry, recomputed into the KPIs and alarms, and fed to the AI agents as live context.