Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the eConnect Service configured, the next step is to configure the Incoming Queue.

This configuration change is done in the eConnect_Incoming.exe.config file which is located, by default, in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service\Incoming Service:

Windows Explorer

Continue reading “Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue”

Hands On With MDGP 2018 RTM: Configure eConnect Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With eConnect installed on the server, there are a couple of pieces of configuration which need to be done. The first is covered in this blog post, and that is the configuration of the eConnect Service.

Perfect Image maintain and support a Dexterity Extension written by a company which is no longer a Microsoft Dynamics partner; this customisation receives transactions via eConnect from an external line of business system. The default configuration results in timeouts if the eConnect service isn’t configured to receive large messages; which basically means adding the following to the Microsoft.Dynamics.GP.eConnect.Service.exe.config file:

receiveTimeout="infinite"

To add this element to the bindings node of the configuration file, open Windows Explorer and navigate to the file in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service.

Edit the node so it looks like the below and then save the file:

Notepad

Stop and restart the eConnect service to ensure the change is picked up.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

Hands On With MDGP 2018 RTM: Install eConnect on Server

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the eConnect prerequisites configured or installed (as appropriate), eConnect can now be installed on the server. eConnect is installed from the setup.exeRun on each one as it appears:

Click Install on the Microsoft Dynamics GP 2018 Bootstrapper Setup:

Microsoft Dynamics GP 2018 Bootstrapper Setup

Continue reading “Hands On With MDGP 2018 RTM: Install eConnect on Server”

eConnect 18 Prerequisites: Set Service Install MSMQ Triggers

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I am in the middle of a series of Hands On posts. As part of thsat series, I am about to cover the installation of the eConnect additional product on a server configured for receiving messages via the MSMQ. However, there are two prerequisites which need to be dealt with before eConnect can be installed on the server.

Usually, when doing Hands On posts, I only cover the core installs and only mentioned prerequisites such as this, referring back to old posts were necessary, but it appears I’ve only made references previously to what you have to do, without actually blogging about it. So, this series on the eConnect prerequisites, is going to be a brief diversion from the Hands On series, which will resume tomorrow.

The eConnect 18 Prerequisites series index can be found here.

Before eConnect can be installed and configured to receive messages from the Microsoft Message Queue, the Message Queuing Triggers need to be installed. This is done via Server Manager:

Click Add roles and features link:

Server Manager

Continue reading “eConnect 18 Prerequisites: Set Service Install MSMQ Triggers”

eConnect 18 Prerequisites: Set Service Account as Local Administrator

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I am in the middle of a series of Hands On posts. As part of thsat series, I am about to cover the installation of the eConnect additional product on a server configured for receiving messages via the MSMQ. However, there are two prerequisites which need to be dealt with before eConnect can be installed on the server.

Usually, when doing Hands On posts, I only cover the core installs and only mentioned prerequisites such as this, referring back to old posts were necessary, but it appears I’ve only made references previously to what you have to do, without actually blogging about it. So, this series on the eConnect prerequisites, is going to be a brief diversion from the Hands On series, which will resume tomorrow.

The eConnect 18 Prerequisites series index can be found here.

Before installing eConnect, the service account it will run under needs to be configured as a local administrator. Do this by launching the Computer Management Control Panel applet.

Expand the following nodes in the navigation tree:

  1. System Tools
  2. Local Users and Groups
  3. Groups

Double click on the Administrators group in the central list of groups:

Computer Management - System Tools  - Local Users and Groups - Groups

Continue reading “eConnect 18 Prerequisites: Set Service Account as Local Administrator”

eConnect 18 Prerequisites: Series Index

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I am in the middle of a series of Hands On posts.

As part of that series, I am about to cover the installation of the eConnect additional product on a server configured for receiving messages via the MSMQ. However, there are two prerequisites which need to be dealt with before eConnect can be installed on the server.

Usually, when doing Hands On posts, I only cover the core installs and only mentioned prerequisites such as this, referring back to old posts were necessary, but it appears I’ve only made references previously to what you have to do, without actually blogging about it.

So, this series on the eConnect prerequisites, is going to be a brief diversion from the Hands On series, which will resume tomorrow.

eConnect 18 Prerequisites
Set Service Account as Local Administrator
Set Service Install MSMQ Triggers

GP Table Reference Updated for GP 2018 plus First ISV Products Added

Microsoft Dynamics GP Table ReferenceI have now fully updated the azurecurve|GP Table Reference for Microsoft Dynamics GP 2018 RTM as well as adding the first few ISV products

A total of six new products have been added during the latest update.

Standard modules added are (I’m not entirely sure why these hadn;t already been added, but assume it is to do with them being more focused to the UK market; certainly DDR is):

  1. Direct Debits & Refunds (8811)
  2. Scheduled Installments (1150)

The added ISV products are:

  1. Advanced Bank Reconciliation (2440) from Nolan Business Solutions
  2. Extender (3107) from eOne Solutions
  3. MIS-AMS Extensions (3459) which is now maintained by Perfect Image, but not generally commercially available.
  4. SmartList Builder (3830) from eOne Solutions

I am going to be adding additional ISV products to the site as well, look for lighter tiles ; if you work for an ISV, or use ISV products, and want the tables added to the GP Table Reference, please get in touch with details of what you want adding.

The Mekorma products are currently on my list of the next ISV products to be added.

991 Tables Added to GP Table Reference

Microsoft Dynamics GP Table ReferenceEither Microsoft have added a hell of a lot of new tables to Microsoft Dynamics GP 2018 RTM or I had a lot more missing tables on the azurecurve|GP Table Reference than I thought I did (I knew the Email tables were missing).

I know I have added the tables for five missing products:

  1. Advanced Security
  2. Analysis Cubes for Excel
  3. Excel-Based Budgets
  4. Report Scheduler
  5. Technical Service Tools

However, overall there was 991 tables added to the site, suggesting a lot of missing tables have been added, as I know these five products do not have that many tables.

I am going to be adding ISV products to the site as well, look for lighter or darker blue tiles (I’ve not yet decided on the colour); if you work for an ISV, or use ISV products, and want the tables added to the GP Table Reference, please get in touch with details of what you want adding.

Hands On With MDGP 2018 RTM: Integration Manager First Run

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With Integration Manager now installed, the final step in it’s installation is to run it and enter the license key.

It is important that the first time Integration Manager is launched, you do so by right clicking and selecting Run as Administrator; this ensures that Integration Manager has sufficient privileges for writing the necessary registry entries.

When Integration Manager starts, you will be presented with a Register Now/Later window; to use Integration Manager, a licence key must be entered, so click Register Now:

Integration Manager: Register Now

Continue reading “Hands On With MDGP 2018 RTM: Integration Manager First Run”

Hands On With MDGP 2018 RTM: Install Integration Manager

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

If you are going to be using Integration Manager with eCOnnect Adaptors, make sure eConnect has been installed on the client before following the steps in this post.

To install Integration Manager, launch the setup utility from the installation media:

Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

And, under the Additional Products header, select on Integration Manager and click Install on the popup menu:

Microsoft Dynamics GP 2018 setup utility

Continue reading “Hands On With MDGP 2018 RTM: Install Integration Manager”