Integration Manager is an integration tool used to convert and transfer data from most database formats or desktop applications into Microsoft Dynamics® GP. Like most software tools, Integration Manager has developed a bit of a reputation, but we are here today to clarify… are these three statements true about Integration Manager?

1. "Integration Manager is not extensible"  – Fiction
   Integration Manager provides the ability to attach event and field scripts using VBScript. You can enable scripting for complex conversions and calculations of values that must populate certain fields, for example, in the expense reports integrated into Accounts Payable.  Like any other development process, Integration Manager Scripts are maintained in a Source Code control system to facilitate tracking revisions and changes
2. "Integration Manager is not flexible" – Fiction
   VB Scripts added to Integration Manager Routines allow the most flexible deployment.  In addition, within the field mapping function, many fields are enabled to accept data from the source file, from a constant, from input at the moment of integration, or from a script.  Translation tables can be created locally or globally.  For example, we can translate the old QuickBooks account number to a completely new segmented, Microsoft Dynamics GP general ledger account number.
3. "Integration Manager is not user friendly" – Fiction, mostly
   Out of all the integration tools available for Microsoft Dynamics GP, Integration Manager is the easiest to use once Integration Routines have been designed by an experienced technician.   It is the only integration tool that has a simple user interface allowing the end-user to simply click on the preferred integration to execute it.  It provides a log file report for any issues that were encountered during the integration process.  In addition, Integration Manager helps the technician and user by using Microsoft Dynamics GP business rules—IM acts like a user during integration so errors involving bad data are trapped before the record is imported.  We would be less than truthful to state that we don’t have our challenges at times with IM, but experienced technicians overcome the technical requirements easily.

Specializing in ways to enhance your company’s solutions with Microsoft Dynamics GP in Idaho, Oregon, and Southwest Washington, with clients around the world, Computeration makes your implementation successful by offering experienced project management, data integration, training, and consulting services.

By Gloria Braunschweig with Computeration, a Pacific Northwest Microsoft Dynamics GP Partner

August 5, 2010 by Computeration

Email | Print

Ask The Author

Tags: Microsoft Dynamics GP 2010, Microsoft Dynamics GP Integration Manager, Pacific Northwest Dynamics GP Partner
Posted in About Microsoft Dynamics GP, ERP Software Information, Microsoft Dynamics ERP Functionality, Microsoft Dynamics GP 2010 | 3 Comments »

More Posts By Computeration

1. Microsoft 2014 Most Valuable Professional for Contributions to the Dynamics GP Community
2. Cost Center Accounting In QuickBooks versus Dynamics GP
3. Multi-user Capability of Dynamics GP Compared to QuickBooks
4. Top Features of Dynamics GP that will Convince You to Upgrade From QuickBooks
5. Dynamics GP 2013 New Financial Features—So Many Features, So Little Time

Related Posts

1. Three Ways to Enhance Customer Satisfaction with Microsoft Dynamics® GP
2. Get Data Faster in Microsoft Dynamics GP
3. Budgeting Made Easier in Microsoft Dynamics GP
4. Easy Navigation Options in Microsoft Dynamics GP (part 1 of 3)
5. 3 Tips to Help You Be Compliant with the Affordable Care Act within Microsoft Dynamics GP