Truncate AxDB Transaction Log file

When you use the FnO for a while, you see how the transaction log file is growing. And you need to reduce it. Well, if you see how it is growing, then you probably need to configure Transaction Log backup. And you are lucky.

When you do not see how it grows and you are not lucky, you just see a red on the free disk space. And you understand that it’s your SQL AxDB Log file, that has 150 GB. And you have to truncate it somehow.

Call Microsoft Flow / Logic App from X++ code

This is a simple example of how to call external web services from D365FO without using any C# DLL files. Just plain X++ code. As sample External Web Service, I have selected Microsoft Flow. Azure Logic Apps will be similar.