Integration with Microsoft Dynamics 365 finance and operations with field service and sales

This blog illustrates, integration between dynamics 365 finance and operations and dynamics 365 sales and field service apps. We will focus on how CDS (Common data services) can be used to integrate data management and monitor batch activities.

Prerequisites

  1. To establish connection between multiple apps, firstly the user need to have global administrator role for the tenant.

  2. Minimum version details for dynamics applications Dynamics 365 finance and operations V 8.0 build number 8.0.30.8020 with Platform Update 15 (7.0.4841.35234) and above Dynamics 365 for Field Service version 1612 (9.0.1.733) (DB 9.0.1.733) online or a later version

Let’s deep dive to get apps connected and run through few features which are pretty much useful and out of box.

Login to Dynamics 365 finance and operations as global administrator.

Dynamics 365 finance and operations integration

Click on dynamics 365 task pane and search for PowerApps. Click on PowerApps.

Dynamics 365 finance and operations integration

On the PowerApps, task pane

Click on Data Section, Click on Connections

Under this section, PowerApps will list all the connected apps for data integration.

Click on New Connection

Dynamics 365 finance and operations integration powerapps connections

PowerApps will list all the apps where we can just connect and start using data integrations. Most of the apps are out of box.

Click on dynamics 365 app

Authenticate with valid credentials

Once authentication is successful, the selected app would be listed on connections.

Click on profile and navigate to admin center

PowerApps admin center Dynamics 365 finance and operations integration

Once you are landed on admin center, Navigate to Data integration and then connection sets

PowerApps Connection sets dynamics 365

Before starting with projects and templates establish the connection sets so that apps connectivity is established.

Click on New connection and enter the details from and to environments the data integration should take place.

Connection sets dynamics 365 PowerApps

Under Organizations input your legal entity details where the data has to be synchronized. Multiple legal entity mapping can also be setup under connection sets.

Note: - The environments details will be listed when the current login user is assigned with global administrator.

Once the connection is successful the connection will be listed on the connection sets

Dynamics 365 finance and operations integration Connection sets

Upon connecting, next proceed to start creating project for the template required, custom templates can be added.

Dynamics 365 finance and operations integration Default templates

Select the connection created

Once the connection is selected, the next key element is to setup the mapping between fields where data has to be synchronized

Mapping Dynamics 365 fields

Click on the --> Arrow to deep dive field level details and change the filed mapping or remove field’s mappings

Dynamics 365 finance and operations integration Fields mapping

On the scheduling tab, the best feature here is recur every, notifications this is pretty much helpful or administrator to oversee the batch jobs frequency and error if any encountered.

Dynamics 365 finance and operations integration Scheduling batch jobs

Email notifications will be sent on each execution with details on the records processed

Click on refresh entities to refresh the mapping changes.

Click on advanced query to filter and enable the advanced query features

The same overview can also be monitored on Dynamics 365 operations on the batch jobs.

Dynamics 365 finance and operations integration system administration

Hope this blog helps you to get started.

Thank You

Nagendra Varma K
Consultant Microsoft Dynamics 365 Finance and Operations
untitled.png
  • msdyncomm-stayconnected_banner_0810
  • Blogger Social Icon
  • LinkedIn Social Icon
  • YouTube Social  Icon
Search By Tags
  • Facebook Black Round
  • Google+ - Black Circle
  • Tumblr Black Round