How To Install Connector for Microsoft Dynamics GP – Synchronise Picklists

Microsoft Dynamics GPThis is the sixth post in the series on how to install the Connector for Microsoft Dynamics GP; the first five posts covered the prerequisites, installation, adapter configuration, creating a new integration and preparing data for integration.

One of the things that needs to be done before integrating Microsoft Dynamics GP with Microsoft Dynamics CRM is to synchronise the CRM picklists with data in GP. This can be done using the supplied Microsoft Dynamics CRM Picking Sync utility which is installed along with the Connector for Microsoft Dynamics.

There is no menu item created for this utility, so you will need to open Windows Explorer and navigate to the installation folder (%ProgramFiles(x86)%\Microsoft Dynamics\Microsoft Dynamics Adapter) and double click the Microsoft.Dynamics.Integration.GpToCrmPicklistSync.exe;

Windows Explorer

When the Picklist Sync is opened it will connect using the configured adapters and default in the information it can.

In this example, I am synchronising Fabrikam, Inc. in GP to the same company in CRM and will synchronise all picklists except for the Salesperson To ERP System User. When ready to run the synchronise, click the Sync button;

Microsoft Dynamics CRM Picklist Sync

Before running the Picklist Sync utility will display a warning that picklists in CRM will have their values renamed if there is not a corresponding value found in GP. Confirm you want to continue with the syncing operation by clicking OK;

Warning - Proceeding with this utility will cause existing Picklist values in CRM to be renamed if there is no matching value found in GP. Continue with syncing operation?

You will need to enter details of a Microsoft Dynamics GP Web Service Super User Account (specified in the Dynamics Security Console) and a Microsoft Dynamics CRM Deployment Administrator to proceed;

Please Provide the required GP and CRM Credentials

After entering your user accounts in the last window, the Picklist Sync will display progress of the synchronisation before confirming completion;

Microsoft Dynamics CRM Picklist Sync

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

8 thoughts on “How To Install Connector for Microsoft Dynamics GP – Synchronise Picklists

  1. Greate series! I just wanted to add that this step is no longer required if using version 2.1.29.1 or greater of Connector for Microsoft Dynamics. We have removed the Picklist Sync Utility and replaced it with a map (Enumerated values To Picklist) that needs to be run first as part of the initial sync process.

  2. Ian Grieve says:

    Thanks, Chris for the update.

    I’ll check what version I was on and look to do an upgrade to get to the right version.

    Ian

  3. Naveed AbdulHameed Saqib says:

    Hi,

    This series of posts are awesome. I am facing a problem where I am not able to find the picklistsync utlity on my installation folder. Any guess to what could have gone wrong!

    Naveed Saqib

    1. Ian Grieve says:

      Hi Naveed,

      If you’re using a later version of Connector then as Chris pointed out the Picklist Sync has been removed and replaced with an item in Connector itself.

      Ian

Leave a Reply

Your email address will not be published. Required fields are marked *