Tag: D365FO

Developing unit tests in D365FO, Finance and Supply Chain summit 2023 event session

20th March 2023

Here you are the talk I gave in the Finance and Supply Chain summit 2023 event, organized by the Power Community in Lisbon. This session is an introduction to Unit tests focused in D365FO, where many (or almost all) the technical consultants and developers skip that good practice of software development. I hope you enjoy it as much as I did preparing, giving and editing the session. Thanks! … More Developing unit tests in D365FO, Finance and Supply Chain summit 2023 event session

Deep dive into X++ SysOperation: Sending form multi-selected records in the contract.

15th February 2023

In the YouTube video and in the post we are going to analyse a few wrong options to send form multi-selected records in the SysOperations data contract and to understand why they are not a good approach for making it in all the situations. Afterwards we are going to see the solution I would rather decide to implement. … More Deep dive into X++ SysOperation: Sending form multi-selected records in the contract.

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 SSRS Report parameters (Cell definitions) error

22nd January 2023

If you work with SSRS Reports, specially duplicating out of the box ones, you will probably have to deal with the parameters errors after restoring a dataset. This quick post will help you understand why is this happening and how to fix it, as it may not be straightforward and the errors are not self-explanatory. … More D365FO SSRS Report parameters (Cell definitions) error

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

Learning about D365FO dimensions, and how to get the description in a generic way in X++.

28th December 2022

This post-video is going to focus in the D365FO dimensions tables structures and how to get the descriptions for all your dimensions in a generic way, without having to go to the specific table in each case. … More Learning about D365FO dimensions, and how to get the description in a generic way in X++.

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