QAD’s Enterprise Material Transfer, EDI and Third Party Logistics Provider Integration

Posted on: March 12, 2018 | By: Tim Lovely | QAD Financials, QAD Practice News, QAD Business Process, QAD Distribution

Logan Consulting is seeing increased use of QAD’s Enterprise Material Transfer (EMT) and EDI functionality to meet intercompany Direct Ship requirements between International Entities within an organization. Additionally, Logan Consulting clients often use Third Party Logistics Providers (abbreviated 3PL, or sometimes TPL) to store the finished goods and process the physical shipment to the end customer. 

An example of the steps in this process are below:

  1. European Entity takes Purchase Order from End Customer, creating a Sales Order in QAD.
  2. EMT automatically creates European EMT Purchase Order to be sourced from a US based entity operating out of a 3PL.
  3. EDI is used to automatically send an 850 Purchase Order to the US entity, which then is used to automatically creates a Sales Order in the US entity for the sale of goods to the European entity, with a Direct Shipment from the 3PL to the end customer.
  4. An XML Sales Order file is sent to the 3PL with the US Sales Order information.
  5. Once shipped, the 3PL sends an XML Shipment File back, which is interfaced to QAD as a Sales Order Shipper and automatically confirmed via the EMT process. This kicks off an automated EMT process which completes the following tasks:

    The major client benefit of this process is to automate the intercompany ordering, sales and procurement process using standard EMT functionality, while integrating with 3PL’s for shipment processing.

    Other key considerations that should be confirmed in the design of the process above include the following:

    • Tax Design – Tax requirements for all orders and countries involved need to be confirmed
    • Data Management with 3PL – It is common that the US entity is used to represent the activity at the 3PL, meaning inventory needs to be kept in synch between the two organizations so it can be consolidated just like any other site/entity in QAD

    • Master Data Management – 3PL’s often require additional master data in their ERP systems, which must interfaced or manually managed to make sure 3PL systems are up to date.

    • Invoicing – Confirm who owns the invoicing process. This often can be done by the 3PL, which requires even more master data information to reside in the 3PL systems.

    Logan Consulting has experience assisting its clients with business requirements, process design, and EMT/EDI and 3PL integration for the area above.

    About Logan Consulting

    Logan Consulting is a leading consulting firm with strengths in strategy, project management, business process design, ERP and CRM implementation, recruitment and training.  Since 1992, our business process-based delivery techniques and tools have helped our clients build a solid business process and information technology foundation to support their business.  Our clients count on us for objective, unbiased analysis, recommendations and project work.  To learn more and hear what our customers are saying about us, please visit our website (www.logan-consulting.com).

    Logan Consulting is headquartered in Chicago, IL with global services reach.



    Is Your Accounting Software Hurting Your Business?
    Is Your Accounting Software Hurting Your Business?

    Free Download:

    Is Your Accounting Software Hurting Your Business?

    Download the guide ›

    Top 10 Inventory & Operations Decisions Distributors Are Making Blind
    Top 10 Inventory & Operations Decisions Distributors Are Making Blind

    Free Download:

    Top 10 Inventory & Operations Decisions Distributors Are Making Blind

    Download the guide ›

    2020 Nucleus Research Report on ERP Technology

    Free Download:

    2020 Nucleus Research Report on ERP Technology

    Download the guide ›