Generate and Import Excel files with X++ in #MSDyn365FO

We all know that the management and integration that #MSDyn365FO brings as standard with Microsoft 365 products is very good, especially with Excel files. Even so, there are occasions when we have to develop our own code to generate files or to import them for different reasons, such as importing files with a specific format that does not conform to standard integration, or generating files for which we must do a series of previous calculations. For this reason, I have decided to share with you a class that I have developed. This class allows you to manage these files in […]

+Info

Dynamics Power Spain Online 2020

Last Saturday, June 13, Dynamics Power Spain Online 2020 took place. This event has become, in my opinion, the national reference event on Microsoft Dynamics 365 and Power Platform. For those who do not know it, it is the event previously known as Dynamics 365 Saturday, a totally free event held on a Saturday (obviously) at the Microsoft Iberica offices in Madrid. Last year, this event brought together more than 400 people from all over Spain, and even from abroad, who were able to enjoy an excellent day of community, surrounded by friends and colleagues. For many, this is a […]

+Info

Azure Key Vault & MSDyn365FO: Setup Certificates and Passwords

From time to time I have to configure the electronic certificate to be used in the SII (Immediate Information Supply) module and it always happens the same, I don’t remember exactly what I had to do. That is why I have decided to write this post, with a detailed step by step detailed so that I don’t have to spend more time googling how to do it, and hey, if I also help someone in the same situation, not that bad! This post will be divided into three main parts. The first two parts are, as I said, the ones […]

+Info

Dark Mode in Visual Studio for X++ Code Editor

UPDATE! Now that Visual Studio 2019 is working with the Dev Tools (unofficialy) you can download the settings I did for the X++ editor in dark mode also for this version: JATXppVS2019.vssettings. Microsoft also has improved the look and feel of the labels editor in dark mode (now is real dark mode 🤣). Dark mode is trendy. More and more applications and systems are offering this option: Twitter, Instagram, Facebook, Android …, and of course, for a long time, Visual Studio!. As you already know, the use of dark mode has certain advantages, such as energy saving, rest of sight, […]

+Info

Business Events: Custom payload (III)

This is the third and last article in which we are going to talk about how to send a JSON with a custom structure through Business Events. In the previous article we saw a possible way to identify those business events that should undergo this new structure through the event catalog. Today, we will finally see how to modify the structure of the message sent for these events. Modify the structure of the JSON sent through Business Events The first step is going to be defining the data contract to comply with the JSON format that we need to generate. […]

+Info

Business Events: Custom payload (II)

In the previous post we were talking about a solution that would allow us to customize the content and structure of the payload that is sent through Business Events drastically, so that we are able to adapt to a JSON format different from the standard of #MSDyn365FO, all this while still using the full power of this framework. Now, let’s move on to see in more detail the steps taken to reach this solution. As we mentioned in the last post, we will divide this solution into two different parts: Identify the events that must comply with the new format. […]

+Info

Business Events: Custom payload (I)

The purpose of this article is to talk about the posibility of changing the format or the structure of the JSON that is sent through a Business Event in the least intrusive and more reusable way possible, allowing at all times to use the power and robustness of the Business Event framework. I am currently participating in a project with a large number of integrations between different tools. In this project, it has been decided to use an Azure Service Bus Queue to manage the different events that each and every one of the tools generates. Due tu this large […]

+Info

Time to develop in #MSDyn365FO… And now what?

Well, I am a programmer with experience in Microsoft Dynamics AX, I have participated in several projects on versions 2009, 2012, R2, R3 … and finally, my company starts working on a Dynamics 365 for Finance and Operations project, and I think … And now what? First of all, let me clarify that my intention with this article is not to speak in conclusive terms, to impose my point of view or to reject that of others, on the contrary, with this article I would like to stimulate the curiosity of other colleagues, generate debate and put in doubt the […]

+Info

Tip: Consume Business Events Through Flow in Self-Service Environments

Self-service environments are here, and they are here to stay. If you don’t know what I am talking about or just want to have more details about this new type of deployments, you can take a look at this post written by my colleague Adrià a few months ago. As Adrià commented, in order to work and test this new type of deployment, it was necessary to sign up for a private preview, but this is no longer the case. In fact, the last two projects that we have started in Axazure already come with this type of deployments, and […]

+Info

Developing Business Events with X++

Continuing with our series about Business Events in Microsoft Dynamics 365 for Finance and Operations, it’s the turn to talk about the possibility of developing our own business events to be able to notify or interact with external applications in those cases that are not covered by the business events catalog. Before creating the Business Event itself, there are some topics we must take care about: Business events must be durable, that is, if an external application receive a notification because an action has occurred, this notification must be reliable. A transactional design must be made to ensure this aspect. […]

+Info