Category: Electronic Reporting (GER)

D365FO Reports with Electronic Reporting: Sharing my solution to stop using SSRS for NEW reports.

5th September 2023

In this post and
video I’ll share my solution to implement easily new reports and I will explain too, how you can use it. Feel free to download it and adapt it to your projects too. It’s a generic solution where you will only have to extend (inherit) a few classes, create a parameter to refer the format to execute and a menu item. As simple as that, Check it out! … More D365FO Reports with Electronic Reporting: Sharing my solution to stop using SSRS for NEW reports.

D365FO Base enums in ER (Electronic Reporting) model mapping. ListOfFields and GetEnumValueByName Functions.

25th July 2023

Something very common and simple like binding Enum fields is a little more complex than what we might think initially, this is the way I found to deal with them and once you know it, it’s pretty straightforward. If you know better solutions for it, please let me know! … More D365FO Base enums in ER (Electronic Reporting) model mapping. ListOfFields and GetEnumValueByName Functions.

Electronic Reporting From Scratch part 4: Optimization of GER. FILTER vs WHERE and debugging your ER.

8th February 2023

Electronic Reporting, despite not being code based, is still development, and it deals with data whether it is used for reporting or for integration purposes, so performance is something to definitely take into acount. In this video we include the ER Perfomance into the table, bringing an example that will help us understand how data is loaded into the ER and to give the importance to the optimization that it really has. … More Electronic Reporting From Scratch part 4: Optimization of GER. FILTER vs WHERE and debugging your ER.

D365FO Electronic Reporting from Scratch part 3: Use of Parameters and Excel Format

16th January 2023

In this part, we are going to have 2 very different parts, in the first part we’ll see how to deal with user input data, and in the second one we are going to learn how to work with Excel format in ER, using an exporting example. … More D365FO Electronic Reporting from Scratch part 3: Use of Parameters and Excel Format

D365FO Electronic Reporting (GER) from scratch part 2: Export an XML

20th December 2022

In this Post we are going to see the step by step of how to configure everything needed to do an exporting process of the F&O Tables data into an XML file, without writing a single line of code, using GER (Electronic Reporting). This will give us some context of this widely used tool by Microsoft and will also help us to understand what it is and how to modify/duplicate existing OOB GERs as well of creating completely new ones. … More D365FO Electronic Reporting (GER) from scratch part 2: Export an XML

D365FO Electronic Reporting (GER) From Scratch part 1: Importing a text file

18th December 2022

In this Post we are going to see the step by step of how to configure everything needed to do an importing process of a text file into the F&O tables without writing a single line of code, using GER (Electronic Reporting). This will give us some context of this widely used tool by Microsoft and will also help us to understand what it is and how to modify/duplicate existing OOB GERs as well of creating completely new ones. … More D365FO Electronic Reporting (GER) From Scratch part 1: Importing a text file