Module Deep-Dive: Pharmacy & Inventory

Complete FC walkthrough of Bio Ecko's pharmacy dispensing, inventory management, stock control, and drug-master configuration.

February 2026 · 18 min

Manual area

FC Training Programme

Coverage

8 sections

Operator notes

3 implementation notes

Why Pharmacy Is a High-Stakes Module

Pharmacy is where clinical safety meets financial control. A medication error can harm patients; an inventory error can cause stock-outs or expiry waste. The FC must master both the clinical dispensing workflow and the supply-chain backend.

In a typical Indian hospital, pharmacy accounts for 30-40% of total revenue. Configuration accuracy here directly impacts patient safety, compliance with Drug & Cosmetics Act, and hospital profitability.

Drug Master Setup

The drug master is the foundational dataset. Every medication dispensed, ordered, or stocked must exist here:

Field	Purpose	FC Configuration Task
`generic_name`	WHO INN name (e.g., Paracetamol)	Standardize to INN naming convention
`brand_name`	Commercial name (e.g., Dolo-650)	Map brands to generics for substitution
`formulation`	Tablet, Syrup, Injection, Cream, etc.	Use standardized form codes
`strength`	500mg, 10mg/5ml, etc.	Ensure unit consistency across all entries
`schedule`	H, H1, X, G, J (Drug Schedule)	Critical for dispensing rules and audit
`route`	Oral, IV, IM, SC, Topical, etc.	Validates against order entry
`reorder_level`	Minimum stock before auto-alert	Set per item based on consumption pattern
`max_stock`	Upper limit to prevent over-ordering	Calculate based on shelf-life and consumption
`expiry_alert_days`	Days before expiry to trigger warning	Typically 90 days for near-expiry alerts
`storage_condition`	Room temp, Refrigerated, Controlled	Maps to physical storage zones

FC must import the hospital's formulary (typically 2,000-5,000 items) and validate each entry before go-live. Use the Drug Master Import Template (CSV) provided in Bio Ecko's admin settings.

Prescription to Dispensing Flow

The dispensing workflow in Bio Ecko:

Doctor Prescribes -- From OPD/IPD consultation screen, doctor selects drugs from formulary, enters dose, frequency, duration, and route. This creates entries in prescriptions table
Prescription Reaches Pharmacy -- Pharmacy counter sees new prescriptions in the pending queue, sorted by urgency (STAT first, then routine)
Pharmacist Reviews -- Checks for drug-drug interactions (DDI), allergy alerts, duplicate therapy. Bio Ecko flags alerts from the drug_interactions and patient_allergies tables
Stock Verification -- System checks inventory_items for available stock in the dispensing location. If out of stock, shows alternative brands with same generic
Dispensing -- Pharmacist picks, scans barcode (if barcode-enabled), confirms quantity, and dispenses. Stock is auto-deducted from inventory_items
Billing -- Dispensed medications are auto-posted to billing_items for the patient's encounter
Counselling -- For first-time medications, pharmacist provides usage instructions; recorded in dispensing_notes

The FC must validate the entire chain works -- especially the stock deduction accuracy and billing integration.

Inventory Management Lifecycle

Hospital pharmacy inventory follows this cycle:

Stage	Process	Bio Ecko Feature	FC Validation
Indent	Department raises request for stock	Indent Management	Verify approval workflow triggers
Purchase Order	Pharmacy/Store creates PO to vendor	PO Generation	Check auto-PO from reorder alerts
GRN (Goods Received)	Stock physically received, inspected	GRN Entry	Validate batch, expiry, quantity match PO
Stock Entry	Items added to inventory with batch tracking	Inventory Update	Confirm FIFO/FEFO sequencing
Dispensing/Issue	Stock issued to patient or department	Dispensing/Store Issue	Verify auto-deduction from correct batch
Stock Transfer	Move stock between pharmacy locations	Inter-Location Transfer	Test multi-pharmacy hospital setup
Return to Vendor	Expired/damaged stock returned	Return Note	Check credit note generation
Expiry Write-Off	Near-expiry stock written off	Expiry Management	Validate write-off approval chain
Physical Count	Periodic stock audit	Stock Audit Tool	Compare system vs physical, adjust variances

