EDI and ERP Integration: Three Keys to Automated Integration

Topics: ERP, automated integration, Data Masons, automated workflows, enterprise processes

Posted on Nov 18, 2016 9:10:05 AM by Exact Macola


To complement Macola 10, we partner with best-in-class third party providers to offer add-on solutions that integrate with Macola’s ERP solution, Macola 10. Today, we are pleased to feature a guest blog post from one of our technology solution partners, Data Masons, which offers Vantage Point EDI for Macola, is a cost-effective and reliable gateway for EDI processing and is well suited for enterprise-level EDI environments—and of course—integrates with Macola 10:

Technology and business process automation are increasingly becoming strategic components of success for today’s digital economy. Whether you’re a manufacturer, distributor, retailer, 3PL or in the CPG, automotive or food industries, your competitiveness is often tied to two critical business applications responsible for managing your business, ERP and EDI. Successful implementations of these two key technologies can drive costs out of your supply chain execution and improve key metrics such as revenue per employee and cost per business transaction.

ERP systems, such as Macola 10, handle finances, inventory, manufacturing and the business execution aspects of your operations. Your EDI system handles electronic interactions (transactions) with your supply chain (trading partners) including customers, suppliers, logistics organizations, banks and more.

With regard to handling the supply chain, ERP solutions, such as Macola 10, create, receive, and manage these business transactions, while EDI transforms and communicates these transactions and instructions to and from your supply chain partners. ERP and EDI must be connected to achieve the maximum efficiencies of each. With a tightly integrated supply chain, integrated EDI will reduce labor costs and expensive errors as well.

Clearly these two systems should be connected, but the truth is that most companies are connected poorly or not connected at all. The principal challenge in integration is that while the information these systems handle (products, prices, delivery, etc.) is the same, the ERP context and format of the data used varies greatly among ERP systems (partners) and is may be very different from the data in your ERP system. This means the data must be cross-referenced, validated and formatted precisely to create accurate business transactions in your ERP system and in the ERP systems of your partners. 

The transaction integration gap is often solved by modifying the ERP to manage the transactions received and sent by EDI. Common ERP-based approaches include staging tables, and complex data “scrubbing” and formatting which can result in expensive ERP modifications that are invasive and inhibit updates to the ERP. These customizations can be difficult to automate and may require frequent manual intervention.

Integration Without Customization

There are three main criteria for achieving automated integration between your EDI and ERP systems without ERP customizations. 

  1. A strong understanding of the ERP system and the best practice approach to integration.
  2. Utilization of a processing platform that is flexible and combines knowledge of the data in the ERP platform so data is sent accurately to the ERP and follows the end user’s business requirements.
  3. Reduced user involvement with strong error trapping with alerts and automated error resolution wherever possible.

The Old Way

Historically, connecting EDI to ERP systems required the export of the information from a translator that would reformat data received from partners into a common format that could be imported into the ERP system. The next step would be for the ERP system to do all of the “heavy lifting” – i.e. all of the error handling, data scrubbing and “cross-referencing” before attempting to create a proper transaction. Outbound transactions require even more effort from the ERP system by expecting the ERP system to understand all of the partner and transactional relationships, and even provide information that is extraneous to the ERP (“turnaround data” usually received on the inbound transaction) back to the translator. This unpredictable “turnaround” data usually has no native storage area in the ERP system and requires customization for storage so that it can be passed back to the translator at the correct moment. Since the demands and needs of current and future partners are nearly impossible to anticipate, ongoing customizations are the norm for most ERP platforms. 

Organizations that undertake ERP customization projects for EDI integrations frequently report the same problems which include: 

  • Over budget ERP implementations.
  • Difficult and expensive ERP upgrades.
  • High ongoing cost of maintenance.
  • Transactions “falling through the cracks” due to the decoupled nature of Translators and ERP transactions. This is caused by multiple points of failure in the solution and lack of transaction lifecycle audits.
  • Unplanned disruption of ERP production environments to meet external mandates from partners.

The Solution

Full integration requires a strong and well architected connection between the EDI and ERP data so that the business rules and validations can be performed at the time the transaction is processed. A system that understands the unique EDI and ERP processing requirements can stand between the two processes: the ERP data and the EDI trading partners. That system must be specifically attuned to the way the ERP ‘thinks’ so that it can pass information between the systems without undue burden on the ERP.  Additionally, the EDI processing platform has to understand the relationships between partners and the ERP transactions to avoid customizations. “Turnaround” data has to be stored in a manner that is flexible and accessible to the outbound transactions.

Taking full advantage of the opportunities of advanced supply chain automation requires experts who understand both the ERP and EDI. Many EDI shops don’t have experts in the ERP system that must reliably connect the EDI data nor the correct platform to make it work without ERP customizations. To be an expert in EDI to ERP integration, there must be a deep understanding of the implementation, maintenance and lifecycle development of the ERP so that transactions are handled correctly every time.

Many EDI service providers offer EDI compliance, but very few make the commitment to coupling those capabilities with expert ERP integration that avoids ERP customizations. Only those organizations can support such end-to-end integration in the long-term.

We are pleased to be able to share this guest blog post from Data Masons, which offers Vantage Point EDI for Macola, a cost-effective and reliable gateway for EDI processing that integrates with Macola 10. Thank you for your interest in this guest blog series. We look forward to sharing future posts from other partners with best-in-class third party providers who also offer add-on solutions that integrate with Macola 10.

For more information about Data Masons, please contact: vicky.basile@exact.com


The ERP Blog covers the impact of Enterprise Resource Planning (ERP), business software and accounting solutions on organizations in the manufacturing and distribution industries.

On Demand Webinar

5 Reasons To Use Automated Workflows in Your ERP Solution

Watch the Webinar


Subscribe to Email Updates

Are you evaluating  ERP software?

Recent Posts