Pharma ERP & Accounting System
An end-to-end ERP solution built for pharmaceutical distributors to manage purchases, sales, inventory, and financials.
This project is a comprehensive desktop-based ERP and accounting system tailored specifically for medicine distribution businesses. Designed for speed, reliability, and offline access, this ERP enables pharmaceutical wholesalers to run their operations with greater control, compliance, and accuracy.
Key modules includes:
✅ Purchase Management
🔹Record purchase invoices from multiple suppliers.
🔹Support for batch number, expiry dates, and MRP-based pricing.
🔹Real-time update to stock levels on product purchase.
🔹Manage purchase returns and credit notes.
✅ Sales Management
🔹Create sales invoices for retail or wholesale clients.
🔹Integrated stock validation — cannot sell expired or out-of-stock items.
🔹Tracks discounts, tax, and profit margins.
🔹Generate sales return and customer credit/debit adjustments.
✅ Stock & Inventory Control
🔹Track stock at product + batch + expiry level.
🔹Auto-alert for low stock and near-expiry items.
🔹FIFO (First-In-First-Out) or batch-priority sales handling.
🔹Central product master with code support.
✅ Accounts & Ledger
🔹Fully integrated double-entry accounting system.
🔹Create and manage ledgers, vouchers, payment entries, cash books, and bank books.
🔹View account statements, trial balance, P&L, and balance sheet.
🔹Link financial transactions to sales/purchase modules automatically.
✅ Reports & Analytics
🔹Sales/Purchase summary by date range or customer/supplier.
🔹Expiry/batch tracking reports.
🔹Daily cash flow and ledger printouts.
🔹Stock valuation and audit trail.
Challenges
✅ Managing Batch-Wise Stock with Expiry and Sale Restrictions
🔹Pharmaceutical businesses must track each product by batch and ensure expired medicines are never sold, even if their quantity exists in stock. Implementing this while allowing FIFO-based sales was a key challenge.
Solutions
✅ Reliable inventory and compliance with health regulations.
🔹Designed a batch-wise stock model where each stock entry is recorded with ProductID, BatchNo, ExpiryDate, and Qty.
🔹The sales module checks expiry and applies FIFO logic to select valid batches.
🔹Built auto-deduction logic to update batch-wise stock after every sale or return.
Technologies
Links
Project Gallery
