Over 27 years in the pharmaceutical manufacturing industry, I’ve watched generic drug manufacturers across Thailand rely on the same universal tool: Microsoft Excel.
This isn’t inherently wrong. Excel is flexible, familiar, and powerful. But as companies grow, SKU counts expand, export markets open up, and auditors begin scrutinizing data integrity — Excel quietly transforms from a strength into a liability.
Patterns I’ve Seen Repeatedly in Thai Pharma SMEs
1. Fragmented batch records
The BMR lives in Word, QC results are in a separate Excel file, and the physical production log is buried in a binder. When an auditor asks "Which raw material lot was used in this batch?" — expect hours of searching.
2. No real-time inventory visibility
"How much Atorvastatin API do we have right now?" The honest answer is often: "Let me check with the warehouse."
3. Traceability is manual and person-dependent
GMP requires full traceability: which raw material lot, which production date, shipped to which customer. With Excel, this is possible — but only if the person who built the spreadsheet is still around.
4. No meaningful version control
"QC_result_final_v3_REVISED_USE_THIS_ONE.xlsx" — sounds familiar?
5. Data integrity risk
ALCOA+ (Attributable, Legible, Contemporaneous, Original, Accurate) is the cornerstone of GMP data integrity. Excel files can be modified without leaving an audit trail — a serious red flag for regulators.
Can an ERP Actually Fix This?
Yes — with conditions.
A well-implemented ERP provides:
- Automatic audit trails on every transaction
- Real-time stock balances updated with every receipt, transfer, and production event
- Batch traceability in 3 clicks instead of 3 hours
- Document version control with clear history
The condition: The ERP must be implemented correctly and tailored to pharmaceutical workflows — not just an accounting system forced to handle drug manufacturing data.
Is It Time to Change? A Quick Self-Assessment
If you answer "yes" to more than 3 of these, the answer is yes:
- More than 20 SKUs (API + finished goods combined)
- You have or are pursuing export markets
- You’ve had GMP audit findings related to data integrity or traceability
- Audit preparation takes more than one business day
- A batch was once shipped past expiry date without prior detection
- Critical "system knowledge" lives only in one person’s head
Conclusion
Excel is not the enemy. It’s a calculation tool, not an enterprise operations platform for a regulated industry.
Generic pharmaceutical manufacturers who want to grow, export, or sustainably maintain GMP/ISO certification need a system purpose-built for this work.
In the next article, we’ll look at ERPNext — an open-source ERP gaining traction in pharma SMEs — and explore what it can and cannot do for a generic drug manufacturer out of the box.