Electronic Reporting (ER) Cookbook 2: new tips from the kitchen

by Eugen Glasow

Since my last blog in 2017 a few things have changed. The developers in Moscow have been extending the module massively, and they seem to have fully embraced the Continuous delivery approach. Every new version or hotfix bears surprises, both pleasant and unpleasant. Here is a small personal excerpt:

  1. Configurations may be declared dependent on a particular application version or even hotfix. Should the developer of a configuration have failed to declare a dependency, the following message may appear on an attempt to import the configuration: “Method parmXXX not found in class ERxxx”, for example “Method parmERTextFormatExcelTemplate not found in class ERTextFormatExcelFileComponent”. It means the configuration definition cannot be de-serialized from an XML file in this old application version.
  2. From version 7.3 onward, parts of the application logic of the ER module have been extracted to the Microsoft.Dynamics365.LocalizationFramework .NET assembly for better performance. Now not only the configuration relies on a particular application version, but the application too demands a certain binary hotfix. For example, the SEPA camt.054 bank statement requires application hotfixes KB4096419, KB4092831, KB4089190, KB4077379, while the designer UI will not start without the ER cumulative update KB4090174 i.e. binary version 7.0.4709.41183
  3. From version 7.3 it is possible to create inbound electronic formats i.e. those reading files instead of writing them. In 7.2 you could to configure the same, but it was simply failing to work properly. It was not going to give you any errors but to fail traversing records in the CSV file.
  4. Since version 7.2 it is possible to define a Sharepoint folder destination (Organization administration > Electronic reporting > Electronic reporting destination). Consider the following scenario: the electronic report runs in a batch and saves files in a Sharepoint folder. A client-side process synchronizes the folder with the local network, and a local daemon picks up the files to push them through a legacy banking software or a tax authority middleware.
  5. When reading or writing data in D365FO, the ER is able to scan 1:n and n:1 table and entity relations for foreign keys. However, your new tables and entities are not going to appear under the Relations node of the data model mapping in the Designer, as the ER module maintains its own list of table relations in the database. Even worse, it may import and run a custom configuration with no errors but silently skip the custom table on reading and writing. Apply Organization administration > Electronic reporting > Rebuild table references to make your custom tables available.
  6. When developing or customizing configurations, it is not necessary to Complete the versions every time to test them. The ‘integration point’ e.g. a payment journal may execute the latest Draft version of the format too. Use the button Advanced settings / User parameters / Run settings, then flip the Run draft slider that appears.
  7. After upgrading to 7.3 you may find yourself not able to edit configurations anymore. The reason may be the new parameter Enable design mode available at the Electronic reporting workspace, form Electronic reporting parameters.
  8. It seems that they’ve protected configurations made by Microsoft from editing in one of the recent updates. Instead, you are supposed to always derive a configuration from the base one, and assign it a custom Provider. This corresponds to the extension paradigm as opposed to ‘overlayering’ of a configuration. Now, what are you going to do with your existing customized formats? Create an own provider (Organization administration > Electronic reporting > Configuration provider table), give it a name and a web address of your organization. Make this provider Active at the ER workspace. Export your configuration into an XML file, then delete it from the list of solutions in ER. Replace the XML tag <ERVendor Name="Microsoft" Url="http://microsoft.com" /> with your provider, then re-import the configuration from the file. The system creates a new Draft version you are now able to edit.
  9. 2 responses to “Electronic Reporting (ER) Cookbook 2: new tips from the kitchen”

    1. Eugen Glasow says:

      Hi Luetter! The method is not present in 7.1 indeed. The class has become a closed-code assembly in 8.1 and the method is absent too. I.e. they only introduced it 7.3 ER Rollup 3, and then killed in 8.0 right after :-0. I bet you have 2 options:

      1) Try to install the rollup KB4090174 and the binaries etc. I mentioned in the blog. This is going to be quite a quest.
      2) Open the configuration in Notepad and remove the XML node referring to “parmERTextFormatExcelTemplate”. Then try to import, edit and fix any issues with regards to the Excel template reference. You have it on the first node, first screen of the format editor.

      Regards, Eugen

    2. Luetter says:

      Hi,

      i got the first error in my applikation (“Method parmERTextFormatExcelTemplate not found in class ERTextFormatExcelFileComponent).

      What can i do to solve this error?
      we use the following applikation: 7.3 with PU 20 (Versoion) 7.0.5030.35338.

      Best regards

      luetter

    Leave a Reply

    Your email address will not be published. Required fields are marked *