SALES AND STOCK MANAGEMENT SYSTEM FOR BANDULA SALES CENTER, GALLE

Abstract

The intention of doing this project is to develop a software solution for the sales and stock management in Bandula Sales Center. The company currently uses a paper based inventory system and it is founded to be very cumbersome and inefficient. Some of the major problems being faced by the workers of the company are, remembering the codes for every task in the system and wasting time for searching various details on garment items. The existing system also has no security measure to restrict unauthorized user from accessing certain information. This can result to misuse of the resources. No backup facility in case of data loss or damage and also most business process are not linked so a considerable amount of time is wasted. These are the few major problems of the existing system. The proposed system will allow the company to manage all the information basically related to garment products. It will provide a good system that will replace all the traditional methods of handling day to day work which are being used by the company. This system can be categorized into few features such as stock management, purchase order handling, whole sale customer management, supplier management, transaction handling etc. This proposed system keeps an error free environment inside Bandula Sales Center. It also shows how Information Technology can be used to simplify daily tasks with more efficiently and effectively, within a shorter time, with minimizing failures while increasing the considerable profit level. The Sales and Stock Management System is implemented using C# as the Programming language.SQL server is used as the database server and visual studio is used as an IDE. System was developed according to the three tier architecture in this developed system, Adobe Photoshop is used to create and design interfaces in a more attractive manner. Apart from that Smart Draw 2010 issued to draw the UML diagrams shown in this dissertation. At the end of this project a standalone application that achieved the client requirements is successfully implemented and installed at the client computer.