Integrations

I’ve been configuring an integration in Integration Manager for a client recently to assist with an Intercompany Bank Reconciliation process. When we started discussing the integration I had taken a quick look at the sample Bank Transaction integration which ships with Integration Manager and had no problem.

As the project progressed and I created the Bank Transaction integration on the client’s server I encountered the below error:

I fiddled around without being able to identify a cause of the problem and, while I was doing this, found that the 37 transactions in the file had actually integrated despite the error message (an error in IM usually means the transaction or line will not be successfully integrated).

I brought a copy of the Integration Manager back to my test system and ran it on there and all of the files integrated without error.

The difference between my test system and the client’s system is that I have Microsoft Dynamics GP 2013 Service Pack 2 while the client is still on Service Pack 1.

In the medium term we will be upgrading the clients system to service pack 2, but in the meantime we’ll need to make do with increasing the number of permitted errors and accepting that an error will be displayed even as the transaction is integrated.

Microsoft Dynamics GP 2013 ships with a variety of other software such as Business Analyzer (about which I have posted the installation and configuration steps) and also one called Integration Manager.

Integration Manager is a utility which can be used to load data into Microsoft Dynamics GP on a manually basis. Data can be loaded from text file, XML or directly from a database using an ODBC connection. Integration Manager is a better option that the Table Import (Microsoft Dynamics GP menu >> Tools >> Routines >> Table Import) routine because it enforces data integrity.

Integration Manager in Microsoft Dynamics GP is available for implementation for 120 days after which it must be purchased as part of the Customization Pack (prior to Dynamics GP 2013 it could be purchased as part of the Integration Suite).

There are a two adapters available for Integration Manager; Dynamics GP and eConnect. The latter adapter requires another Microsoft product to be installed so this how-to will focus only on the former.

Amazon Books

Dynamics GP Community

Login

Map of Visits

Disclaimer

This blog and its content is provided "AS IS" with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages arising out of the use of, or inability to use, information or opinions expressed in this site and confers no rights.

The links in this blog may lead to third-party Web sites to provide access to third-party resources to assist you in finding other services and/or technical support resources. Information at these sites may change without notice and azurecurve is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.