EMT/EDI and Third Party Logistics Provider Integration in QAD EE
Years ago Logan Consulting started working with its clients on various requests from them to develop tighter integration with third partner logistics providers and warehouse partners (abbreviated 3PL, or sometimes TPL). This originally included very custom approaches to order processing within QAD and the added functionality to integrate with a TPL.
Over the years, a common model has evolved leveraging standard QAD Enterprise Material Transfer (EMT) and EDI functionality to meet intercompany Direct Ship requirements between International Entities within an organization and a 3PL.
An example of the typical process steps used in QAD EE are below:
- International Entity takes Purchase Order from End Customer, creating a Sales Order in QAD EE.
- EMT automatically creates EMT Purchase Order to be sourced from a US based entity operating out of a 3PL.
- 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 International entity, with a Direct Shipment from the 3PL to the end customer.
- An XML Sales Order or Pick/Ship file is sent to the 3PL with the US Sales Order information.
- 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:
- Sales Order Shipper Confirm – shipment processed from US entity to International Entity
- 856 ASN Sent – the Advanced Shipment Notice is sent via EDI to the International entity
- PO Shipper Created and Confirmed – a PO Shipper is created in the International entity and confirmed to create the AP liability to the US entity.
- Evaluated Receipts Settlement (ERS) creates Supplier Invoice – ERS can be used to automatically create the Supplier Invoice
- The PO Shipper Confirm automatically creates the EMT Sales Order Shipment, generating the Pending Invoice.
The client benefit of this process is to automate the intercompany ordering 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 vast experience assisting its clients with business requirements, process design, and EMT/EDI and 3PL integration for the areas 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?
Top 10 Inventory & Operations Decisions Distributors Are Making Blind
2020 Nucleus Research Report on ERP Technology