Tag: X++

Working with Azure SQL from X++ using SQLClient

Microsoft Dynamics 365 Finance and Operations brings with it a whole data management framework that allows us to integrate with a database in Azure SQL in a totally standard way. This framework allows us to export ERP information to an external database for reporting (BYOD), so that we can generate our reports and dashboards in Power BI without having to attack the system database (AxDB), but… What happens if what I need is to read or perform other types of operations not allowed by this framework against an external DB? In this article I will show you a helper that […]

+Info

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

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

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

Manage Financial Dimensions in MSDyn365FO with X++

With the arrival of the version 2012 of Microsoft Dynamics AX there was an important change in the way in which the ERP manages the Financial Dimensions. The data model changed significantly and with it, the way we, as developers, managed and worked with them through X++. Dynamics 365 for Finance and Operations has been a continuist in this topic, and the way we work with them is practically the same. The main difference we found whit this change was that, while in the 2009 or earlier version we had limited the number of dimensions we could use in 10, […]

+Info