Skip to main content

Integration Frustration: Why Microsoft Dynamics GP Integration Tools Need a Kickstart

by Mark Polino
Director of Client Services, Fastpath, Integrated Business Group

I've done a ton of integration work with Microsoft Dynamics GP recently and it's left me frustrated. The common tools, Integration Manager and eConnect still have some frustrating holes. As a result, any third party tools, like SmartConnect, that rely on eConnect have the same limitations. 

An example I keep bumping into over and over is integrating EFT information for Vendors. In an initial implementation, we generally use the Table Import feature to populate EFT data because it's all stored in one table. The problem comes when companies want regular vendor integrations with EFT. For example, one firm I know has affiliates that they pay in a program similar to Amazon Associates or Google's AdWords. The affiliates can sign up or change their payment information online and the changes need to be integrated into Dynamics GP.  Except that there is no way to regularly integrate new or updated EFT information in conjunction with vendor changes without writing custom code.

It seems to me that Dynamics GP's integration tools have stagnated. Integration Manager's default connectors continue to be slow and buggy. The only recent "advancement" was the replacement of the SQL optimized connectors with eConnect adapters. This helped Microsoft but it did very little for the end user or consultant. eConnect-based integrations are just as fast as their SQL predecessors but the fields missing in the Integration Manager interface for high speed SQL connections are still missing in the eConnect-based interface. And users still can't reasonably schedule an Integration Manager integration without shelling out for an Integration Manager add-in.  Silly, I know.

For some reason Microsoft just keeps repaving the integration cow path in Dynamics GP when they should be building an integration super highway, with Dynamics GP as the ...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Mark Polino

Mark Polino is a Certified Public Accountant (CPA) and a former Microsoft MVP (2007-2018) for Business Solutions. He is the author or coauthor of 5 books related to Microsoft Dynamics GP.  Mark also maintains the Dynamics GP focused website DynamicAccounting.net. He speaks and writes regularly about ERP related topics. Mark has been a controller and CFO for a division of a publicly traded company and he has  worked as a consultant implementing ERP solutions. Mark holds additional certifications including Certified Information Technology Professional (CITP), Certified in Financial Forensics (CFF) , Chartered Global Management Accountant (CGMA). Dynamics Credentialed Professional for Dynamics GP 2015 (Core Install and Core Financials), Xero Certified. He holds a bachelor's degree in accounting from the University of Central Florida and an MBA from Rollins College. Mark lives with his family in Florida.

More about Mark Polino