2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Data Flow of Bi-directional integration between MSCRM Online & Microsoft Dynamics GP is shown in the table below.

Image RemovedImage Added

Panel

Process Map

Process Map of Bi-directional integration between Dynamics365/MSCRM Online & Microsoft Dynamics GP is shown in the image below. 

Image RemovedImage Added

Panel

Pre-requisites for Integration

...

  • Setup and Configuration of eConnect Runtime Service for the Domain and User accessing GP database.

Panel
DBSync GreatPlains Integration Installation in Dynamics365/MSCRM Online

Creation of Custom fields in MSCRM

  1. Follow the steps to include DBSync fields into Form Editor.
  2. For the Account entity, two fields need to be created.
    • Go to Settings > Customize > Entities> Account > Create field > GP Id (Text field).
    • Go to Settings > Customize > Entities> Account Create field >Sync To Gp(Multiple Options) Picklist names-Sync,Synced,Not Synced.
  3. For the Product entity, two fields need to be created.
    • Go to Settings > Customize > Entities> Product > Create field > GP Id (Text field).
    • Go to Settings > Customize > Entities> Product Create field >Sync To Gp(Multiple Options) Picklist names-Sync,Synced,Not Synced.
  4. For the Invoice Header fields entity, three fields need to be created.
    • Go to Settings > Customize > Entities> Invoice > Create field > GP Id (Text field).
    • Go to Settings > Customize > Entities> Invoice Create field >Sync To Gp(Multiple Options) Picklist names-Sync,Synced,Not Synced.
    • Go to Settings > Customize > Entities> Invoice Create field > DBSync Error (Text field).
  5. For the Invoice Line Item fields entity, one field needs to be created.
    • Go to Settings > Customize > Entities> Invoice Line > Create field >DBSync GP Id (Text field).
  6. At this point, you have successfully completed the configuration of your Dynamics365/MSCRM Online instance for integration with Microsoft Dynamics GP.

...

Panel

DBSync Configuration

with Dynamics365/MSCRM Online &

for Microsoft Dynamics GP

  1. Login to www.mydbsync.com with your Username & Password.
  2. Once logged in, click on My Home from the Menu and click Launch.
  3. Once launched, you will be redirected to the DBSync Project page in the next tab.
  4. Click on the project Dynamics365/MSCRM OnlineGreatPlains: BiDirectional and then, click on Connectors on the left panel.You will see Salesforce and GreatPlains Connectors.on the Connectors menu.
  5. Click on Dynamic GreatPlains Connectors
  6. Click on GreatPlains Connector and enter the details as mentioned below:
    1. For GreatPlains
      1. eConnectPort : 18888.
      2. Data source: DESKTOPUSERNAME\MSSQLSERVER.
      3. Database name : <<GreatPlains Company Database name >>. 
  7. Click Save and Validate Connection to save and validate your GreatPlains adapter.
  8. Click on Microsoft CRM Connector. Enter your Microsoft CRM Enter your Microsoft Dynamics GP global administrator Username and Password. 
  9. In the above example, your server_name should be prefixed in place of the default value.
  10. Scroll down to the bottom of the section and click Validate Connection to validate your Microsoft Dynamics GP credentials and Save.
  11. If you are using it for the first time, click on the Activate option for screen appear. Enter your global Administrator Username, and accept the terms and conditions. Now users can connect to the Microsoft Dynamics GP account.

Panel

DBSync Configuration for Dynamics365/MSCRM Online

  1. Login to www.mydbsync.com with your Username & Password.
  2. Once logged in, click on My Home from the Menu and click on Development Studio.
  3. Once launched, you will be redirected to the DBSync Project page in the next tab.
  4. Click on the Connectors menu.
  5. Click on Dynamic365/MSCRM Online Connectors.
  6. Enter your Dynamics365/MSCRM Online global administrator Username and Password. Make  
  7. Make sure you modify the "Dynamics365/MSCRM Soap URL" according to the domain name provided to you by Microsoft at the time of registration for Microsoft Dynamics CRM Online application. A simple example is - Microsoft CRM Soap URL : https:// (https://**)<<server_name>/.
  8. In the above example, your server_name should be prefixed in place of the default value.
  9. Scroll down to the bottom of the section and click Validate Connection to validate your Microsoft CRM credentials. Then, click Dynamics365/MSCRM Online credentials and Save.
  10. If you are using it for the first time, click on the Activate button. A option for screen will appear. Enter your global Administrator Username, and accept the terms and conditions. You Now user can now connect to your MS online the Dynamic365/MSCRM Online account.
Panel

Running the integration

...