Category Archives: Integration Manager

Integration Manager – Input String Was Not In A Correct Format

After installing Microsoft Dynamics GP in a new test system, I then installed Integration Manager and tried to run an integration to test.

After clicking the Run button the following message popped up:

Integration Manager: The destination could not be initialized due to the following problem: -Input string was not in a correct formatIntegration Manager: The destination could not be initialized due to the following problem: -Input string was not in a correct format

This error is typically one seen when Microsoft Dynamics GP is not running (I’ve seen it at a few clients running Citrix when they have Integration Manager running on one server and Microsoft Dynamics GP on another), but I had Microsoft Dynamics GP open in the background.

I quickly realised the problem; I had imported some modified reports into GP which contained VBA and to avoid an error I had right clicked and used Run as Administrator when starting Microsoft Dynamics GP, but had started Integration Manager normally.

This meant the two applications were running in different states and Integration Manager could not see Microsoft Dynamics GP.

To resolve the issue I closed Integration Manager and reopened it using the menu in Microsoft Dynamics GP (Microsoft Dynamics GP menu >> Integrate >> Integration Manager); this is the way I typically recommend clients open it in order to avoid this problem on Citrix XenApp or other ways of publishing applications.

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , | Leave a comment

Review of Microsoft Dynamics GP 2013 Implementation by Victoria Yudin

Victoria Yudin, the longest serving Microsoft(R) Most Valuable Professional for Microsoft Dynamics GP, has just released Microsoft Dynamics GP 2013 Implementation via Packt Publishing.

This is an update of the Microsoft Dynamics GP 2010 book she wrote a few years ago, which has been updated for Microsoft Dynamics GP 2013:

Microsoft Dynamics GP 2013 Implementation by Victoria Yudin

In brief this book covers:

  • Plan, install, and implement Microsoft Dynamics GP 2013 with real-world advice from a Microsoft Dynamics GP MVP
  • Learn how to set up the core modules in Microsoft Dynamics GP effectively following detailed, step-by-step instructions
  • Discover additional tools and resources available for your Dynamics GP

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft, Packt Publishing, Review, SQL Server | Tagged , , , , , , , , , , , , | 1 Comment

Integration Manager Error – Object Reference Not Set To An Instance Of An Object

Sometimes I find Integration Manager to be very trying. It can be a very useful tool but it can also be incredibly frustrating.

A client we have taken over support for logged a call about an integration they couldn’t run and hadn’t been able to run for a couple of months after their upgrade to Microsoft Dynamics GP 2010. The error message they were receiving was this;

Integration Manager - Object reference not set to an instance of an objectIntegration Manager – Object reference not set to an instance of an object

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , , , | 3 Comments

Review of Developing Microsoft Dynamics GP Business Applications – Part 1

At the end of December, Developing Microsoft Dynamics GP Business Applications, written by Leslie Vail and published by Packt Publishing was released.

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

I got a copy of the book in order to do a review and have decided to break the review down into multiple parts. The reason for this is that the book includes some practical examples which I have decided to do and then include the results of this in the review; after all if it is a book on developing how can you accurately review the book if you don’t use what you learn to build something?

The book is aimed at developers new to working with Microsoft Dynamics GP, so bear in mind that I am not a developer when reading my reviews. Quick synopsis of my background: I started my career as a trainee developer and moved through a variety of roles such as developer and support analyst before moving to my current position as consultant and project manager.

I oversee development teams working on additions or amendments to Microsoft Dynamics GP as well as personally undertaking some modifications using Report Writer or Modifier with VBA. So despite not being a developer, I am used to working with them and did, once upon a time, be one myself.

The first chapter of the book covers the Microsoft Dynamics GP Architecture from a high level perspective.

It covers the history of the GP interface from it’s origins with Great Plains Software, an overview of Dexterity and the development environment. There is a detailed explanation of the launch file (Dynamics.set), which included a couple of points of which I wasn’t aware, and the configuration/preferences file (Dex.ini).

The explanation of the Dex.ini file included the ExportOneLineBody switch which I didn’t know about, but for which I have an immediate use.

Leslie then goes on to explain about the structure of the tables in the SQL Database which always strikes newcomers as arcane and overly complex. Leslie explains this well with plenty of detail on both the structure, including both the physical and technical names, and how transactions move between tables as their state changes.

Chapter 1 wraps up with a detailed explanation of the UI covering how forms are constructed, how the scrolling windows work and the common buttons used on forms, scrolling windows and individual buttons.

The second chapter of the book focuses on the fundamentals of integrating applications with Microsoft Dynamics GP.

Continue reading

Posted in Dynamics, eConnect, GP, Integration Manager, Microsoft, Modifier with VBA, Packt Publishing, Report Writer, Software Development Kit, Visual Studio Tools For MDGP | Tagged , , , , , , , , , , , , | 3 Comments

Integration Manager 11 Installation Errors

Well, the old ones are often the best. I needed to install Integration Manager onto a system earlier and got an access denied error message the first time I tried to start it;

Integration Manager - Could not create all default application data due to the following error: - Access to the path 'C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0' is deniedCould not create all default application data due to the following error: – Access to the path ‘C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0′ is denied

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , | 3 Comments

How To Install Integration Manager 12

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.

Integration Manager is installed from the Microsoft Dynamics GP 2013 setup utility;

Microsoft Dynamics GP 2013 setup utility

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , , , | 1 Comment

Microsoft Dynamics GP and Schrödinger’s Cat

One of the points I make (repeatedly until I see a confirmation they’ve done so) to clients when implementing Microsoft Dynamics GP is that they need to make sure that a maintenance backup of the SQL databases and other resources are being made.

In some cases the maintenance backup is a once a night job, other clients have had one done every twelve hours with log backups made every hour. As long as a regular backup is being made I’m happy and stop nagging them.

Continue reading

Posted in Dynamics, Excel Reports, FRx, GP, Integration Manager, Microsoft, Reporting Services Reports, SQL Server | Tagged , , , , , , , , | 3 Comments

Microsoft Dynamics GP 2010 SP3 Has Been Released

On the Developing for Microsoft Dynamics GP blog, David Musgrave has posted an announcement that Microsoft Dynamics GP Service Pack 3 is now available.

As always with service packs to Microsoft Dynamics GP there are a multitude of downloads covering all the different related products to Dynamics GP itself such as Integration Manager and eConnect.

Continue reading

Posted in Dynamics, eConnect, GP, Integration Manager, Microsoft, Software Development Kit, Visual Studio Tools For MDGP, Web Services, Workflow | Tagged , , , , , , , , , , , , , , | 1 Comment

Error Running Integration Manager For The First Time

Well, they do say the old ones are the best. I recently installed Microsoft Dynamics GP on a client site and encountered the below error message when starting Integration Manager for the first time;

Integration Manager - Could not create all default data due to the following error: - Access to path 'C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0' is denied.

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , | 2 Comments

Integration Manager: “Argument ‘Start’ must be greater than zero”

A client doing some work with Integration Manager 10 recently reported the following error when trying to load the VB Script Editor;

Integration Manager - Argument

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , | 4 Comments