Pharma Distribution · Dubai, United Arab Emirates
A GDP-ready pharma ERP for a Dubai distributor, live in 35 days
A MOHAP-licensed Dubai distributor with GDP-compliant warehousing, and inventory tracked across multiple disconnected Excel files.
The challenge
A licensed pharmaceutical distributor in Dubai, managing imports from European and Asian manufacturers, was tracking inventory across multiple Excel files with no real-time stock position. Customer invoices were generated manually. Batch numbers and expiry dates were recorded on paper.
The mismatch was the striking part. The business was MOHAP-licensed and operated GDP-compliant warehouse facilities. The physical infrastructure was genuinely to standard. The software processes running inside it were not. Any audit would have exposed significant gaps in digital traceability and batch record management, and any product recall would have been an extremely time-consuming manual exercise against paper records.
Excel does not fail loudly. It degrades. The point at which it stopped being sufficient for this operation had passed without an incident, and would have been discovered retrospectively: during an inspection, or during a recall.
What we deployed
PharmFlow, configured for UAE pharmaceutical distribution requirements including MOHAP documentation standards and Arabic-format reporting.
- Real-time inventory with batch and expiry tracking
- MOHAP-aligned GDP documentation
- Supplier purchase order management
- Customer ledger with outstanding balance view
- Automated invoice generation on dispatch
- 35+ reports including Arabic-format ledgers
- Multi-currency handling for European and Asian imports
- Full data migration from existing spreadsheets
Two things were specific to this market rather than generic pharma requirements.
Arabic and English at parity, including in printed documents, which is where most systems quietly fail. Arabic implemented as a translation layer over an English system gets rejected by users quickly and silently.
Landed cost across import documentation. Freight, insurance, customs, and clearing allocated across each shipment down to line level. The previous spreadsheet approach applied an average, which meant product-level margin was wrong in a way that systematically favoured the wrong products.
The result
Full deployment in 35 days, with 100% digital coverage from procurement through to delivery, and monthly reconciliation running three times faster than the spreadsheet process.
The change that mattered most to the Responsible Person was not on the metrics list. A recall scenario went from a fortnight of reconstructing records across multiple documents to a query that returns affected units and the customers holding them. Audit preparation stopped being a project.