Based On The Enterprise Lan Platform Warehouse Management System Design

In some small and medium enterprises, inventory management uses the paper account, and products inputting and outputting of warehouse uses the handwritten notes, while prime and end of stages of checkout use the manual checking. Nowadays, this laggard inventory management model has been unable to meet the needs of production and management. It is urgent to develop a software of inventory management using advanced inventory management which adapts the changes of the production situation.Warehouse management system is a management software which helps the small and medium enterprises do something like registering products warehousing and warehousing-out and making inquiries statistics, act. This paper introduces the development environment of the warehouse management system, need analysis, conception of design, design and function of database and realization steps of main module. And the paper analysis the function of the warehouse management system about the need of some company. The paper also describes the technology points of the structure design of every module and the process of implement, such as registering products warehousing and warehousing-out. The interface development tools of this software is PowerBuilder8.0 and database is SQL Server7.0.By this software, customers can do the updating, deleting and querying operations to the fundament information of products, manage the procedure of products warehousing and warehousing-out, query the products detail information of warehousing and warehousing-out, make reports to the warehousing and warehousing-out and the remain storage of products, and manage the user information, such as updating, deleting and querying. Furthermore, the software possesses the following functions, operator managing, authorities setting, passwords changing, and so on.