In today’s generation, we all know that technologies are everywhere. Computerized or automated are in great demands. We all know that these technological innovations have a great help in our personal lives as well as the business world. In terms of a grocery store, drug store or pharmacies, it is a hassle for them to do all the process manually. Computing manually spends long time. Also for the customer who sometimes get irritated because of the long waiting-falling in line.
Bailer’s Pharmacy is presently using manual procedure of computing the sales report. They just looked at their item list to see the prices of their products. The study aims to develop a Computerized Sales System for Bailer’s Pharmacy. This will include some features such as the POS, the Point of Sale System. You can even make sales report right at the cash register with point-of-sale (POS) software systems. POS software records each sale when it happens, so your records are always up to date. Better still, you get much more information about the sale than you could gather with a manual system. By running reports based on this information, you can make better decisions about ordering and merchandising. Sales Report System for a Drugstore using Point of Sale is necessary to do all automatically with the help of Advance Programming- Visual Basic 6.0 and for the database the Microsoft Access.
1.1 Current State of Technology
Bailer’s Pharmacy is located at Blk. 15 Lot 14 PH1 Green Gate HomesMalagasang II-A Imus, Cavite. It was established on February 16, 2010. It offers branded and generic medicines and other pharmaceutical products. Bailer’s Pharmacy has approximately 3500 items which are stored in15 cabinets. They currently have 20 suppliers of medicines which is from their distributor, sub distributor and marketing arm—the Zuellig, Unilab, Metrodrug they are the top 3 drug distributor here in the Philippines. ***Bailer’s Pharmacy is currently using manual system of sales Report. The pharmacy has difficulty in monitoring their items. In making a sales report, they need to do record it manually that tends to make mistakes in terms of counting, misplaced and even the monitoring of expiration in selling the items. They just look at their pricelists at the computer that takes long time to consume. They do all their records manually-- typing it in the Microsoft Excel which causes that these reports could be corrupted or lost so they needed to back up these reports 3 times. The sales, expiration, mark up adjustment with or without vat, discounting, indication of distributor, sales report “ time to date” and returns.
1.2 Statement of the Problem
1.3.1 General Problem
* How to create a computerized Sales Report for the Bailer’s Pharmacy using the Point of Sale System? We chose the Bailer’s Pharmacy for our Sales Report System because we want to create a computerized Sales Report System for them to have a faster sales record process.
1.3.2 Specific Problems
* How to create a module that will automatically record the sales/ purchase order? This pharmacy is currently using manual procedure of recording. Even if it is using computer, they just record it manually.. * How to create a module that will indicate the distributor, and the item records. The Bailer’s Pharmacy had experienced in marking the lists of their products at wrong distributor, once they would return their products, it is hard for them to classify where the product came from.
* How to create a module that will updates the number of stock in and stock out of products. The Bailer’s Pharmacy had experienced hard time in monitoring the stocks of their products that results to miscalculations of inventing their items. 1.3 Objectives
* To create a computerized Sales System using the point of sale with the help of a barcode scanner for the convenience of the customer/ owner or the...