Product: Dynamics GP (Standard/Advance) w/ eConnect

Article Link: http://help.truecommerce.com/en/articles/6433764-dynamics-gp-standard-advance-upgrading-gp


Notice


The below provided instructions are our general ruleset for upgrading or migrating a Dynamics GP system with the use of our Standard/Advance integration utilizing eConnect. TrueCommerce is not responsible for your server migration, and while we are able to assist in the process, require a 2-week prior notice for proper availability.

Installation of GP & eConnect


Prior to TrueCommerce being able to assist - you'll need to install or upgrade GP. You'll also need to install the additional component known as eConnect which comes with the installer for GP. If you are in need of assistance getting this installed, please contact your VAR

Installation of eConnect

  • Each version of GP has its own installation of eConnect (for example GP2015 and GP2018 each have their own version of eConnect that works with that specific version)

  • Required on all client machines

  • eConnect Service must have permission to SQL Server

Installation of the Integration Service (Server + All Clients)


The Integration Service primarily role is to communicate Dynamics GP with Transaction Manager (through the eConnect service) - however it also includes all the setup files for both the SQL Server as well as the GP Server.

ALWAYS BACKUP YOUR CURRENT DLL IF UPDATING AN EXISTING SERVER


Always backup the original Tc.Int.Platform.BSPDynamicsGP.dll to a safe location BEFORE installing the integration service or replacing the DLL manually

LOCATION: C:\Program Files (x86)\True Commerce\TmoIntegrationService\


First you'll want to download and install the Integration Service

Where to Download the Integration Service?

Running the Dynamics Integration Setup


Your system should automatically detect Dynamics GP if installed on the machine, and auto-prompt you with the Dynamics GP installation portion that is attached to the Integration Service - should it not; you can navigate to C:\Program Files (x86)\True Commerce\TmoIntegrationService\Dynamics

  • if the Dynamics setup.exe is missing - you can download it manually here

This will extract the SQL Stored Procedures to the TmoIntegrationService folder along with additional components to install (see below)

Creating the SQL Server's Stored Procedures - TM_DymanicsGP_db.sql


Once setup.exe is ran, you'll find a DynamicsGP folder within the TmoIntegrationService folder - with various subdirectories for each version of GP.

Execute the TM_DynamicsGP_db.sql on your SQL Server

  • These are the TrueCommerce Stored Procedures and do not modify any company/system tables

Creating the SQL Server's Stored Procedures - Extended


Once complete, you'll need to run the remaining 4 procedures located within your respective GP version subfolder (e.g: 2015 for GP2015)

  • WARNING : THESE OVERWRITE THE NATIVE DYNAMICS GP PROCEDURES - ANY CUSTOMIZATIONS WILL BE LOST - ALWAYS CONSULT YOUR VAR/IT IF YOU BELIEVE YOU HAVE CUSTOMIZATIONS

  • TrueCommerce is not responsible for any loss of customizations to these procedures

Run EXEC DmCreatProcs


Once all the Stored Procedures are ran from the folders, run your SQL Management software and run the command EXEC DmCreatProcs against your Dynamics GP Company database - which will complete the installation of all the generated Stored Procedures.

Install the ASN.cnk file (Clients)


Any client wishing to use the ASN module within TrueCommerce needs to install the dictionary for GP for the extended model - simply place the ASN.cnk inside the root installation folder for GP and run Dynamics GP with "Run As Admin" command - the system will prompt you to install new code, select yes to install the ASN module (recommend doing this as local admin)

Log in as the SA user within Dynamics GP and navigate to a Sales Transaction Entry (any will do, does not need to be an EDI specific order) and select Additional → ASN to let the module initialize - once complete any non-sa user should be able to easily launch this module without issue.

Update Transaction Manager Integration Options (Optional)


If you've moved to a new SQL Server, the Transaction Manager platform will need to be pointed to the new server. Log into Foundry and

Navigate: Business System section → Company Configuration → Integraiton Options

Fill: The SQL Server & GP Database sections

  • Server : The SQL Server path to your new server

  • GP Database: Name of the Company Database for GP

  • User: The user who will have access to the company database

  • Password: Password for user

8/3/22

Did this answer your question?