This blog will discuss the setup and integration concepts for the Common Data Service in Microsoft Dynamics 365 for Finance and Operations. The Common Data Service (CDS), in a nutshell, is the Microsoft Azure based business application platform that enables you to easily build and extend applications with business data through services such as PowerApps, Power BI, and Microsoft Flow.
For a more in-depth explanation of the CDS, visit Microsoft’s website here.
To create new Power Apps CDS projects, the following is needed, per Microsoft’s documentation:
1. Global Admin role in an Office 365 tenant with Dynamics 365 for Finance and Operations and Dynamics 365 for Sales.
2. KB4036524 – This hotfix enables sales order line synchronization with the Data Integration feature from Finance and Operations to Sales. (Done for Dynamics 365 for Finance and Operations DMO24.)
3. KB4036461 – This hotfix enables sales order synchronization with the Data Integration feature from Finance and Operations to Sales. (Done for Dynamics 365 for Finance and Operations DMO24.)
4. Dynamics 365 for Sales version 1612 (220.127.116.11) (DB 18.104.22.168) online or later.
5. Prospect to cash solution for Dynamics 365 for Sales, version 22.214.171.124 (v14) or later. (View more documentation.) (Done for Dynamics 365 for Sales Customer Engagement.)
6. Please see functional prerequisites in the Dynamics 365 Finance and Operations and Sales Integration Functional Guide Section of the document.
7. When creating new products in Dynamics 365 for Finance and Operations, use the Populate Distinct Product Table job. To do this, type “populate distinct product table” in the Dynamics 365 for Finance and Operations search drop down list. More information in the Dynamics 365 Finance and Operations and Sales Integration Functional Guide Section.
8. When creating new Sales Orders, you need the Calculate Sales Totals job. Go to Sales and Marketing à Periodic à Calculate Sales Totals. More information in the Dynamics 365 Finance and Operations and Sales Integration Functional Guide Section.
Create a New Common Data Service (CDS) Environment
To start using the CDS, create a new CDS environment. This is where the CDS database will reside, and where creating/configuring the templates required for the prospect to cash scenario and/or any custom templates needed takes place.
To create a new CDS environment, follow the steps below:
1. Sign in to https://admin.powerapps.com/environments OR
2. Sign in to Dynamics 365, and click the Admin icon.
3. Next, go to Admin Center, and choose Power Apps.
4. To create a New CDS Environment, click Environments > New Environment.
5. The New Environment form will come up. Complete the Environment Name and Region fields.
6. Click Create Environment. This process can take a while. Please note that the new CDS Environment process will create a new CDS Database for you, and it is created with sample data. Keep in mind that the creation of a new environment uses defaults for the CDS Organization (ORG0001), and it will use the default Dynamics 365 for Sales price list used in both the Products and Sales Order integration templates.
7. If you need to add a new organization, the Organization entity must be updated. To do so, access this link, go to the Preparing the Common Data Service section and follow the instructions on how to update the Organization ID. You will see something like below:
8. Security will have to be setup for the new Database. For this, click in to your new CDS environment, and click in the Security tab, and then set the Environment Roles, User Roles, and Permission Sets.
Working with a New Common Data Service (CDS) Entity
The CDS provides the ability to create and work with existing entities. An entity is like a table, and this is where you will be able to create fields, mappings, and business rules. An entity will be used when working with PowerApps projects.
To create a new CDS Entity, follow the below steps:
1. Sign in here.
2. If you want to work with a new entity, click Common Data Service > Entities > New Entity.
3. The New Entity form will come up. Add a Name, a Display Name, and a Description (Not required).
4. Click next, and then you will be able to add new fields, relationships, keys, etc.
Create a new PowerApps Project
PowerApps provides tools to create projects – called a PowerApps project. A PowerApps project will allow you to work with entities, and use them to create a solution for integration, data management, etc.
To create a new PowerApps project, follow the steps below:
1. To create a new PowerApp Project, go this link.
2. To create a new Project, you will need to create a new Connection Set (used to authenticate each environment – CDS, Operations, Sales or Customer Engagement). Please note that once you have created a new connection set with the chosen CDS environment, this can be used for other projects as well.
3. Click Data Integration and then New Project.
4. The New Data Integration Project wizards appears. At this point, you will be able to provide a Project Name.
5. Select a template. The available templates for Order to Cash are provided by Microsoft and they provide the integration to move data between Dynamics 365 for Finance and Operations and Dynamics 365 for Sales, vice versa, or an integration to only move data from the system of record to the CDS. For example, the templates Accounts (Sales to CDS), and Sales Quotes (Sales to CDS) are a good example of a system of record to CDS integration. NOTE: You don’t have to work with the out-of-the-box templates, you can create your own.
For more tips and tricks about the CDS and all things Dynamics 365, subscribe to our blog.