Inventory, Transaction and Production Management System For Thai Aluminium (PVT) Ltd.

Abstract

Thai Aluminium is a small shop which was started in 2000 with few staff members near Colombo. Today Thai Aluminium boasts of a workforce of more than 15 staff with two stores and two shops. They are specialists in showcase fitting items. They are dealing with both local and foreign suppliers. They have retail and wholesale customers and also they distribute items for working places. The items they sell are aluminium fitting items, rivets and screws, wood items, aluminium bar items, rubber items and many more. Currently they are using a manual system for all tasks in their business. Like, preparing purchase orders, delivery orders, invoicing, item detail management etc. There are no any update in inventory system. Because of that it is difficult to identify the inventory level and reorder quantities. As a result, they are facing problems of a manual system like data redundancy, data inaccuracy and delay in decision making due to unavailability of timely reports and information. The proposed system is built to overcome some of the problems and inefficiencies of the current manual system. This solution will mainly manage inventory, purchase and sales. And also it manages item details, employee details, customer details, supplier details and many more. This system is used to generate invoices and mail purchase order efficiently and also it enhances the speed of transaction. Also the collected data will be used to generate a variety of reports such as Daily Reports, Purchase Detail Reports and Sales Detail Reports. UP (Unified Process) was the process model used to develop this standalone system. The system adapts Model View Controller (MVC) architecture and Object Oriented approach. In addition, Unified Modelling Language (UML) was used for analysis and design. Java, JavaFX, MYSQL, ORM (Object Relational Mapping) and jasper reports are technologies mainly used to develop this windows system. JUnit is the tool used for testing activities in the project. The proposed system will enable to control the accessibility of information relevant to the users who deal with this system and will ensure about the security of the information.