Hands On With Microsoft Dynamics GP 2016 R1: eConnect Installation

● Ian Grieve ●  ● 5 Comments  ● 

Microsoft Dynamics GPMicrosoft Dynamics GP comes with a number of different integration tools such as eConnect and Integration Manager. In this post, I’m going to step through the installation of eConnect so that the eConnect adaptor will be available to Integration Manager.

To install eConnect, launch the setup utility, under Additional products select eConnect:

Microsoft Dynamics GP 2016 Setup Utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: eConnect Installation

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

eConnect Adapter Error In Integration Manager

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPA recent upgrade of a client from Microsoft Dynamics GP 2010 R2 to GP 2015 R2 recently resulted in an issue being found when testing some integrations in Integration Manager:

DOC 68 ERROR: eConnect error - The source was not found, but some or all event logs could not be searched.  To create the source, you need permission to read all event logs to make sure that the new source name is unique.  Inaccessible logs: Security.

The problem was a fairly simple one in that the eConnect service account did not have the necessary permissions; a very similar issue to the one I blogged about in March 2013.

The solution is to add the service account to the Local Admins group; instructions are in the post I linked above.

● Categories: Dynamics, eConnect, GP, Integration Manager, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

eConnect Incoming Queue In Microsoft Dynamics GP 2015 Does Not Work

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPI did an upgrade of a client from Microsoft Dynamics GP 2010 R2 to Dynamics GP2015 recently and encountered a problem with eConnect.

This particular client uses the eConnect incoming queue to integrate journals and payables invoices into Dynamics GP from a housing management system.

After installing eConnect and configuring the incoming queue I set about doing a test to ensure it was working.

Unfortunately, it didn’t.

Continue reading → eConnect Incoming Queue In Microsoft Dynamics GP 2015 Does Not Work

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Messages Submitted To eConnect Disappearing

● Ian Grieve ●  ● 1 Comment  ● 

Microsoft Dynamics GPI had an issue to deal with for a client recently where messages submitted to eConnect were no longer appearing in Microsoft Dynamics GP. I did the usual things of checking the Windows Event Log and ensuring that the two eConnect services were running.

One item I tried was to submit a test message to eConnect which worked fine; so it worked for the perfectimage user I was logged in as, but no-one else. I eventually found the answer in the Properties of the econnect_incoming queue:

eConnect_incoming Properties

The permissions for the perfectimage account (Full) were still configured correctly, but, somehow, the Send Message permission on Everyone had been removed. Once this setting had been added back, people were able to submit messages to the queue without further problem.

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Integration Manager eConnect Incorrect Address Or SOAP Action

● Ian Grieve ●  ● 4 Comments  ● 

Microsoft Dynamics GPI was recently creating an integration for a client to load some Purchase Orders into Microsoft Dynamics GP using Integration Manager. I added the source and destination adapters and then did the destination mapping. However, when I tried to run the integration I got the following error message:

DOC 1 ERROR: There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations that could accept the message. This is often caused by an incorrect address or SOAP action. See InnterException, if present, for more details.
DOC 1 ERROR: There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations that could accept the message. This is often caused by an incorrect address or SOAP action. See InnterException, if present, for more details.

Continue reading → Integration Manager eConnect Incorrect Address Or SOAP Action

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Error Installing eConnect

● Ian Grieve ●  ● 4 Comments  ● 

Microsoft Dynamics GPA recent install of eConnect ran into a small issue; after the installation was complete, the eConnect service wouldn’t start. In the Windows Event Log there were two errors shown:

eConnect Error

Continue reading → Error Installing eConnect

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Resolving A Problem With The eConnect Integration Service Not Running

● Ian Grieve ●  ● 5 Comments  ● 

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 → Resolving A Problem With The eConnect Integration Service Not Running

● Categories: Dynamics, eConnect, GP, Microsoft, Web Services ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Review of Developing Microsoft Dynamics GP Business Applications – Part 1

● Ian Grieve ●  ● 3 Comments  ● 

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 → Review of Developing Microsoft Dynamics GP Business Applications – Part 1

● Categories: Dynamics, eConnect, GP, Integration Manager, Microsoft, Modifier with VBA, Packt Publishing, Report Writer, Software Development Kit, Visual Studio Tools For MDGP ● Tags: , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Connector for Microsoft Dynamics GP

● Ian Grieve ●  ● 0 Comments  ● 

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 → Connector for Microsoft Dynamics GP

● Categories: Connector for Microsoft Dynamics, CRM, Dynamics, eConnect, GP, Microsoft, Web Services ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP 2010 SP3 Has Been Released

● Ian Grieve ●  ● 1 Comment  ● 

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 → Microsoft Dynamics GP 2010 SP3 Has Been Released

● Categories: Dynamics, eConnect, GP, Integration Manager, Microsoft, Software Development Kit, Visual Studio Tools For MDGP, Web Services, Workflow ● Tags: , , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●