AN EFFECTIVE PROCUREMENT AND INVENTORY MANAGEMENT SYSTEM FOR ABC TEXTILE SHOP

Abstract

ABC is a retail textile shop is situated in a suburb area of Anuradhapura, Sri Lanka. They have a routine of daily sales and weekly purchases and have a monthly expense of utility and salary payment for workers who work on sales. For the moment they are running a filebased system like Excel sheet for inventory keeping, purchasing, maintaining vendors’ details and workers details, daily sales and profit margins including number of items on each variety with a custom variety code. Since there is poor network coverage in the area, they are unable to use an open source online inventory system. So, it was decided to implement an inventory management system for them. By developing, “Procurement and Inventory Management System”, they can reduce their time for entering, updating, calculating and retrieving data. Not only that but also, they can avoid data redundancy, data consistency, high data security, privacy, and easy recovery. They can enter memos or special notes and they can filter and search related data. And, they can export grid view data to Microsoft excel sheet. The system built has been able to have a positive and beneficial impact on both organization and consumers. To develop the system, it was used agile software development methodology, the SQL Server 2014 was used as the database, Visual Studio 2010 as developer tools and C# is used as the programming language. The results of this study to get a system that has been developed that can make transactions which generate transaction reports, and which update database and remind notes for consumers thus greatly supporting the activities at the ABC shop.