Project Name
Replaced a Legacy Marg ERP Setup with ERPNext v16 for a Multi-Branch Pharmaceutical Distributor
Our client is a pharmaceutical distribution company operating across Uttar Pradesh and Bihar, with purchasing, inventory, and billing managed on Marg ERP for years. As the business expanded, it needed centralized HQ visibility, automated customer communication, built-in drug-licence and credit controls, and proactive alerts for expiring and slow-moving stock, capabilities its desktop-based system could not provide.
Ksolves, an AI-first ERPNext partner, migrated the business to ERPNext v16 through a phased rollout covering procurement, inventory, multi-branch billing, CRM, and finance.
The client needed a platform that replaced Marg ERP's per-branch operation with consolidated visibility and system-enforced governance as the business scaled.
- Branch-Siloed Reporting Under Marg ERP: Inventory, sales, and outstanding dues across the Uttar Pradesh and Bihar branches had to be assembled manually for any HQ-level view, with no consolidated reporting layer.
- No System-Enforced Vendor Rate Governance: Purchase rates could drift from the standard cost-plus formula without a system check, with no structured approval gate when a vendor's actual rate exceeded the agreed formula.
- Manual Customer Communication: Invoice sharing, payment reminders, and quotation follow-ups depended on manual outreach rather than automated triggers.
- No Enforced Credit or Drug-Licence Controls: Category-wise credit limits (Retail vs. Wholesale) and drug-licence validity tracking per party needed system enforcement rather than manual checking.
- Reactive Expiry and Stock-Health Management: With pharma inventory subject to expiry, the business needed proactive flags for near-expiry stock, slow-moving items, and stagnant inventory rather than discovering these issues after the fact.
- Dual Entry Risk During the Transition: The finance team needed to keep Tally current for accounting continuity while operating day-to-day on the new platform, without manually re-entering every transaction twice.
Ksolves, an AI-first ERPNext implementation partner, delivered the engagement as a phased build across Procurement, Inventory & Expiry Management, Multi-Branch Billing, CRM & Sales, and Finance & Admin, moving the business off Marg ERP onto ERPNext v16.
- Multi-Branch Warehouse Structure With Consolidated HQ Reporting: A Main Warehouse-to-branch hierarchy was configured across Uttar Pradesh and Bihar, with branch-wise inventory and party visibility rolling up into consolidated HQ-level reporting.
- Vendor Rate Governance and Quality Gates: Purchase Orders and Receipts now run through a mandatory Quality Inspection step before stocking, with a Purchase + 15% margin formula auto-calculating pricing and routing any rate that exceeds the formula to Admin approval.
- Batch and Lot Traceability From Purchase to Dispatch: Batch-wise stock tracking with manufacture date, expiry date, and vendor source now carries through from purchase receipt to customer invoice.
- Automated Expiry and Stock-Health Alerts: Dashboards flag items expiring within 120 days, items with no sale in 90 days, and near-zero "dummy stock," all configurable per branch.
- WhatsApp and Email Automation on Billing: WATI/Interakt-based automation now triggers on invoice creation, payment reminders, and quotation/proforma non-conversion follow-ups.
- Category-Wise Credit Limits and Drug-Licence Tracking: The Party Master was enhanced with separate Retail vs. Wholesale credit configurations and drug-licence validity tracking with expiry alerts.
- Tally Live Sync for Accounting Continuity: Sales Invoices, Purchase Invoices, Payments, and Journal Entries now push to Tally in real time via XML API, eliminating manual dual entry during the transition.
- Admin Approval Workflows and Security Controls: New Product and Party Master entries route to Admin for approval before activation, with IP whitelisting and OTP-protected (2FA) backups configured on Frappe Cloud.
Technology Stack
| Category | Technology |
|---|---|
| Platform | ERPNext v16 on Frappe Framework |
| Hosting | Frappe Cloud Dedicated (AWS) |
| Database | MariaDB / MySQL |
| Analytics | Frappe Insights (custom dashboards) |
| Communication | WhatsApp/Email Automation via WATI / Interakt |
| Accounting Continuity | Tally Live Sync (XML API) |
A unified ERPNext v16 platform now replaces Marg ERP's per-branch operation with consolidated visibility and built-in governance.
- Consolidated Visibility Across Branches: Outstanding dues, expiry stock, and sales performance across Uttar Pradesh and Bihar are now visible from a single HQ dashboard instead of being assembled branch by branch as they were under Marg ERP.
- Traceability From Vendor to Customer: Every batch is now traceable from purchase receipt through dispatch, replacing tracking that previously depended on the desktop system's per-branch records.
- Customer Communication No Longer Manual: Invoice, payment reminder, and quotation follow-up notifications now trigger automatically via WhatsApp and email.
- Accounting Continuity Without Dual Entry: Tally Live Sync keeps the finance team's existing Tally records current in real time, removing the need for parallel manual entry during the migration.
- Governance Built Into Daily Operations: Vendor rate approval, credit limits, and drug-licence validity are now system-enforced rather than manually tracked.
Moving off a mature desktop ERP looks different when the business has outgrown single-branch operation. Rather than a like-for-like replacement of Marg ERP, Ksolves used the migration to build in the governance the business needed as it scaled across Uttar Pradesh and Bihar: vendor rate approval, credit and drug-licence controls, and batch traceability from vendor to customer. The distributor now runs procurement, inventory, billing, and customer communication on one connected platform, with Tally continuity maintained rather than abandoned outright.
Still Running Branch Operations on a Desktop ERP?
