The Research And Development Of Warehouse Inventory Management System

In the process of enterprise development, The control of Interior materials andfinished product has become a most important issue to its stock management,By thissituation,it is a must to realize the inventory management informatization.As an important part of enterprise information management, Inventorymanagement controls the internal circulation system from raw materials to finishedproducts, Starting from receiving orders to classifying them into raw materialsprocurement demand, to sourcing according to the inventory of stock partst, to supplierdelivery, to log into warehouse system, also to finished product data keyed in untillshipping at all the production process.The design of this system adopts the structure of C/S, use SQLSERVER2000as adatabase for data storage, according to the actual operation process, the system dividesfunction modules according to user responsibilities; the general principle of softwaredevelopment has carried on the system requirement analysis, database design, systemarchitecture design, the whole function of the system implementation, thus completingthe material and finished goods in circulation of the whole process.System mainmodule includes user management module, management module, product managementmodule, procurement management module, product entry module, product materialdemand, purchasing module, material storage module, module of production frommaterial, production and storage module, product delivery module.In the development process, We use a variety of testing methods, and integratemany test cases to this test system,which includes system security testing, unit testing,and system functional testing, Results show that: the system covers warehouse goodscirculation process completely,which can cause the material management runsorderly,also can provide fast and effective data for the purchase, production, sales andother business activities,Finally, by using the system, it can improve the workefficiency, and provide effective tools to its supply management, which is inconsistent with the expected target to improve enterprise more efficiency.