Little Medical ERP System
Budget: $250 – $750 USD
I'm looking to develop a little ERP system specifically for the medical field. This system should not only handle core ERP functions like inventory management, customer relationship management, and accounting, but also include specific modules tailored for medical services.
Key Components:
- Core ERP functionalities: The system needs to manage inventory, customer relationships, and finances effectively.
- Medical-specific modules: The system should include patient management and electronic health records (EHR).
? Table Structure (Suggested for Access Backend)
? Patients
PatientID (AutoNumber, Primary Key)
FirstName
LastName
DateOfBirth
Gender
PhoneNumber
Email
Address (Street, ZIP, City)
InsuranceNumber (etc.)
? Vital Signs
VitalID (AutoNumber)
PatientID (Foreign Key)
Date
BloodPressureSystolic
BloodPressureDiastolic
Pulse
OxygenSaturation
Notes
? Treatments / Therapy Progress
TreatmentID
PatientID
Date
Description
TypeOfTherapy
Therapist
? Progress Reports
ReportID
PatientID
Date
FreeTextReport
Assessment (e.g. Progress Scale)
? Invoices
InvoiceID
PatientID
Date
TotalAmount
AmountPaid
Status (Open, Paid, Partially Paid)
PDFPath (for export)
? Receipts
ReceiptID
InvoiceID (Foreign Key)
Date
Amount
? Functional Modules (Access Forms + VBA Logic)
? Patient Management
Search / Filter (by name, birthdate, ID)
View and edit patient data
Add new patients
Delete with confirmation prompt
? Vital Signs
Entry form with date picker
History table + trend graphs (e.g. using MSChart or Excel integration)
Filter by time ranges
? Treatments & Therapy
Chronological history of treatments
Selectable therapy types (dropdown list)
Documentation of responsible therapists
? Progress Reports
Report entry form
Free text + standardized rating (e.g. scale from 1–10)
? Invoice Module
Create invoices based on completed treatments
Export to PDF (e.g. via Access report to PDF)
Generate receipts
Manage open / paid invoices
View payment history per patient
? Reports & Analysis
Patient list with filter options
Revenue analysis (monthly, quarterly, etc.)
Vital sign trends
Invoice overview (open, paid, overdue)
Multi-user and multi language possibility is a need. Can run as poor Access database or web Application.
Ideal candidates for this project should have significant experience in developing ERP systems, particularly in the medical field. Familiarity with EHR systems, patient management software, and the necessary regulatory considerations for healthcare software are highly desirable. Strong skills in software development, project management, and understanding of medical billing protocols will be key to delivering a successful project.
Key Components:
- Core ERP functionalities: The system needs to manage inventory, customer relationships, and finances effectively.
- Medical-specific modules: The system should include patient management and electronic health records (EHR).
? Table Structure (Suggested for Access Backend)
? Patients
PatientID (AutoNumber, Primary Key)
FirstName
LastName
DateOfBirth
Gender
PhoneNumber
Address (Street, ZIP, City)
InsuranceNumber (etc.)
? Vital Signs
VitalID (AutoNumber)
PatientID (Foreign Key)
Date
BloodPressureSystolic
BloodPressureDiastolic
Pulse
OxygenSaturation
Notes
? Treatments / Therapy Progress
TreatmentID
PatientID
Date
Description
TypeOfTherapy
Therapist
? Progress Reports
ReportID
PatientID
Date
FreeTextReport
Assessment (e.g. Progress Scale)
? Invoices
InvoiceID
PatientID
Date
TotalAmount
AmountPaid
Status (Open, Paid, Partially Paid)
PDFPath (for export)
? Receipts
ReceiptID
InvoiceID (Foreign Key)
Date
Amount
? Functional Modules (Access Forms + VBA Logic)
? Patient Management
Search / Filter (by name, birthdate, ID)
View and edit patient data
Add new patients
Delete with confirmation prompt
? Vital Signs
Entry form with date picker
History table + trend graphs (e.g. using MSChart or Excel integration)
Filter by time ranges
? Treatments & Therapy
Chronological history of treatments
Selectable therapy types (dropdown list)
Documentation of responsible therapists
? Progress Reports
Report entry form
Free text + standardized rating (e.g. scale from 1–10)
? Invoice Module
Create invoices based on completed treatments
Export to PDF (e.g. via Access report to PDF)
Generate receipts
Manage open / paid invoices
View payment history per patient
? Reports & Analysis
Patient list with filter options
Revenue analysis (monthly, quarterly, etc.)
Vital sign trends
Invoice overview (open, paid, overdue)
Multi-user and multi language possibility is a need. Can run as poor Access database or web Application.
Ideal candidates for this project should have significant experience in developing ERP systems, particularly in the medical field. Familiarity with EHR systems, patient management software, and the necessary regulatory considerations for healthcare software are highly desirable. Strong skills in software development, project management, and understanding of medical billing protocols will be key to delivering a successful project.