Dynamics 365 for Sales (CRM) Initial Setup and Synchronization with Dynamics 365 for Financials


Hello,

We’ve had many questions on setting up and synchronizing data between Dynamics 365 for Financials and Dynamics 365 for Sales (CRM), so we hope these videos will help with the process.

Watch the first video below for step by step instructions on the initial setup of Dynamics 365 for Sales (CRM) with Dynamics 365 for Financials:

Tips for initial setup:
  1. In your Company Information window in Dynamics 365 for Financials your User Experience needs to be set to Suite.
  2. Setup requires 2 users set up in Office 365
    1. An integration user (needs to be assigned to both Dynamics 365 for Financials and Dynamics 365 for Sales)
    2. A CRM Administrator (the user who originally set up Dynamics 365 for Sales)
  3. During the Assisted Setup when entering users, the Integration User should be entered first and the CRM Administrator second.

In the next video, located below, I discuss steps and tips on synchronizing data between Dynamics 365 for Financials and Dynamics 365 for Sales (CRM):

Note: At the end of this second video Item synchronization is briefly mentioned, please note that Item/Product synchronization is really designed to go from Financials to CRM.  You can synchronize Items/Products from CRM to Financials, but only the Item Name will synchronize over to Financials:

Tips for synchronization:
  1. Use the Microsoft Dynamics CRM Connection Setup window to define how synchronization occurs.
  2. Synch Job Queue Entries button:
    1. Use to Set Jobs on Hold when making changes and then to Restart the jobs when changes are complete.
    2. Set the No. of Minutes between Job runs
      Note: It is a best practice to set jobs on “hold” when making changes to the way jobs are ran
  3. Integration Table Mappings button:
    1. Define to Synch only coupled (matched) records.
    2. Define templates to use for default data, these need to be setup prior to selecting in this window.  To create a template, search for ‘set up templates’ and open “Set Up Customer/Vendor/Item Templates”, for example, to see Configuration Template List and then under Actions click New to create your own template.
  4. General Rules for synching data:
    1. For Customers and accounts
      Synch salespeople with Dynamics CRM users first
    2. For Items and resources
      Synch units of measure with Dynamics CRM unit groups first
    3. For Items and resource prices
      Synch customer price groups with Dynamics CRM prices first

What can be synched between Dynamics 365 for Financials and Dynamics 365 for Sales (CRM):
CRM Record Financials Record Direction
Account Customer Bi-directional
Contact Contact Bi-directional
User Salesperson From CRM to Financials; can also be manually coupled
Product Item/Resource From Financials to CRM
Transaction Currency Currency From Financials to CRM
Unit Group Unit of Measure From Financials to CRM
Sales Order Sales Order From CRM to Financials; orders may originate in CRM. These are written across to Financials.
Sales Invoice Posted Sales Invoice From Financials to CRM; orders that originated in CRM may be invoiced and posted in Financials. That will update the order status in CRM as well as send the historical (posted) invoice across from Financials to CRM.

Comments (0)

Skip to main content