<img height="1" width="1" src="https://www.facebook.com/tr?id=202594434012359&amp;ev=PageView &amp;noscript=1">

Reduce Design Time, Project Risk & Cost: Utilizing EDI Style Messages to Integrate WMS Systems to the ERP

WMS.jpgAs ERP releases rollout more frequently, and more organizations edge closer to an upgrade project, they are evaluating the integration of disparate best of breed WMS solutions to their ERP platforms. While the integration of these critical technologies was once mainly driven by economic and project requirements, today the most common reason is simple – the WMS system is working well, but the company’s ERP platform needs to be replaced or upgraded.

In those cases, integration poses a major challenge and a project risk, especially when no native integration exists and it must be architected. While the optimal WMS to ERP integration is seamless real-time communication, in many cases it’s not a viable option due to technology limitations or simply because it’s not worth the expense of building a real-time interface.

If integrating your ERP with WMS is causing you anxiety, read our white paper to learn how we've helped other companies create seamless integration.

Data Masons has a large degree of success integrating WMS platforms to ERP systems, such as to Microsoft Dynamics or Exact Macola, by utilizing the same approach we use for public warehouse (third-party logistics or 3PL’s). This integration model is mature and relatively standardized in the 3PL industry. These process flows, including the EDI X.12 document description, are as follows:

  • Warehouse Shipping Order - Used to enable the depositor (ERP system) to advise a warehouse (WMS System) to make a shipment, confirm a shipment, or modify or cancel a previously transmitted shipping order, make a shipment, confirm a shipment, or modify or cancel a previously transmitted shipping order.
  • Warehouse Stock Transfer Shipment Advice - Used by the warehouse to advise the depositor that shipment was made. Also used to reconcile order quantities with shipment quantities.
  • Warehouse Stock Transfer Shipment Advice - Used by a depositor or an agent of the depositor to advise the recipient that a transfer shipment has been made. Also provides a receiving location with detailed information concerning product being shipped to that location.
  • Warehouse Stock Transfer Receipt Advice - Used by a receiving location to advise a depositor or an agent of the depositor that a transfer shipment has been received. Also provides the depositor or the depositor's agent with detailed information concerning product that has been received.
  • Warehouse Inventory Adjustment Advice - Used to inform a warehouse/depositor of a quantity or status change to inventory records. Also provides detailed information concerning the internal adjustments which occur between a warehouse and a depositor.
  • Inventory Product Synchronization (Item Maintenance) – Pushed by the ERP to the WMS that includes item dimensions and weights, which is essential for WMS and Transportation Management System (TMS) functionality).
  • Inventory Inquiry – This document is commonly used to communicate inventory status and quantity information from a seller to a customer. This information can be used to compare and reconcile inventory levels between the ERP and WMS systems.

Integrating WMS systems is a little different than 3PL’s as far as process flow and information needs go, but it’s possible to reduce the challenges utilizing existing integration patterns and specifications that are tried and proven in the world of EDI. The format of the data itself is secondary to the concept – flat files, XML files and virtually any data format can deliver the same result – X.12 EDI flows simply provide an established template that has considered virtually all data requirements.

Understanding this concept will allow organizations to integrate disparate WMS and ERP systems utilizing existing EDI design models, which is a proven way to reduce design time, project risk and cost when integrating EDI to WMS solutions without native integration. Read how our customers are successfully integrating EDI with their ERP and WMS systems. Many of them have overcome challenges and found success with our EDI solution, which can take the headache out of integrating WMS systems and assist with other business processes. Read our white paper to learn more.

New call-to-action

Dynamics AX EDI, Dynamics GP EDI, Exact Software Integration, Dynamics NAV EDI, Dynamics ERP Integration

Glenn McPeak

Posted By: Glenn McPeak

Glenn is a supply chain expert and has over 25 Years of EDI/ERP solution consulting and ERP/EDI software product design and management. Glenn’s has managed and executed over 200 successful ERP and EDI related projects in a wide array of manufacturing and distribution oriented industries. Glenn is knowledgeable in the following ERP platforms – Microsoft Dynamics AX, Microsoft Dynamics NAV and Microsoft Dynamics GP.

Glenn holds a Bachelor of Science degree with highest honors from Babson College and numerous Microsoft Certifications, including Microsoft Certified Professional.

EDI Made Simple

EDI Made Simple: A New Approach to EDI

If you're about to bring EDI into your processes, this brief will help you avoid the potential pitfalls often encountered. If you’ve attempted to implement EDI already, you’ll likely recognize at least some of the problems we describe, and gain from our explanations on how to avoid them.This paper will present a clear, simple path to successful implementation of a highly productive and profitable EDI initiative in your company.

Download the Paper

Choosing an EDI Solution

Choosing an EDI Solution: Build or Buy?

Choosing an EDI software solution for your company is a serious undertaking. The right choice results in a smooth and painless process with strong positive ROI. The wrong choice can have detrimental effects for years with poor ROI and ongoing operational and support issues. One key question we often hear is “Should we build it or buy it?”.

Download the Executive Brief

Top 10 Mistakes to Avoid

Top 10 Mistakes to Avoid When Selecting an EDI eCommerce Solution

Don’t be caught unprepared with your upcoming EDI project. From the provider and solution, to your business needs post-implementation, a company can prevent costly headaches by being as thorough as possible in their pre-implementation research.

Download the White Paper

Integration Without Customization

Integration Without Customization: 3 Keys to Automated Integration for ERP and EDI

This paper will present the key components of a successful automated integration solution for ERP and EDI without customizations. After reading this paper you'll learn: - how to gain a competitive advantage with this approach to EDI and ERP integration - and how purchasing tools which force customizations to your ERP system can leave you responsible for costly and time consuming modifications to the systems. Following this best practice approach to integration can help you on your way to experience integration success.

Download the Executive Brief