Product: Dynamics Great Plains Enterprise (GPE)

Article Link: http://help.truecommerce.com/en/articles/11885045-dynamics-gp-standard-advance-upgrading-integration-service-from-v1-to-v2

As the Legacy Integration Service (V1) comes to an end it is recommended to upgrade your Dynamics GP solution to utilize the Advance Integration Service (V2) using the below guide in order to avoid unnecessary steps that could potentially prevent your Business Process from operating.

Typically when upgrading the Integration Service the system will automatically attempt to bring your Dynamics GP integration to the latest version which requires full local admin access, as well as the System Administrator (SA) access to your SQL Server - by following this guide you can work around needing to run SQL Scripts.

The Integration Service and the Dynamics GP Integration are two separate layers from one another and for the most part act independently of each other. While the Dynamics GP Integration does require the Integration Service in order to operate the actual version of the Dynamics GP Integration is not strictly tied to the version of the Integration Service.

Upgrading the Dynamics GP Integration is an advanced operation that requires the execution of SQL Scripts directly within your SQL Server (via SQL Server Management Studio) along side matching the latest Dynamic Link Library (DLL) for the Dynamics GP Integration.

This process requires that you backup the Dynamic Link Library (DLL) from your Legacy Integration Service (V1) installation as well as cancel out of the Dynamics GP Integration - Installation Wizard to properly perform the switch with minor interruption.

During the installation of the Advance Integration Service (V2) the system will automatically prompt you to begin upgrading the Dynamics GP Integration via a secondary installer - be sure to cancel this installation to avoid issues

To begin - you'll first need to first shut down the Legacy Integration Service so that it stops attempting to process files while you backup, remove the old service, and install the latest one.

Open: Window's Start Menu

Type: Services

Select: Run as Administrator

Within the Windows Service window locate the Transaction Manager Integration Service and stop it to shut down the Integration Service.

Locate: Transaction Manager Integration Service

Right Click: Stop

Before you begin removing the Legacy Integration Service (V1) you will want to grab a copy of your old Dynamics GP Integrations files so you can place them within the new Advance Integration Service (V2) after upgrading. Preventing you from needing to modify your SQL Database which requires elevated permissions.

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

Locate: Tc.Int.Platform.BSPDynamicsGP.dll

Right Click: Copy

Paste: in a safe location outside of the TmoIntegrationService folder

You will need to follow the below article in its entirely, ensuring that you delete the ProgramData files as well as restarting the Windows Machine fully prior to installing the Advance Integration Service (V2)

Once you've completely removed the Legacy Integration Service (V1) by uninstalling, deleting the ProgramData\TrueCommerce data, and restarted the machine you can begin installing the Advance Integration Service (V2).

You can download the Advance Integration Service (V2) through the Integration Settings screen within Transaction Manager, selecting the Option 2 option and then using the Download Integration Service link.

Navigate: Integration Settings

Select: Option 2 (for recommended Advance Integration Service)

Select: Download Integration Service

Once the Advance Integration Service (V2) has downloaded you will want to run the installer as an administrator to ensure proper installation.

Locate: TmoIntegrationServiceV2.exe installer

Right Click: Run as Administrator

Follow the prompts for the installer to get the the Integration Service installed onto the machine.

After the first installer has completed - if the Integration Service detects Dynamics GP installed on your machine, it will automatically launch the Dynamics Integration GP - Installation Wizard which you will want to cancel out of rather than run to avoid needing to run the SQL Scripts which add complexity to the installation.

Select: Cancel on Dynamics GP Integration - Installation Wizard

After the Advance Integration Service (V2) has been installed, you will need to replace the BSPDynamicsGP.dll within the new Integration Service folder with the original copy of your DLL backed up previously.

Stop the Transaction Manager Integration Service once again (since it'll auto-start after installation)

Open: Window's Start Menu

Type: Services

Select: Run as Administrator

Locate: Transaction Manager Integration Service

Right Click: Stop

Navigate: C:\Program Files (x86)\True Commerce\TmoIntegrationServiceV2

Paste: The original Tc.Int.Platform.BSPDynamicsGP.dll you backed up previously

Select: Yes to Overwrite (if prompted

Often when transferring a DLL from one location to another, Microsoft Windows will block it for security reasons. Especially when transferring over a Network. Be sure to confirm the DLL is not blocked

Right Click: Tc.Int.Platform.BSPDynamicsGP.dll

Select: Properties

Check: Unblock (if present)

Once the BSPDynamicsGP.dll is in place - simply start the Integration Service again to restore functionality.

Open: Windows Services

Locate: Transaction Manager Integration Service

Right Click: Start

rev 7/30/2025