D365FO Electronic Reporting real export to Excel example: AllItemsQuery, ListDistinct, ListJoin

Post link with the step by step: https://fernitudela.dev/2023/11/08/d3... Timing: 0:00 Introduction 1:45 Creation Of Model 3:20 Creation Of Model Mapping 7:15 ALLItemsQuery function 12:05 ListDistinct function 16:28 ListJoin function 17:51 Finishing MM binding 19:13 Adding Invoice Id calculated field 26:40 Creating Format 27:34 Creating Excel template 35:49 Importing Excel Template and Mapping Format 38:23 Final result! 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!