Research And Design Of Purchasing Management Subsystem In Distributed ERP

As advanced managing ideology and informatization tool, ERP (Enterprise Resources Planning) considers the effect of manufactures, suppliers,distributors and customers, faces to the whole supply-chain management. Purchasing is an important part of the logistics and fund flow at the threshold of supply-chain. Adopting advanced and efficient purchasing management can not only provide continual materials flow for enterprises, but also help them improve the product quality and reduce the cost.By comparing the characteristic of domestic and foreign ERP software, this paper analyses the advantages and disadvantages of the two-tier Client/Server structure and proposes the three-tier architecture model of ERP system.By investigating conventional purchasing business process and considering different demands of different enterprises, making vendor schedule may obtain data from three channels: the order form requirements,the production form requirements and the resupply inventory advice.Then according to the advanced purchasing management ideology-JIT purchasing, the business data flowcharts of purchasing management subsystem including the conventional purchasing business process and JIT purchasing mode are designed. And then the function module is designed after analyzing the Entity-Relationship chart.The distributed object model is studied, and the data management level, business logic level and graphical user interfaces of the purchasing management subsystem are created based on the formidable distributed disposing technology of Delphi and the visual inherited technology.Finally, considering enterprise data security and business regulation secret, mainly analyses the characteristic of MS SQL stored procedure, studies how to...