Pharmacy Record Management System Project in PHP, ASP or C#.NET
Project Domain / Category
City pharmacy is one of the famous Pharmacies which provide medicines to customers prescribed by particular doctors.
The pharmacy has medicines for different diseases. Also, there are several members of the pharmacy to for keeping /taking medicines in or from the relevant cupboards to facilitate customers. The pharmacy staff is responsible for the management of information of medicines, company, sales, and inventory in register books.
To make the City Pharmacy more reliable and convenient for staff as well as for customers, the whole pharmacy should be computerized to reduce errors chances and hardworking of the staff members by eliminating manual entry in registers for record keeping, remembering cupboard or rack of any particular medicine, making bills for customers. The system should be able to keep the information of customers and medicine for a long time.
Working mechanism: Customer comes and provides prescription paper to the pharmacy staff. The concerned member search for the required medicine(s) in computer and note the location of that particular medicine(s). The staff member picks the medicine(s) from the rack and gives the medicine(s) in a basket to the admin. The admin makes entry of medicine(s) in the computer for calculating prices which are stored in the database.
The system automatically calculates the bill against the medicine(s) entered by admin. The admin tells the total amount of the required medicine(s). The customer pays the bill. The admin takes the print of the bill and provides the receipt to the customer. The system then balances record of the remaining quantity of sold medicine(s).
In case a particular customer returns the medicine(s), the medicine quantity should be brought to the previous state as before.
Upon return, the total quantity of same medicine should be updated and the amount should be deducted from the total money of sales according to the returned quantity.
Some common functional requirements are:
- Admin Login
- User-friendly interfaces
- Interfaces validation check for entry, update, delete, search etc.
- Medicine(s) record entry, update, delete
- Track all information of medicine(s), inventory, pharmacy
- Shows information and descriptions of pharmacy, stocks.
- Bill calculation.
- Record updating in case medicine(s) sold, returned
- Total Cost of all medicines
- Calculate total profit
- Deduct amount from total sales if the customer returns medicine(s)
- Updating quantities of medicine(s) in case of populating pharmacy with medicines.
- Report generation.