Pharmaceutical Accounts and Inventory Menagement System (PAlMS)

Abstract

The developed software has been of great facility in order to efficiently manage the day-to-day business of an organization. This particular product is meant to automate the two major business areas of Pharmac~utical Business, which are Inventory and Accounts. Different services that are going to be provided by the inventory management system are that the inventory control database stores Product Information, Information about buying and selling medicines, Purchase order information, Information about Supplier. Complete record of all the items stored in the Organization (SHAZAL) is maintained. Software has report generation capability to provide the management with the inventory information and decision support. A complete accounts management system has been provided to support day to day business transactions. Software is supposed to maintain record and generate reports of the accounts for the Executive Management of the company. The transactions occurred at particular date are recorded under corresponding head of accounts like Assets, Liabilities etc. Also individual Ledger are prepared to record the transactions occurred as a result of particular deal. Keeping in view the important principles of human's interaction with computer, I have used Visual Basic 6 on Front End for following reasons. • It provides user-friendly GUI environment. • It is easily integratable with other Microsoft product. I have selected SQL Server to use on Back End for following reasons. • SQL Server offers the best performance on Microsoft's Operating Systems. • SQL Server is less expensive to purchase and operate. • SQL Server supports Visual Basic effectively. • SQL Server provides good security features and manages huge data efficiently unlike Access. • SQL Server has been design to be self-tuning ..