In one of my last development workshops for Microsoft Italy, when talking about Dynamics 365 Business Central APIs, I’ve done a small demo on how to retrieve data from APIs directly from a Powershell script and save those data in a CSV file. Due to a lack of time, I’ve not talked too much about that script but (attendees will remember that) it ended in the following way: This is a classical Windows 10 Toast notification, that automatically appears when something occours and it remains active in your notification’s area. Toast notifications  are a part of the new modern UI of Windows 10 which…

In a previous post I described how you can start building extensions for the upcoming Dynamics 365 Business Central Wave 2 release on top of the Microsoft’s System Application . Today I want to show you how you can directly customize the Microsoft’s Base Application (alias, the standard Microsoft codebase). This is a top request I receive every day on all the partners I met, but before starting this post, I want to put in evidence what I think (receiving this question so often is not a good sign): please avoid to do this as much as possible . From the Wave 2 release, Microsoft will permit you…

I have several Azure SQL databases (mainly Microsoft Dynamics NAV databases) on different Azure subscriptions and often I need to download a backup for some of them. Yesterday I’ve decided to automate this process by using Powershell and the Azure REST APIs (in particular the Database – Export API ). I want to have a Powershell scripts that connect to an Azure SQL Database, creates a backup (.bacpac) and download it on an Azure Storage account (Blob container). I’ve to admit that I was thinking that this task was quite easy to do, but instead I’ve spent few hours on this. The tricky part…

Microsoft Dynamics 365 Business Central Wave 2 release date is just around the corner and there are many aspects of which you should be aware. I’ve written an article for my Simplanova ‘s friends that summarizes some important technical aspects to take care. You can read it at the following link: https://simplanova.com/blog/dynamics-365-bc-wave-2-release/ Just a quick summary here: AL only: the application is splitted into two main apps called Base Application and System Application . System Application is a modular extension and every module exposes a publicly accessible interface…

Do you remember this post ? I wrote it long time ago to explain what happens on SQL Server when you create a new table or you customize an existing table with an AL extension: the new table is created by appending the extension’s ID to the table’s name and also the customization to a standard table creates a new table with the primary key of the original table plus the newly added fields and also with the extension’s ID in the name: dbo.[CompanyName$TableName$ExtensionID] What happens now in Dynamics 365 Business Central Wave 2 release? As you already know, all the standard business logic…

As you already knows from this official Microsoft post , with Dynamics 365 Business Central Wave 2 release Microsoft has splitted the application into two main modules: Base Application (that contains all the ERP business logic) and System Application (that contains all the system layer). Separation between business and system layers is a first step for a future goal to have an application always more modular.  There’s also an interesting aspect to consider: imagine that your solution creates a totally new module for Dynamics 365 Business Central, totally independent from the Base Application…

An interesting question pops out yesterday: with Dynamics 365 Business Central on-premise , how can I programmatically check if a particular extension is installed or not? The standard Powershell command (in the Microsoft.Dynamics.Nav.Apps.Management  module) that gets informations about an extension in a specified Business Central Server instance is the Get-NAVAppInfo cmdlet (more info about it here ). Here I’ve executed Get-NAVAppInfo on one of my Dynamics 365 Business Central on-premise instances in order to check the status of a particular app: $ServerInstance = "MyServerInstance" $AppName…