Find a patient by name, phone or MR number…
DHA Phase 5, Lahore DHA Phase 5
Dashboard/Inventory

Inventory & Stores

Store: Main Pharmacy — DHA Phase 5 · 1,284 items · 3,912 batches

Draft PO (8 items) New GRN
Stock value (cost)
Rs 4.82 M
Weighted average cost · retail value Rs 5.71 M
Expiring ≤ 90 days
37 batches
Rs 112,400 · 14 within 30 days
Below reorder level
8 items
3 out of stock
Dead stock (no sale 120d)
22 items
Rs 46,300 tied up
Status: In stockStore: Main Pharmacy
Export
ItemGenericCompanyPackOn handReorder lvlAvg costMRPStatus
Augmentin 625 mg tabAmoxicillin + ClavulanateGSK6 tabs / strip166 tabs12068.4079.00OK
Panadol 500 mg tabParacetamolGSK200 tabs / box1,840 tabs6003.104.00OK
Norvasc 5 mg tabAmlodipinePfizer10 tabs / strip20 tabs10021.8025.00Low
Glucophage 500 mg tabMetforminMerck50 tabs / box640 tabs3005.206.10OK
Lantus SoloStar pen FridgeInsulin glargineSanofi1 pen3 pens102,9503,420Low
Xanax 0.5 mg tab ControlledAlprazolamPfizer30 tabs / box90 tabs308.9010.50OK
Disposable syringe 5 cc—BD100 / box2,30050011.0015.00OK
CBC reagent (Diluent 20 L)Lab reagentSysmex1 can1218,500—Low
Suggested order is based on usage over the last 30 days

Lead time is 2 days. Each order covers 21 days of stock. Select items and convert to a purchase order.

SelectItemOn handAvg / dayDays coverSuggested qtyPreferred supplier
Norvasc 5 mg tab20141.4300 (30 strips)Muller & Phipps
Lantus SoloStar pen30.83.715IBL Healthcare
Risek 40 mg cap0220490 (35 strips)Getz Pharma (direct)
CBC reagent (Diluent 20 L)10.1102Sysmex Pakistan
≤ 30 days · 1431–60 days · 1161–90 days · 12Expired · 3
Create supplier return
ItemBatchExpiryDays leftQtyValue (cost)SupplierAction
Augmentin 625 mg tabAG3902Sep 2026Expired18 tabs1,231IBL HealthcareBlocked for sale
Brufen syrup 120 mlBR2231Oct 202618 days14 btl2,520Muller & PhippsReturn
Calpol syrup 90 mlCP0412Nov 202627 days22 btl3,080Muller & PhippsPush FEFO
Ventolin inhalerVN8812Dec 202652 days94,230IBL HealthcareTransfer to Gulberg
Augmentin 625 mg tabAG4471Jan 202780 days46 tabs3,146IBL HealthcareFEFO next
No expired stock on sale shelves

The 3 expired batches are blocked for sale and sit in quarantine until they go back to the supplier. POS refuses to sell any batch past its expiry.

Create supplier return (3)
Requisition → Issue → Receive. Stock moves only when the receiving store confirms.+ New transfer
RefFromToItemsRequested byDateStatus
TR-26-0311Main Pharmacy — DHAPharmacy — GulbergVentolin inhaler ×9, Brufen syrup ×6Zeeshan (Gulberg)13 OctIn transit
TR-26-0310Main Pharmacy — DHAProcedure Room — DHASyringes ×100, Gauze ×20, Lignocaine ×10Staff nurse Rubina12 OctReceived
TR-26-0309Pharmacy — GulbergMain Pharmacy — DHALantus SoloStar ×4Noman Ali12 OctAwaiting issue
Session
SC-26-10 · Rack A–D (Antibiotics)
Started 13 Oct 8:00 am by Noman Ali
Progress
118 of 184 items counted
Variance so far
− Rs 2,140 (6 items)
Adjustment needs manager approval
ItemBatchSystemCountedVarianceReason
Augmentin 625 mg tabAG4471460—
Velosef 500 mg capVL118064−4
Flagyl 400 mg tabFG3302300+10