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.