Category: D365FO

D365FO ER (GER): Error while evaluating expression…

15th January 2024

In this post (and you have the video version of it in YouTube), we are going to understand why this pretty common error happens, giving us the tools to see what is wrong, and troubleshooting the error. We are going to see 2 different examples, first didactic one, made out by me to force the error and help us understand it, and second one, a real ER error from the OOB BAI2 Bank statements, that I had to face lately in a project. … More D365FO ER (GER): Error while evaluating expression…

D365FO Electronic Reporting complete real export to Excel example: Use of AllItemsQuery, ListDistinct and ListJoin

8th November 2023

In this video/post we are going to go through the requirement of exporting all the CustInvoiceTrans with the related header and lines charges. This is a real requirement example that I chose because I find it very didactic, since given the table structure I was forced to use and understand the functions AllItemsQuery, ListDistinct and ListJoin. I also take advantage of this example to explain again how to export data to excel, generating myself the Excel template with the ranges and everything. Check it out, it is a good opportunity to continue strengthening your ER abilities! … More D365FO Electronic Reporting complete real export to Excel example: Use of AllItemsQuery, ListDistinct and ListJoin

D365FO Reports in ER. Destinations with direct execution or Print Management for Business Documents.

25th September 2023

In this post we are going to explain how to configure the Electronic Reporting Destionations to convert a report to PDF, send it to the archive, send it by email, etc. You have also this video where I configure and explain it for our report used in previous videos/posts and for a Business document report in the print management destinations. … More D365FO Reports in ER. Destinations with direct execution or Print Management for Business Documents.

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.

Handle FK relations (RecID) in D365FO data entities and use of Composite data entities.

3rd July 2023

Handling Foreign key relationships in the Data Entities is a basic issue that you might be solving wrongly. Also knowing the power of the Composite data entities can help you insert data of multiple tables with FK relationships in a single call. Check the post out! … More Handle FK relations (RecID) in D365FO data entities and use of Composite data entities.