Key principle: Bio Ecko uses FEFO (First Expiry, First Out) by default. When dispensing, the system picks the batch with the nearest expiry date first. The FC must verify this logic during testing.

Controlled Substance & Schedule H1 Handling

Indian drug regulations require special handling for scheduled drugs:

Schedule H -- Prescription-only; must have valid prescription before dispensing. Bio Ecko blocks dispensing without linked prescription
Schedule H1 -- Stricter control (antibiotics, anti-TB, etc.); requires maintaining a separate register with patient name, doctor name, drug, quantity. Bio Ecko auto-generates the H1 Register report
Schedule X -- Narcotic/psychotropic substances; requires duplicate prescription, locked storage, daily consumption register. Bio Ecko tracks at individual unit level with audit trail
Schedule G -- Caution drugs; display "Caution: To be taken under medical supervision" on label

FC configuration checklist:

Each drug's schedule is correctly mapped in the drug master
Schedule H drugs block dispensing without prescription
H1 register auto-populates and is printable
Schedule X drugs require dual-authorization for dispensing
Controlled substance stock counts match physical vault count
Audit trail captures who dispensed, when, to whom, prescribed by whom

Multi-Location Pharmacy Setup

Large hospitals have multiple pharmacy counters:

Main Pharmacy -- Central store, receives from vendors, transfers to sub-stores
OPD Pharmacy -- Retail dispensing for outpatients
IPD Pharmacy -- Ward-based dispensing for inpatients, often 24x7
Emergency Pharmacy -- Small stock of critical drugs near the ER
OT Pharmacy -- Anesthesia drugs, surgical consumables

FC must configure:

Each location as a separate pharmacy_location with its own stock
Inter-location transfer workflows with approval
Location-specific reorder levels (ER keeps less volume but always has critical drugs)
Consolidated stock reports across all locations
User access control -- OPD pharmacist cannot dispense from IPD stock

Reports & Compliance

Essential pharmacy reports the FC must validate:

Daily Dispensing Register -- All dispensed items with patient, doctor, batch, quantity
Near-Expiry Report -- Items expiring within 30/60/90 days with current stock
Stock Movement Report -- GRN, issues, transfers, returns, adjustments by date range
Dead Stock Report -- Items with zero movement in last 90 days
ABC/VED Analysis -- Classify drugs by value (ABC) and criticality (VED) for procurement optimization
Drug Consumption Report -- Department-wise and doctor-wise consumption patterns
Purchase vs Consumption Variance -- Flag over-procurement or under-procurement
Schedule H1 Register -- Statutory register for regulatory inspection
Narcotic Register -- Opening balance, receipts, issues, closing balance for Schedule X drugs
Vendor Performance Report -- Delivery timeliness, quality rejection rate, price trends

Hands-On Exercise

Complete this exercise in the Bio Ecko demo environment:

Add a new drug to the drug master: Amoxicillin 500mg Capsule, Schedule H, reorder level 100, max stock 500
Create a GRN for 200 capsules from vendor "PharmaSupply Co", batch AX-2026-01, expiry Mar 2027, unit cost INR 5
Create an OPD visit, prescribe Amoxicillin 500mg TDS x 5 days (total 15 capsules)
Switch to Pharmacy role, see the prescription in pending queue
Dispense the medication, verify stock deducted from correct batch
Check that billing_items now shows the 15 capsules charged to the patient
Run the near-expiry report and verify the new batch does NOT appear (expiry > 90 days away)
Transfer 50 capsules from Main Pharmacy to Emergency Pharmacy
Verify stock split correctly across both locations

Document any discrepancy in stock counts or billing amounts as defect log entries.

Notes

Warning

Drug master data quality is paramount. A single drug with wrong strength (e.g., 50mg vs 500mg) can lead to a 10x dosing error. Always cross-verify imported drug data with the hospital's pharmacist before go-live.

Tip

During GRN entry, always validate that batch number and expiry date match the physical label on the medicine pack. Post-go-live GRN errors cascade into incorrect expiry alerts and FEFO failures.

Info

The FEFO (First Expiry First Out) logic can be overridden by the pharmacist during dispensing (e.g., patient returns with a specific batch). These overrides are logged for audit. Educate pharmacy staff that overrides should be exceptions, not the norm.