This post focuses on the integration technologies available to have the Microsoft Dynamics 365 Finance Operations data available in Dataverse/Common Data Services/CDS. What could be better then having The biggest ERP system's data in Power Platform. You can Power Portals, Power Apps, Power BI analytical reports, use power virtual agents for inventory closing and year end closing processes, manage expenses and employee/contractors time entry processes, most of these processes can be even without logging to MS ERP (Dynamics 365 Finance Operation) so can safe on license cost too.
Let's see what options are available to integrate F&O data with Power Platform however, this post is dedicated to Virtual Entities.
3 Options available out-the-box to integrate F&O data with Power Platform;
Data Integrator - Click on link to read more
Dual-Write - Click on link to read more
Virtual Entities - MS Tech Talk on Virtual entities
Before we jump to the installation and configuration part, let's see when were the virtual entities available and what features these have come up with compared to other two integrations technologies.
Virtual Entities Generally available
️ Finance and Supply Chain Management App: 10.0.12 or later
️ Dataverse: Service update 189 or later
️ Finance and Operations is available as a data source in Dataverse
️ No Finance and Operations data replication in Dataverse
️ Access all public data entities of Finance and Operations in Dataverse
️ Support all CRUD operations
Head to this link https://appsource.microsoft.com/en-us/product/dynamics-365/mscrm.finance_and_operations_virtual_entity and Get it Now
Enter your work or school account and Sign in
Finance and Operations Virtual Entity solution shows as Enabled
Finance and Operations Virtual Entity solution is installed successfully - Hurray!! that was easy
The AAD application must be created on the same tenant as F&O.
Create a symmetric key for the application, Save and note it for later use.