Basic inventory and invoice management

We wish to build a basic inventory system with below option: 1. Maintain Medicine master 2. Price master 3. Option to add medicines in inventory and update stock 4. Search for a medicine in stock 5. gnerate invoice and deduct inventory 6. generate few basic reports to know high flowing medicines, slow flowing medicines, usage per week etcs. This shud be built as a desktop application with db also on local machine. The application shud be ready in a week to 10 days time. ## Deliverables **DRUG INVENTORY SYSTEM** **for** **Ameya Health Care** Features Needed: 1. Secure System- Include user authentication and track transactions by user. 2. Maintain Drug Master- Should have basic details of Drug, Cost by Vendor. 3. Purchase Maintenance - Each buying transaction with Vendor details, Date purchased, Drug details like quantity, cost per unit, date manufactured and expiry date. 4. Drug Issue- Identify In-patient and Out-patient transaction. Capture details like Customer, Drug, Date and time Issue, Quantity, bill amount, paid amount. 5. Quick Drug Issue by Customer: Enter Customer Id and get all the medicines taken by the customer earlier and select the required drugs and modify quantities. There shud also be option to add additional medicines 6. Quick Drug Issue by drug: There should be a list of Drugs displayed based on the fast moving drugs. Pharmacist should be allowed to select the drugs from there, modify quantity and add to issue transaction. 7. Invoice generation: Option to identify In and Out Patients. i. Out Patient Invoice option should be available on the Issue Transaction screen. There shud be additional option to search for all outstanding payments for the customer and make it a part of invoice. ii. In Patient Invoice. There shud be a separate option to generate Invoice, there we can choose the customer and generate Invoice for all outstanding payments. 8. Drug Return By patient: There shud be option to allow to enter the returned drugs from Patient, into stock. The invoice shud be adjusted for these returned drugs. 9. Drug return to Vendor. User should be allowed to enter the reason why a drug has been returned to Vendor. **Reports:- to be detailed.** 1. Stock Availability by Drug- search 2. Drug Expiry report 3. Billing report for outstanding payment to Vendors or from Customers 4. Total return goods 5. Pending Payment report 6. Balance Sheet- dash board 7. Fast and Slow moving Drug Report 8. Inventory Stock report, showing drugs which are overly and underly stocked. 9. Company wise report 10. Search Issue, receipt by date, drug, all **Attribute List: -- all yellow fields have to be calculated automatically** **Drug Master:** Drug name Drug Generic Name (Salt) Company Name Dose (eg: 5mg, 10 mg, 100 mcg) Drug type (tablet, syrup, pouch, ointment, suspension, vials) Tablets per strip/bottle Strip per box Min Stock Max Stock Stocking Unit (strips) Clinical use (Disease) Intake (Intra muscular (IM), Intravenus (IV), subcutaneous (s/c) , Oral) Side effects Contraindication Substitute Other Info **Vendor Master** Vendor Name Address Phone **Drug Cost** Drug Name Vendor Unit Cost Cost per Unit (Strip, Bottle, Box etc) Cost at lowest level (eg: cost for each tablet) Lowest level unit (tablet, bottle, pouch) Effective from Date End date **Receipt Header** Vendor Vendor Invoice id Date of Purchase Receipt Cost ** ** **Receipt Line (Child of Receipt Header)** Drug name Unit of Measure Quantity Unit Cost Line cost Expiry Date Clinic Location **Stock** Drug Name **Number of Unit** Measuring Unit Expiry Date Store location **Stock Cost** ** ** **Price Master - Will be updated at time of receipt** Drug Name Unit Price Unit of measure Effective Date End Date Store Location **Customer Master** Customer ID (Unique Patient Id) Name Address Phone # Disease Age Sex Payment Status (Good, Defaulter, bad) **Issue** Customer UID Name Clinic Total Drug Amount Past Outstanding Total Payble Payment Made Current outstanding **Issue Line** Drug Unit Price Unit of measure Total amount Discount ** ** ** **