Inventory management system with drug interaction alert

  • Posted:
  • Proposals: 4
  • Remote
  • #665003
  • Awarded
Eldon C.
Sudheer M.Biju J.Syed Zeeshan Haider S. have already sent a proposal.
  • 1


Experience Level: Intermediate
Estimated Job duration: 3 - 4 weeks
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
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
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 id
Purchases date
Drug name/product name
Cost price
Cancel order if not needed
Print out purchases if need be
Track outstanding payments to make

Patient and customer history
Patient id
Patient name
Date of birth
Phone number
Diagnosis etc

Supplier id
Supplier name
Phone number
Supply history

Stock taking
To do a check of the physical count with what is on the system.

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.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.