Medicines close to expiry will appear here.
| Medicine Name | Price | Expiry Date | Quantity | Box No. | Status | Actions |
|---|
No medicines found
Add your first medicine to get started
| Medicine | Unit Price | Qty | Total |
|---|
Cart is empty
Search and add medicines above
| # | Date & Time | Customer | Items | Total | Discount | Actions |
|---|
No sales found
Sales will appear here after your first transaction
pharmacies
Stores pharmacy profile, address, plan, and subscription dates.
users
Owner, admin, pharmacist, and cashier accounts with roles.
suppliers
Supplier companies, contacts, and phone numbers.
categories
Medicine categories such as antibiotic, syrup, and diabetic.
medicines
Main inventory data with SKU, price, quantity, box number, and expiry.
medicine_batches
Batch tracking for purchase price, received quantity, and batch expiry.
customers
Customer name, phone, gender, and address for invoices.
prescriptions
Doctor name, prescription code, patient, and uploaded image path.
sales
Invoice header with totals, discount, customer, and cashier reference.
sale_items
Each sold medicine row linked with invoice and medicine.
payments
Cash, card, due, and mobile banking payment records.
stock_adjustments
Damage, return, correction, and manual stock update history.
expiry_alerts
Generated alerts when expiry date is within 30 days or already passed.
activity_logs
Audit trail for important system actions.
| Pharmacy | Plan | Payment | Payment Status | Account Status | Action |
|---|
No pharmacies found
Registered pharmacies will appear here for admin review.
Subscription Plan
Current plan and renewal options