Resolving A Problem With The eConnect Integration Service Not Running

While I was working on the series of posts for how to install the Web Services for Microsoft Dynamics GP, I encountered a couple of problems which I thought it might be worth covering in this and the next post.

The first was to do with the eConnect Integration Service which is installed as part of the install of Web Services. The basic problem was that the service was not running;

Services - eConnect for Microsoft Dynamics GP 2013 Integration Service

Continue reading

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

How To Install Connector for Microsoft Dynamics GP – Integrate Data

This is the seventh post in the series on how to install the Connector for Microsoft Dynamics GP; the first six posts covered the prerequisites, installation, adapter configuration, creating a new integration, preparing data for integration and synchronise picklists.

Now that the Connector for Microsoft Dynamics has been installed and configured, the data has been prepared for integration and pickilists synchronised, the next step is to start running the integrations.

As an example, I’m going to step through the process of integrating the Unit of Measure Schedules from GP into the CRM Unit Groups.

In the Connector for Microsoft Dynamics (Start menu >> All Programs >> Microsoft Dynamics >> Microsoft Dynamics Adapter >> Connector for Microsoft Dynamics) navigate down to the UofM Schedule to Unit Group node (Home >> Microsoft Dynamics GP 2010 \ Microsoft Dynamics CRM 2011 >> Fabrikam, Inc. \ Fabrikam, Inc. >> Maps >> >UofM Schedule to Unit Group);

Connector for Microsoft Dynamics

Continue reading

How To Install Connector for Microsoft Dynamics GP – Synchronise Picklists

This is the sixth post in the series on how to install the Connector for Microsoft Dynamics GP; the first five posts covered the prerequisites, installation, adapter configuration, creating a new integration and preparing data for integration.

One of the things that needs to be done before integrating Microsoft Dynamics GP with Microsoft Dynamics CRM is to synchronise the CRM picklists with data in GP. This can be done using the supplied Microsoft Dynamics CRM Picking Sync utility which is installed along with the Connector for Microsoft Dynamics.

There is no menu item created for this utility, so you will need to open Windows Explorer and navigate to the installation folder (%ProgramFiles(x86)%\Microsoft Dynamics\Microsoft Dynamics Adapter) and double click the Microsoft.Dynamics.Integration.GpToCrmPicklistSync.exe;

Windows Explorer

Continue reading

How To Install Connector for Microsoft Dynamics GP – Preparing Data for Integration

This is the fifth post in the series on how to install the Connector for Microsoft Dynamics GP; the first four posts covered the prerequisites, installation, adapter configuration and creating a new integration.

In this post, I’m going to highlight an issue which bit me when I was creating this series of posts using the Fabrikam, Inc. demo company.

This isn’t an issue I’ve encountered in the wild, so to speak, but it is a difference in how Microsoft Dynamics GP and Microsoft Dynamics CRM handle Unit of Measure Schedules and Unit Groups respectively.

Microsoft Dynamics GP allows for Unit of Measure Schedules to have two UoM details of the same name. For example, the Fabrikam, Inc. Unit of Measure Schedule Wire contains Spool defined as both 100.00 Foot and 33.33 Yard;

Unit of Measure Schedule Setup

Continue reading

How To Install Connector for Microsoft Dynamics GP – Create A New Integration

This is the fourth post in the series on how to install the Connector for Microsoft Dynamics GP; the first three posts covered the prerequisites, installation and adapter configuration. This one will show the step-by-step process to create a new integration between Microsoft Dynamics GP 2010 and Microsoft Dynamics 2011.

To create a new integration between Microsoft Dynamics GP and Microsoft Dynamics CRM, open the Connector for Microsoft Dynamics from the Windows Start menu (Start menu >> All Programs >> Microsoft Dynamics >> Microsoft Dynamics Adapter >> Connector for Microsoft Dynamics).

To create a new integration, click the New Integration button on the toolbar;

Connector for Microsoft Dynamics

Continue reading

How To Install Connector for Microsoft Dynamics GP – Configure Adapters

This is the third post in the series on how to install the Connector for Microsoft Dynamics GP; the first two posts covered the prerequisites and installation. This one will show the step-by-step process to configure the Microsoft Dynamics GP 2010 and Microsoft Dynamics 2011 adapters.

To configure the adapters, open the Connector for Microsoft Dynamics program (Start menu >> All Programs >> Microsoft Dynamics >> Microsoft Dynamics Adapter >> Connector for Microsoft Dynamics) where you will be presented, on first run, the Adapter Settings utility which will be on the Activate new adapters page.

Enter the Integration Account (in my case DOMAIN\DynamicsConnector) and password and also the URL for the Microsoft Dynamics CRM Discovery Service.

The account being used for the Integration Account needs to be a valid CRM user with organization level read privileges for SystemUser (I usually do this by creating a role only with this one security privilege) on the organisations you’re going to integrate into. This user will be added to the following security roles by the configuration utility (which I’ll cover in a moment);

  • System Customizer
  • Dynamics Integration (this security role is automatically created)

The URL for my system is http://azc-crm1:5555/XRMServices/2011/Discovery.svc (your address can be found in Dynamics CRM under Settings >> Customise >> Developer Resources);

Adapter Settings - Activate New Adapters

Continue reading

How To Install Connector for Microsoft Dynamics GP – Installation

This is the second post in the series on how to install the Connector for Microsoft Dynamics GP; the first post covered the prerequisites.

When the Connector for Microsoft Dynamics GP setup utility is run, the first window is just a welcome screen, so click next;

Connector for Microsoft Dynamics - Welcome to the Connector for Microsoft Dynamics Setup Wizard

Continue reading

How To Install Connector for Microsoft Dynamics GP – Prerequisites

Over the last two or three weeks I’ve been doing a series of posts on how to install the Web Services for Microsoft Dynamics (prerequisites, installation, configuration, verification , security configuration, Management Tools installation and Management Tools configuration) leading up to this series of posts on how to install the Connector for Microsoft Dynamics GP in order to link Microsoft Dynamics GP with Microsoft Dynamics CRM. Web Services for Microsoft Dynamics GP is the major prerequisite for installing the Connector for Microsoft Dynamics.

Continue reading

Connector for Microsoft Dynamics GP

Connector for Microsoft Dynamics is a tool available from Microsoft which allows Microsoft Dynamics CRM to be integrated with one of the three Microsoft Dynamics ERP products; AX, GP and NAV.

Being a Microsoft Dynamics GP focused blog, it is the integration to Microsoft Dynamics GP I’m going to take a look at over the next couple of weeks or so depending on how quickly I get the posts written and published.

Connector for Microsoft Dynamics provides a two way integration between Microsoft Dynamics CRM and Microsoft Dynamics GP with the below diagram showing the entities which can be integrated from one system to the other;

Connector for Microsoft Dynamics

Continue reading