JDE库存管理与WMS系统接口设计与实现硕士学位论文

浙江大学硕士学位论文 摘要

硕士毕业论文

JDE库存管理与WMS系统接口设计与实现

i

浙江大学硕士学位论文 摘要

摘要

面对日益激烈的市场竞争，只有有效的降低企业的生产成本，增加企业利润，提高管理水平，并且不断加强企业资源的整合与管理，才是企业立足之根本，随着信息化社会的飞速发展，高效率的管理整合企业资源，使企业管理层能够准确的市场定位及合理的企业决策变得有章可循，有据可依。ERP作为现代企业管理中不可或缺的有力管理工具，是企业信息化进度的重要标志，而对于制造型企业库存管理是企业的第二利润源泉，合理的库存管理直接影响着企业的成本和利润，也是制造型企业长期困扰的问题。

本文以上海东冠纸业有限公司库存管理的业务需求为前提，结合WMS系统与ERP库存管理系统的特点，以JDE系统为主体，对两个系统影响到库存的业务进行接口设计与开发，解决了企业内部WMS系统与JDE库存管理系统信息孤岛问题，并以此为例来关注实施JDE的企业是如何解决企业内部多部门多系统相似信息及时传递的解决方案，达到使企业内部数据流动通畅，及时反映企业的仓储情况的效果。

关键词：信息化，ERP,库存管理，JDE，WMS，信息孤岛

ii

浙江大学硕士学位论文 Abstract

Abstract

With the increasingly fierce market competition, only effectively reduces the production costs, increases the profit, improves the management level and constantly integrates and manages enterprise resources can enterprises be established in the industry. The rapid development of information and efficient integration of enterprise resource management ensure the enterprise management easily make the accurately market positioning and reasonable business decisions. As an integral part of modern management tools, ERP is an important symbol of enterprise information progress. Inventory management for manufacturing companies is the company's second profit source, the reasonable directly impact on inventory management costs and profits of the enterprises, it’s also a problem bored the enterprises.

According to the SOCP company inventory management business requirements, with ERP system combining WMS inventory management system with the characteristics of JDE system as the main, design the interface between the systems, solved the information island case between the enterprise internal WMS system and JDE inventory management system. Further illustrate the solution that solve the enterprise internal departments deliver timely information, make the enterprise internal data flowing unobstructed, respond the storage conditions timely. Based on this point, explain the connection and data transmission problem of JDE system and enterprise multiple system.

Key Words：informatization, ERP, inventory management, JDE, WMS, information island

iii

浙江大学硕士学位论文 目录

目录

摘要 ............................................................................................................................. ii Abstract ....................................................................................................................... iii 目录 .............................................................................................................................. I 图目录 ........................................................................................................................ III 表目录 ....................................................................................................................... IV 第1章 绪论 ................................................................................................................ 1 1.1 课题背景 ............................................................................................................. 1 1.2 课题来源 ............................................................................................................. 1 1.3 本文研究内容及结构安排 ................................................................................. 2 1.4 本章小结 ............................................................................................................. 3 第2章 ERP及其相关理论技术介绍 ........................................................................ 5 2.1 ERP理论的形成 .................................................................................................. 5 2.2 ERP与库存管理 .................................................................................................. 8 2.3 库存管理的分类 ................................................................................................. 9 2.4 库存管理的模型分析 ....................................................................................... 10 2.5 ERP与EDI接口技术 ....................................................................................... 16 2.6 JDE中EDI接口的应用 .................................................................................... 18 2.7 本章小结 ........................................................................................................... 21 第3章 接口方案设计 .............................................................................................. 22 3.1 上海东冠纸业有限公司背景 ........................................................................... 22 3.2 上海东冠纸业有限公司库存现状分析 ........................................................... 23 3.3 接口方案设计 ................................................................................................... 26 3.4 本章小结 ........................................................................................................... 28 第4章 接口的开发与实施 ...................................................................................... 29 4.1 入库管理 ........................................................................................................... 29 4.1.1数据库表设计 ............................................................................................. 29 4.1.2 JDE开发界面——P56WMS2 .................................................................... 30 4.1.3 UBE设计 .................................................................................................... 32 4.1.4 入库实际案例展示 .................................................................................... 34 4.2 出库管理 ........................................................................................................... 36 4.2.1 数据库表设计 ............................................................................................ 37 4.2.2 Form 界面设计 P56WMS1|DG0001 ........................................................ 38 4.2.3 UBE设计 .................................................................................................... 41 4.2.4出库实际案例展示 ..................................................................................... 43 4.3 调拨管理 ........................................................................................................... 46 4.3.1 数据库表设计 ............................................................................................ 47

I