The Integration Manager option and the Table Import option are not available in Microsoft Dynamics GP
This article provides solutions to an issue where the Integration Manager option and the Table Import option are not available in Microsoft Dynamics GP.
Applies to: Microsoft Dynamics GP
Original KB number: 2018994
The Integration Manager and Table Import options are grayed out within Microsoft Dynamics GP.
The incorrect registration keys for Microsoft Dynamics GP were entered, or Integration Site Enabler is not selected.
Security has not been granted to these menu options.
Microsoft Dynamics GP does not recognize that Integration Manager is installed.
The Dex.ini file does not contain the path to Integration Manager.
Resolution 1: Verify that Integration Site Enabler is selected
On the Help menu (the blue circle with a question mark in the upper-right), click About Microsoft Dynamics GP, and then click Options.
In the Module section, locate Integration Site Enabler and verify the Registered column shows a check mark for this item.
If you do not see this option checked, you may have the incorrect keys entered for you GP system. Check online through CustomerSource to verify that you have the correct keys entered.
As soon as you are at the CustomerSource Web site, mouse pointer over My Account and select Product & Service Summary from the pop-up menu.
When the new page loads, click the Registration Keys link for Microsoft Dynamics GP.
On the next page, select the version that you are looking up your registration keys for from the dropdown labeled "Display License Keys For Version".
Verify that "License Holder" on this page matches "Site Name" in the GP Registration window and that the Registration Keys on this page match those entered in the GP Registration window.
Resolution 2: Grant access to Integration Site Enabler
On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click User Security. Note the role(s) that are selected.
On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Security Roles.
Select the Role noted from step 1.
In the list of Security Task IDs, select ADMIN_SYSTEM_012.
Save the Role.
Alternatively, you can create a new role and assign ADMIN_SYSTEM_012 to this role also. In this case, you would use the Security Setup window to grant access to this new role for users in addition to the role(s) they already have assigned.
Resolution 3: Verify Integration Manager is listed in your Dynamics.set file
If it is not, locate the IM.cnk and then put this in the GP code folder then restart GP. The IM.cnk can be located in the following areas:
Integration Manager 2010
C:\Program Files\Common Files\Integration Manager 11
Integration Manager 10.0
C:\Program Files\Common Files\Integration Manager 10
Open the Dex.ini file in notepad. This file is found in the following default locations:
- Microsoft Dynamics GP 10.0: C:\Program Files\Microsoft Dynamics\GP\Data
- Microsoft Dynamics GP 2010: C:\Program Files\Microsoft Dynamics\GP\Data
Verify that the following lines exist:
The lines will point to:
Microsoft Dynamics GP 2010
- C:\Program Files\Microsoft Dynamics\Integration Manager 11\Microsoft.Dynamics.GP.IntegrationManager.exe
- C:\Program Files\Microsoft Dynamics\Integration Manager 11\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe
Microsoft Dynamics GP 10.0
- C:\Program Files\Microsoft Dynamics\Integration Manager 10\Microsoft.Dynamics.GP.IntegrationManager.exe
- C:\Program Files\Microsoft Dynamics\Integration Manager 10\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe
In order to access Integration Manager Conversions from within Microsoft Dynamics GP, you must create a shortcut in the Navigation area or use the shortcut created in the Start Menu.
To create a shortcut in the Navigation Area, follow these steps:
Right-click the upper-left section of the navigation area.
Select Add, and then click Add External Shortcut.
Click Browse and locate IM.exe or Microsoft.Dynamics.GP.IntegrationManager.exe, that can be found in the following default locations:
Microsoft Dynamics GP 2010:
C:\Program Files\Microsoft Dynamics\Integration Manager 10\Microsoft.Dynamics.GP.IntegrationManager.exe
Microsoft Dynamics GP 10.0:
Click Add and then click Done.
You will now be able to start Integration Manager on the Shortcut Menu in Microsoft Dynamics GP.