Inventory management system
Abstract : This paper deals with development of inventory management system for a manufacturing Industry. The developed software System is easy to use, less time consuming & all detail about the inventory items & transaction status. Enterprise Resource Planning (ERP) software presents a frame work for organizations to better utilize their processes. The report is about windows based application. The Front-end is developed using Visual Basic. A visual programming environment provides all features that are required to develop graphical user interface as ready to use components. The programmer does not have to write code to create and display commonly required user-friendly features each time around. The Backend used is SQL server database that ensures total security and no data loss or corruption. The database management systems are warehouses of information, where large amount of data can be stored. The Reports are developed using Crystal Report. Crystal Reports is the standard reporting tool for Visual Studio .NET. It brings the ability to create interactive, presentation-quality content; to the .NET platform. Crystal report is an integral part of the Visual Studio .NET environment. The main idea of this paper is to handle the all details of inventory management system. In this software package has been developed to smoothen the processing of item transaction in inventory such as item receive, item issue & report generation such as stock statement, issue register & receive register etc. This Software will help in automating all the process like receiving and issuing application in inventory.
? Current system is a manual one in which users are maintaining ledgers, books etc to store the information like suppliers details, inwards, deliveries and returns of items in all godowns, customer details as well as employee details.
? It is very difficult to maintain historical data.
? Through UML we see or visualize an existing system and ultimately we visualize how the system is going to be after implementation.
? The main plan for the system developed is to mimic the existing system as it is in the proposed system.
? It is tedious to manage historical data which needs much space to keep all the previous years ledgers, books etc.
? These systems, while useful, did not address the mission critical issues such as supply chain management (SCM), customer relationship management (CRM), and knowledge management (KM).
? Retirement of systems is a serious issue faced by many organizations today as legacy systems are removed and replaced by new systems.
? Report generation is used to drive the statistics of the issues inventory database Based on the required parameters.
? Transaction reports list details for issue and receive transactions items in a specific date account over a specified period, Stock Statement for particular items.
• Proposed system is a software application which avoids more manual hours that need to spend in record keeping and generating reports.
• This application keeps the data in a centralized way which is available to all the users simultaneously.
• It is very easy to manage historical data in database. No specific training is required for the employees to use this application.
• They can easily use the tool that decreases manual hours spending for normal things and hence increases the performance.
• As the data is centralized it is very easy to maintain the stocks of the various items in all godowns.
? ERP basically utilizes ERP software applications to improve the performance, efficiency, facility, data security, eliminate human error, reduction data entry and speedy accurate reporting of material transaction of organization.
? Using coding techniques and good programming practices to create high quality code plays an important role in software quality and performance.
? It will have various advantages compare to traditional ERP System such as faster decision making, Greater operational efficiencies, Improved communication and collaboration, anytime access to enterprise, business and manufacturing intelligence, improved workflow and expedited approval process, improved responsiveness to customer and prospect needs and inquiries etc.
|