Inventory management system with drug interaction alert
- or -
Post a project like this3361
$$
- Posted:
- Proposals: 5
- Remote
- #665003
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 3 - 4 weeks
Hello
It is going to be a ms access built inventory management system with purchase orders, sales orders and drug interaction check at the point of sale.
Accounting section will also be included :- sonething that can track expenses,income generated, whether the company is making profit or losing.
Drugs moved in and out locally due to customers returns or expiration
Multiple selling prices
Point of sale
Reports generated should include:-
Daily, weekly, monthly. Quarterly and annual sales with quantity sold and profit made
Same applies to the purchases
Drug expiration 6 months alert
Debtors and creditors report
Being able to use my mobile phone to track what is going on in the store
In more details
Drugs details
Drug name- brand and generic name
Strength
Dosage- tablet, syrup etc
Batch number
Expiry dates diff batches
Cost price
Reorder level
Pack size - for those buying in bulk
Carton size- for those buying in bulk
Selling price - multiple selling prices, retail price, wholesale price etc.
Order /Sales
Order Id
Drug name and if there would be possible interactions it should give an alert and an alternative
Note please- I want it to be possible to disable the alert if I don't want it to function at all.
Order date
Selling price
Total
Print out receipt
Accept payment from any medium, credit cards, debit cards, cash etc
If a customer returns a drug/product and she wants her money back. How do we sort that out in the sales made and drug moved back on the shelf
If drugs expires how do we reconcile and withdraw the drugs
I want something like
Drugs Removed form
Drugs Returned form
Purchases
Purchases id
Purchases date
Drug name/product name
Cost price
Quantity
Total
Cancel order if not needed
Print out purchases if need be
Track outstanding payments to make
Patient and customer history
Patient id
Patient name
Sex
Date of birth
Address
Phone number
Complaints
Observation
Diagnosis etc
Supplier
Supplier id
Supplier name
Company
Address
Phone number
Supply history
Stock taking
To do a check of the physical count with what is on the system.
Employees
They will have different access levels and passwords and the access levels can be changed at anypoint if I wish
I want the backend on an sql server while the front should be ms access 2007
This is just to give you an idea of what I want
That's the summary I want done.
Thanks
It is going to be a ms access built inventory management system with purchase orders, sales orders and drug interaction check at the point of sale.
Accounting section will also be included :- sonething that can track expenses,income generated, whether the company is making profit or losing.
Drugs moved in and out locally due to customers returns or expiration
Multiple selling prices
Point of sale
Reports generated should include:-
Daily, weekly, monthly. Quarterly and annual sales with quantity sold and profit made
Same applies to the purchases
Drug expiration 6 months alert
Debtors and creditors report
Being able to use my mobile phone to track what is going on in the store
In more details
Drugs details
Drug name- brand and generic name
Strength
Dosage- tablet, syrup etc
Batch number
Expiry dates diff batches
Cost price
Reorder level
Pack size - for those buying in bulk
Carton size- for those buying in bulk
Selling price - multiple selling prices, retail price, wholesale price etc.
Order /Sales
Order Id
Drug name and if there would be possible interactions it should give an alert and an alternative
Note please- I want it to be possible to disable the alert if I don't want it to function at all.
Order date
Selling price
Total
Print out receipt
Accept payment from any medium, credit cards, debit cards, cash etc
If a customer returns a drug/product and she wants her money back. How do we sort that out in the sales made and drug moved back on the shelf
If drugs expires how do we reconcile and withdraw the drugs
I want something like
Drugs Removed form
Drugs Returned form
Purchases
Purchases id
Purchases date
Drug name/product name
Cost price
Quantity
Total
Cancel order if not needed
Print out purchases if need be
Track outstanding payments to make
Patient and customer history
Patient id
Patient name
Sex
Date of birth
Address
Phone number
Complaints
Observation
Diagnosis etc
Supplier
Supplier id
Supplier name
Company
Address
Phone number
Supply history
Stock taking
To do a check of the physical count with what is on the system.
Employees
They will have different access levels and passwords and the access levels can be changed at anypoint if I wish
I want the backend on an sql server while the front should be ms access 2007
This is just to give you an idea of what I want
That's the summary I want done.
Thanks
Damola T.
100% (2)Projects Completed
3
Freelancers worked with
2
Projects awarded
22%
Last project
10 Jun 2015
Nigeria
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies