Tag: Electronic Reporting

Understanding Electronic Reporting Dependencies

I have for a while now meaning to write a blog post about dependencies in Electronic Reporting in Dynamics 365 for Finance and Supply Chain… and now I finally got a reason since I had a customer that needed to move ER configuration to a Cloud hosted Environment. In Tier2+ environments, you can do this by using the RCS repository but that is not possible for cloud hosted environments.

So I want to move ISO20022 Credit transfer (IE) to another environment.

In order to that we need to move all upstream dependencies. As you can see in the image there are different levels in the ER config. To move Level 3 we first need to create level one and two…

Otherwise we will get a Unresolved references left – Reference of the object ‘Object Name’ to the object ‘Model’ (GUID,version) cannot be established

Unfortunately I have not found the GUID useful here since I am not able to see the GUID anywhere in the UI (maybe someone who understands better can explain), but the version (61) gives us a hint. If we look at the ISO20022 Credit transfer (IE), we can see that it has a dependency to ISO20022 Credit transfer version 43.61

and if we look at ISO20022 Credit transfer version 43.61, it has a dependency to Payment model version 43

This means that we start with exporting and moving Payment model version 43.

Then we import it in the new environment

Then we do the same with ISO20022 Credit transfer version 43.61 and when that is done we repeat for ISO20022 Credit transfer (IE) version 43.61.13

Normally I do this by using the RCS repository but that is not possible for cloud hosted environments

Finding Electronic reporting files

I really like the fact that there is an entire reporting framework built in to Dynamics 365 for Finance and Operations.

Today I got a questions from a colleague about where the files generated by Electronic Reporting. Since I had not done this before I am documenting it here.

Go to Electronic Reporting Jobs for the correct legal entity

Select the job and click Show Files

Select the file you want and click Open

Links:
Electronic reporting (ER) destinations

Configuring a LCS Repository for Electronic Reporting in Dynamics 365 for Finance and Operations

In Dynamics 365 for Finance and Operations, Microsoft provides a large repository for Electronic Reports. These cover a lot of scenarios but for those scenarios that requires custom reports you can use LCS to store these in order to share them between environments.

This requires a configuration in D365

First you need to add a configuration provider:

  1. In D365FO search for “Electronic Reporting”
  2. In the right click Configuration Providers
  3. Click New, Give it a Name and a URL and click save
  4. Back in the GER Workspace select the new provider and click Repositories
  5. On the Configuration repositories screen click Add – LCS and Create Repository. Select the correct LCS project and click OK.
    Note: Sometimes you need to make a connection to LCS. To do that click “Click here to connect to LifeCycle Services”. This is done in a separate tab. When it is done switch back to the previous tab and click OK. If you get an error, try again.

    EDIT 2019-06-03 If you are not seeing the the option to select an LCS project at all, you will need to make a connection between Dynamics 365 FO and LCS. This is done in the System Administration – Setup – System Parameters – Help Tab.

    When you click the Help Tab you will see the option to authenticate to LCS. Click “Click here to connect to LifeCycle Services”. Authiorization is done in another tab.

    Close the new tab and click OK on the previous tab.

    Select your LCS project

    You will need to have a user in LCS that uses the same Azure AD credentials as the one you are logged into D365FO with.
    END EDIT

  6. To look at the reports in the repository, select it and click Open. You will see the reports stored in the LCS repository.

     

     

     

    7. You are also able to see them directly in LCS, in the Asset Library. If you are working as a consultant this report can then be saved to your personal Asset Library and shared with your colleagues

    8. To give your organization access to your custom report, go to the Shared Asset Library, select it and click Publish

     

     

Error importing Electronic Reporting Configurations

Hi…

Today we are looking at an issue that one of my colleagues had. This is actually an Application issue but I am writing it up for future reference.

When we are importing Electronic Reporting configuration in Dynamics 365 for Operation we get the following error:

clip_image001

Since it is a bit intermittent and works for some configurations we have suspected a timeout… we were on the right track… When speaking to Microsoft Support we got the tip to change a parameter in the configuration for Electronic Reporting to allow more multiple parallel threads for loading data:

image

Go to Organization administration – Workspaces – Electronic reporting – Electronic Reporting parameters and change Number of parallel threads to load data to 15 (the default is 5)

BR

Johan