Dynamics 365 Finance: Import Electronic Reporting Configuration from Dataverse
Overview
This post expands on a Microsoft Learn article, which gives instructions for configuring Dataverse to allow import of Electronic Reporting configurations to Dynamics 365 Finance: Import Electronic reporting (ER) configurations from Dataverse
Prerequisites
There is one prerequisite for the ER configuration import, you must configure the ER import in the integrated Dataverse environment, so you must have it deployed. Setup instructions are here: Connect finance and operations apps with a new Microsoft Dataverse instance
Import Steps
There are 3 main steps to import ER configuration:
- Configure Dataverse Security in the integrated Dataverse environment
- Import Globalisation Studio in the integrated Dataverse environment: Install from App Source here
- Import the ER Configuration in the Dynamics 365 Finance environment: Import configurations from Dataverse
As the import steps are straightforward, this post will focus on the steps required to configure security in Dataverse to enable the D365 Finance app user to use the import functionality.
Dataverse Security Configuration Steps
Open the Power Portal Admin Centre.
Browse to environments.
Select the environment integrated with the D365 Finance environment where you need the Electronic Reporting configurations, and open settings.
Under Users + permissions, open Security roles.
Click the New role button.
Name the new security role something appropriate, for example Electronic Reporting Config Import.
Select the business unit for the user. This is probably the default business unit for the environment, rather than one of the D365 Finance linked legal entities.
Leave the other settings as default.
Next, you need to add permissions to the role for the following tables:
- Electronic Reporting Configuration File
- Electronic Reporting Configurations Index File
- Globalization Feature File
- Globalization Features Index File
With the new role open, for each table, go to the search box and search for the table name.
For each of the four tables above, you need to add the following permissions for Organization
- Create
- Read
- Write
- Delete
- Append
- Append to
- Assign
- Share
There is a quicker way than setting each permission individually.
Click on the menu beside the table name, and select Permission Settings.
In permission settings, select Full Access to assign the full set of required permissions, at organization level.
After repeating for all 4 tables, return the the environment settings page and click users.
Find the user who needs to import Electronic Reporting configuration into D365 Finance, and go to Manage security roles.
Assign the new security role you created earlier, if you used the name from the example it will be called Electronic Reporting Config Import.
Summary
You have now created, configured, and assigned a security role to a D365 Finance user in the integrated Dataverse environment, if you already installed Globalisation studio via App Source, the user can now go ahead and import ER configuration to D365 Finance.