How To Install Connector for Microsoft Dynamics GP – Synchronise Picklists

Originally posted on azurecurve | Ramblings of a Dynamics GP Consultant.

This 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 DynamicsMicrosoft 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

This entry was posted in Connector for Microsoft Dynamics, CRM, Dynamics, GP, Microsoft and tagged , , , , , , , , , . Bookmark the permalink.

One comment on “How To Install Connector for Microsoft Dynamics GP – Synchronise Picklists

  1. Pingback: How To Install Connector for Microsoft Dynamics GP – Synchronise … : Interesting Findings & Knowledge Sharing

Leave a Reply

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


* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>