upgrades and data migration “things to know” – Stefano Demiliani
Dec11

upgrades and data migration “things to know” – Stefano Demiliani

Despite the Microsoft ERP proposition (on-premise vs SaaS), many customers are still full with doubts on what is the best choice for them: am I ready to switch to a fully cloud-based solution or do I need more time for this transformation? Can I switch to a fully SaaS environment at steps? What about data migration and platform upgrades? I’ve written an article for Simplanova… Continue Reading demiliani’s Article on their...

Read More
Using Azure DevOps for managing your Dynamics 365 Business Central projects – Stefano Demiliani
Dec05

Using Azure DevOps for managing your Dynamics 365 Business Central projects – Stefano Demiliani

All the people that were on my Dynamics 365 Business Central Development courses for Microsoft Italy (and that will be in the next months) already knows that one of the topic that I always I try to emphasize is related to source code management. Source Code Management (SCM) is a must to have when working with AL (code is now on files and not inside the database as in C/AL) and you… Continue Reading demiliani’s Article on...

Read More
Enabling Remote Powershell connections to a Dynamics 365 Business Central Azure VM sandbox – Stefano Demiliani
Dec03

Enabling Remote Powershell connections to a Dynamics 365 Business Central Azure VM sandbox – Stefano Demiliani

When developing with Dynamics 365 Business Central in teams, you could have in-place different sandbox environments for developing or testing and you can have the needs to deploy extensions to such environments in an automatic way. With an Azure-hosted D365BC sandbox (hosted on an Azure VM with a Docker container) you can publish extensions (.app files) also by using Powershell remotely… Continue Reading demiliani’s...

Read More
Dynamics 365 Business Central and Search timeout – Stefano Demiliani
Nov19

Dynamics 365 Business Central and Search timeout – Stefano Demiliani

Are you using Dynamics 365 Business Central on-premise and are you obtaining this error message when searching on a list? This is because your applied filters are returning a query result set with a too long execution time. With Dynamics 365 Business Central on-premise there’s a “not so well known” setting on the Database tab in the Business Central Server Administration tool… Continue Reading demiliani’s Article on their...

Read More
Dynamics 365 Business Central is here and you should join me! – Stefano Demiliani
Nov14

Dynamics 365 Business Central is here and you should join me! – Stefano Demiliani

Yes… Dynamics 365 Business Central appears on the list of topics of the main Microsoft developer-oriented conference in Italy. From 27 to 29 of November, at Centro Congressi Milanofiori in Assago (MI) the WPC 2018 Conference will start. As always, focus on development topics (.NET, Azure, etc) and infrastructure/databases, but this year also sessions for Dynamics 365 product… Continue Reading demiliani’s Article on their...

Read More
permissions for downloading symbols – Stefano Demiliani
Nov02

permissions for downloading symbols – Stefano Demiliani

Preface: Credits to this quick post goes to my friend Duilio Tacconi. Some partners are start using Dynamics 365 Business Central (on cloud or on-premise) by loading company data from NAV installations (manually with tools like Configuration Packages or by using the Intelligent Cloud for automatically create a cloud instance from an on-premise one). When you’ve finished to setup… Continue Reading demiliani’s Article on...

Read More
handling breaking schema changes on production – Stefano Demiliani
Oct26

handling breaking schema changes on production – Stefano Demiliani

I saw many requests on forums in the last days related to one of the most noisy topic when working with Extensions in Dynamics 365 Business Central (SaaS version): how to handle breaking schema changes. The tipical scenario is the following: You create an extension (version 1.0) that contains a custom table with some fields and some keys and publish it. All is ok. Then, you create a new… Continue Reading demiliani’s...

Read More
the impact for partners and developers (my article for Simplanova) – Stefano Demiliani
Oct16

the impact for partners and developers (my article for Simplanova) – Stefano Demiliani

As you already know, Microsoft Dynamics ERP’s family is having a big evolution this year. Microsoft Dynamics NAV is now the past, while the future is called Microsoft Dynamics 365 Business Central. Partners (and developers in particular) must be prepared for the change and in my opinion also all the management team of a classical NAV partner should know the change and shift… Continue Reading demiliani’s Article on their...

Read More
tips for best network performances – Stefano Demiliani
Oct15

tips for best network performances – Stefano Demiliani

Many months ago I wrote a series of posts related to best practices to remember when deploying Microsoft Dynamics NAV or Microsoft Dynamics 365 Business Central on-premise as IaaS with Azure. In particular: I’ve received lots of feedbacks and interests related to these posts and many of you were so kind to share with me their experiences. When talking about installing Dynamics NAV or… Continue Reading demiliani’s Article...

Read More
enabling in-client personalizations – Stefano Demiliani
Oct11

enabling in-client personalizations – Stefano Demiliani

If you are familiar with the user interface features of Microsoft Dynamics 365 Business Central in the cloud and now you have installed Microsoft Dynamics 365 Business Central on-premise, I think that you (or your consultants and/or users) could have discovered a difference in the on-premise web client compared to the SaaS version: why I don’t have the Personalize feature but only… Continue Reading demiliani’s Article on...

Read More
what happens to my third-party integrations? – Stefano Demiliani
Oct08

what happens to my third-party integrations? – Stefano Demiliani

In a real-world Microsoft Dynamics NAV implementations, is quite common to see integrations with third-party external applications. These integrations are normally based on three different technologies: Text file integrations (XMLPort) SQL integrations (direct access to SQL tables) Web Services or APIs integrations With Microsoft Dynamics 365 Business Central on-premise you have the same… Continue Reading demiliani’s...

Read More
why I can’t find my C/AL page on Search? – Stefano Demiliani
Oct03

why I can’t find my C/AL page on Search? – Stefano Demiliani

This seems to be a problem for many partners and developers that have start working with Dynamics 365 Business Central on-premise in these days and this is not actually well documented in my opinion. I think that you already know that when developing a page with the AL language extension for Dynamics 365 Business Central in the cloud, you need to set ApplicationArea and… Continue Reading demiliani’s Article on their...

Read More
licensing changes – Stefano Demiliani
Oct01

licensing changes – Stefano Demiliani

As you already know, today Microsoft has officially launched the general availability of Microsoft Dynamics 365 Business Central on-premise. This release introduces also an important change regarding licensing. As usual, we have two main licensing types: Perpetual Licensing: you license the software with permanent usage rights. Subscription Licensing: you license non-perpetual rights… Continue Reading demiliani’s Article...

Read More
Dynamics 365 Business Central on-premise released today – Stefano Demiliani
Oct01

Dynamics 365 Business Central on-premise released today – Stefano Demiliani

As announced at Directions NA, Microsoft Dynamics 365 Business Central on-premise is relesed today and it’s available on now Partnersource from this link. From Partnersource you can download the classic DVD package, but you have also the option to download it from Docker hub. With this latest release, Microsoft Dynamics NAV is renamed Microsoft Dynamics 365 Business Central on… Continue Reading demiliani’s Article on their...

Read More
how to start (my article for Simplanova.com) – Stefano Demiliani
Sep26

how to start (my article for Simplanova.com) – Stefano Demiliani

My friends of Simplanova kindly asked me to be a “guest blogger” on their website. The topic of this first technical post for them is about how to start moving an existing ISV solution based on C/AL to the new extension model. This is an hot topic nowadays and I think it’s also the step that every Microsoft Dynamics NAV partner will have to do in the near future to move their… Continue Reading demiliani’s Article on their...

Read More
why don’t you resize your Azure VMs? – Stefano Demiliani
Sep25

why don’t you resize your Azure VMs? – Stefano Demiliani

This post comes after spending two days working with some customers that have started to move all their on-premise infrastructure to IaaS on the Azure cloud. They have used Azure VMs for hosting their Microsoft Dynamics NAV databases and servers and they have sized the VMs by starting from my suggestion and increasing the size by 2 ? (“we want to move to Dynamics 365 Business Central… Continue Reading demiliani’s Article...

Read More
show/hide fields on pages – Stefano Demiliani
Sep17

show/hide fields on pages – Stefano Demiliani

Showing and hiding fields on pages based on conditions seems to be a very easy task for a classic NAV developer, but with Dynamics 365 Business Central and the AL extensions I see very very often that this is a source of hours spent on calling all the saints in paradise. In order to avoid disturbing the saints, I’ll try to describe how to do that in Dynamics 365 Business Central with a… Continue Reading demiliani’s Article...

Read More
using the Event Recorder for developing – Stefano Demiliani
Sep11

using the Event Recorder for developing – Stefano Demiliani

When you are developing an extension for Dynamics 365 Business Central and you need to interact with the standard Microsoft’s code, one of the hardest problem is detecting which event you can subscribe to (as you already know, you cannot modify standard code in the D365BC SaaS platform but you can only attach to events raised by the platform). For checking the published events and detect… Continue Reading demiliani’s...

Read More
publishing a web service from extensions – Stefano Demiliani
Sep05

publishing a web service from extensions – Stefano Demiliani

In these days I received a (not so common I think) request: how can I have an extension for Dynamics 365 Business Central that, when installed, it automatically published some pages as web services in D365BC? For doing this task, there are essentially two main methods: Create an Install codeunit and here create the web service instance by inserting a record in the Tenant Web Service… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central Development Quick Start Guide is out! – Stefano Demiliani
Aug27

Dynamics 365 Business Central Development Quick Start Guide is out! – Stefano Demiliani

At the beginning of this year I was preparing the content for the first of a serie of workshops for Microsoft Italy about developing extensions for Dynamics 365 Business Central and during this period I had an idea: why not writing a new book about developing for Dynamics 365 Business Central? Something like a manual that can guide a developer with the essentials from starting a… Continue Reading demiliani’s Article on...

Read More
loading Configuration Packages from AL – Stefano Demiliani
Aug22

loading Configuration Packages from AL – Stefano Demiliani

Today I’ve spent few times handling a (not so common I think) scenario where from an extension I need to be able to load a RapidStart package (.rapidstart file) to Dynamics 365 Business Central and apply it. As explained in my last post, in the cloud environment we need to use Streams for handling files and today I discovered (with pleasure) that Microsoft has modified some methods… Continue Reading demiliani’s Article on...

Read More
parsing a CSV file using CSV Buffer – Stefano Demiliani
Aug20

parsing a CSV file using CSV Buffer – Stefano Demiliani

A question received today was the following: is it possible from my extension in Dynamics 365 Business Central asking a user to select a local CSV file, load it and then managing the content accordingly to my business needs using CSV Buffer table? In standard NAV code (C/AL) you can use CSV Buffer table to load a CSV file (without using an XMLPort) and then parsing its content line… Continue Reading demiliani’s Article on...

Read More
Is Rapidstart too slow? This is the fix. – Stefano Demiliani
Aug16

Is Rapidstart too slow? This is the fix. – Stefano Demiliani

In an internal mailing list today was asked a question regarding Rapidstart packages in NAV 2018. Many users and partners (me too) have experienced a very slow data import with Rapidstart packages (despite the number of records to import), expecially if your database is quite big. I remember to have “unofficially” fixed this problem in my NAV 2018 databases and to have reported… Continue Reading demiliani’s Article on...

Read More
target levels in extensions development demystifyed – Stefano Demiliani
Aug14

target levels in extensions development demystifyed – Stefano Demiliani

When you develop an extension with Visual Studio Code and the AL language,  in the app.json file you can specify the target level of your extension. The available options are as follows: Here (in order of visibility): Personalization: it’s the lowest current level, only allows for inclusion of UI objects like Profiles/PageCustomizations. Extension: it’s the default level when… Continue Reading demiliani’s Article on their...

Read More
Execute a PATCH call from an Extension by using AL and HttpClient – Stefano Demiliani
Aug08

Execute a PATCH call from an Extension by using AL and HttpClient – Stefano Demiliani

If you work with REST APIs, you already know that you’ve two HTTP methods for updating resources: PUT: updates an entire resource PATCH: the update request only needs to contain the changes to the resource, not the complete resource. The AL language permits you to work with REST services by using the HttpClient class. If you declare an HttpClient object in AL, from Intellisense in… Continue Reading demiliani’s Article on...

Read More
noisy problem in UsageCategory and ApplicationArea related to Search – Stefano Demiliani
Aug03

noisy problem in UsageCategory and ApplicationArea related to Search – Stefano Demiliani

I’ve see many AL developers with the same problem when developing an extension for Dynamics 365 Business Central: they create a new table, then they create a new page based on that table, they set UsageCategory and ApplicationArea properties, they deploy the extension to Dynamics 365 Business Central with success, then they search for the newly created page and… it’s not… Continue Reading demiliani’s Article on their...

Read More
how to check in your Extension is running on a trial tenant – Stefano Demiliani
Aug02

how to check in your Extension is running on a trial tenant – Stefano Demiliani

An interesting question in an insider talk some days ago was how to check from AL code if my extension is running on a trial tenant or in a licensed tenant (paid). After a bit of searching inside our lovely C/SIDE, I’ve found the solution to the question: in Dynamics 365 Business Central there are two useful objects useful for that scope: Table Tenant License State… Continue Reading demiliani’s Article on their...

Read More
Dynamics 365 Solution Update Management live event – Stefano Demiliani
Jul31

Dynamics 365 Solution Update Management live event – Stefano Demiliani

A quick post to announce that Microsoft will hold a live webinar on the Dynamics 365 YouTube channel to help you and your customers get the answers to questions you may have. The link is: https://aka.ms/D365ReleaseCadenceWebinar Dynamics 365 Release and Update Cadence Time:  August 9th, 9a Pac (GMT-7) In this session, we will discuss the latest about the latest optimizations announced to… Continue Reading demiliani’s...

Read More
Overview of October ’18 Release – Stefano Demiliani
Jul23

Overview of October ’18 Release – Stefano Demiliani

The NDA regarding some topics is officially finished today and Microsoft has published an official document that answers many questions related to the Fall release of Dynamics 365 Business Central. You can start reading from here. If you want to directly go to the cool part, this is the link. ? Obviously, this is a work in progress. You can help improving Dynamics 365 Business… Continue Reading demiliani’s Article on their...

Read More
object prefix for AppSource extensions Q&A – Stefano Demiliani
Jul21

object prefix for AppSource extensions Q&A – Stefano Demiliani

Answers to a post-course question regarding object prefixes in extensions for AppSource: Object prefix must be registered with Microsoft (at least 3 digits) and must be unique (it’s globally reserved for you) It can be a prefix or a suffix (you can call an object XXXMyTable or MyTableXXX) You have to use it for every objects in your extension This is case insensitive (you can call an… Continue Reading demiliani’s Article...

Read More
Extension for printing external documents – Stefano Demiliani
Jul11

Extension for printing external documents – Stefano Demiliani

A week ago I wrote a post for answering a question regarding how to print external documents from Microsoft Dynamics NAV. This code is C/AL based and it uses DotNet classes that interacts with the local operating system. How can this code be translated as Extension for Dynamics 365 Business Central? For the SaaS version of Dynamics 365 Business Central, this is actually not possible. We… Continue Reading demiliani’s...

Read More
how to detect if your extension is running on a Sandbox – Stefano Demiliani
Jul04

how to detect if your extension is running on a Sandbox – Stefano Demiliani

During our Extension Development workshops for Dynamics 365 Business Central, some developers are start asking for scenarios where in my extension I need to detect if it’s running on a Sandbox environment or in a production one. From an extension, you can detect if it’s running on a Sandbox environment by using the Tenant Management codeunit (417). This codeunit provides a set of… Continue Reading demiliani’s Article on...

Read More
printing external documents and merging PDF files – Stefano Demiliani
Jul02

printing external documents and merging PDF files – Stefano Demiliani

These are old topics and someone has written on a solution for this in the past, but after some forum questions received today I think that a quick recap could be interesting. Question 1: how to print external documents directly from NAV There are scenarios where you need to print directly from NAV also external documents (like PDF, Word files or other things). For this task, in my personal… Continue Reading demiliani’s...

Read More
Using SQL Data Sync with Microsoft Dynamics NAV on-premise and Azure SQL Database – Stefano Demiliani
Jun20

Using SQL Data Sync with Microsoft Dynamics NAV on-premise and Azure SQL Database – Stefano Demiliani

In many Microsoft Dynamics NAV implementations we have situations where the NAV database is often “coupled” with a second database for business intelligence processing or other data manipulations/analysis. Often we use this scenario for handling Power BI data warehouses in the cloud (Azure SQL) that work by using data that comes from NAV, external sources, IoT devices and so on. In… Continue Reading demiliani’s Article on...

Read More
Microsoft Dynamics 365 Business Central and Advanced ApplicationArea – Stefano Demiliani
Jun11

Microsoft Dynamics 365 Business Central and Advanced ApplicationArea – Stefano Demiliani

A quick post to try making clarification about a topic that I see every day is quite confusing. Microsoft Dynamics 365 Business Central is not yet exposing all the controls that you’re used to have from Microsoft Dynamics NAV pages. These fields are not missing on the database tables and this is not a bug from Microsoft. In D365BC, many controls on pages are tagged with the… Continue Reading demiliani’s Article on their...

Read More
loading data in custom tables – Stefano Demiliani
Jun03

loading data in custom tables – Stefano Demiliani

Dynamics 365 Business Central (D365BC) is growing in popularity in these months and when a customer starts to move its business to the new SaaS platform, the first requested step is to move also their data. Unfortunately nowadays Dynamics 365 Business Central does not have an automatic tool for data migration from an on-premise NAV (I think this is a task that Microsoft should start… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central Extensions Development + NAV on Azure Workshop on Microsoft Italy (stage 2) – Stefano Demiliani
May23

Dynamics 365 Business Central Extensions Development + NAV on Azure Workshop on Microsoft Italy (stage 2) – Stefano Demiliani

After the full stage 1, I’ll wait you tomorrow again in Microsoft Italy in Milan for the second slot of this 2 day Solution Developer / Architect oriented workshop. We’re totally overbooked also tomorrow, so thanks for that (but we’ll have stage 3 in June if you’re lucky to find a seat). On stage with me in these 2 days we’ll have my friend Duilio Tacconi (MS Senior Support… Continue Reading demiliani’s Article on their...

Read More
use code analysis to prevent strange errors. – Stefano Demiliani
May21

use code analysis to prevent strange errors. – Stefano Demiliani

You’ve developed a marvellous ? extension for Dynamics 365 Business Central and tested it on your development sandbox without problems. Now, you try to deploy it to a production environment via the Upload Extension action on the Extension Management page and voilà: Publish operation failed. Details: Extension validation failed. View the error details for more information. What error… Continue Reading demiliani’s Article on...

Read More
Backup your NAV on-premise database to Azure Blob Storage – Stefano Demiliani
May17

Backup your NAV on-premise database to Azure Blob Storage – Stefano Demiliani

In these days we had an internal discussion with our marketing department in order to increase the Azure adoption of Microsoft Dynamics NAV customers that actually never thinks to use the cloud for their business. In my opinion, one of the first and easy way to start using some cloud services for a Microsoft Dynamics NAV customer is related to database backup. Ok, you’re a customer that… Continue Reading demiliani’s...

Read More
Developing NAV / Dynamics 365 Business Central Extensions with real-time collaboration – Stefano Demiliani
May09

Developing NAV / Dynamics 365 Business Central Extensions with real-time collaboration – Stefano Demiliani

At Build 2018 Microsoft has showed the new collaborative features introduced for Visual Studio and Visual Studio Code, called Visual Studio Live Share. With Visual Studio Live Share, you can share a collaborative session with your co-workers and start writing code together in real-time. Wonderful isn’t it? Why not test this feature with Visual Studio Code when developing AL Extensions for… Continue Reading demiliani’s...

Read More
Microsoft Dynamics 365 Business Central and the problems with the ApplicationArea tag – Stefano Demiliani
May01

Microsoft Dynamics 365 Business Central and the problems with the ApplicationArea tag – Stefano Demiliani

Some users have reported that in the actual online release of Microsoft Dynamics 365 Business Central there are some standard pages that seems not to work correctly or where fields are missing and standard work can’t be done. One example reported in these days is Purchasing Codes page. Search for this page in Dynamics 365 Business Central: and click on the provided link. The… Continue Reading demiliani’s Article on their...

Read More
Dynamics NAV and the strange FaultCode=InvalidSecurity error – Stefano Demiliani
Apr28

Dynamics NAV and the strange FaultCode=InvalidSecurity error – Stefano Demiliani

A quick post for answering a user question regarding an error when connecting to his NAV server instance using the Role Tailored Client. The error that appears is: The FaultCode = ‘InvalidSecurity’ error is sometimes tricky to understand. The first thing that you can think is checking the user credentials and the service tier account, but if you’re doing so you’re not on the… Continue Reading demiliani’s Article on their...

Read More
“Dynamics 365 Business Central + NAV on Cloud” Technical Workshop on Microsoft Italy – Stefano Demiliani
Apr26

“Dynamics 365 Business Central + NAV on Cloud” Technical Workshop on Microsoft Italy – Stefano Demiliani

I’ll have the pleasure and the honour to perform a 2 days Technical Workshop about Microsoft Dynamics 365 Business Central (plus many more other topics) for Microsoft Italy on May. The dates will be 3-4 May (first round) and 24-25 May (second round). The courses will be totally free of charge and targeted to NAV developers. All the sessions are now fully booked, we have many people… Continue Reading demiliani’s Article on...

Read More
in-client customizations – Stefano Demiliani
Apr20

in-client customizations – Stefano Demiliani

One of the coolest features of Dynamics 365 Business Central that for sure you’ve already seen in a classic demo is the in-client customization. When you access D365BC (and you’ve permission to do so) if you open for example the Customer Card and click on the top right gear, you have the option to personalize the user interface (customer card) directly in the browser: When clicking on… Continue Reading demiliani’s Article...

Read More
a quick clarification – Stefano Demiliani
Apr17

a quick clarification – Stefano Demiliani

In the past days many Microsoft Flow users noted that, when creating a new workflow connected to a Dynamics NAV 2018 entity, some triggers were missing. Yesterday the Microsoft NAV Team has written a post explaining the situation and this post has alarmed many Microsoft Flow users. The question that immediately comes out was: “Can I continue to use my actual workflows or my… Continue Reading demiliani’s Article on their...

Read More
GDPR features on Dynamics 365 Business Central and NAV 2018 CU 04: overview – Stefano Demiliani
Apr13

GDPR features on Dynamics 365 Business Central and NAV 2018 CU 04: overview – Stefano Demiliani

With the release of Microsoft Dynamics NAV 2018 CU 04, GDPR support in NAV 2018 goes to a step forward. The same features were available in the last days also in Dynamics 365 Business Central. I had the pleasure to see that features some months ago and provide feedbacks, in my personal opinion now the GDPR support is quite good and we can share the details with everyone (and you can share… Continue Reading demiliani’s...

Read More
NAV 2018 CU 04 is out… yes, with GDPR tools!
Apr12

NAV 2018 CU 04 is out… yes, with GDPR tools!

This update contains a big improvement on managing GDPR related tasks. The link for download are these: NAV 2018 – https://www.microsoft.com/en-us/download/details.aspx?id=56822 NAV 2017 – https://www.microsoft.com/en-us/download/details.aspx?id=56824 NAV 2016 – https://www.microsoft.com/en-us/download/details.aspx?id=56823 Continue Reading demiliani’s Article on their...

Read More
SQL Server on Azure VM best practices – Stefano Demiliani
Apr11

SQL Server on Azure VM best practices – Stefano Demiliani

When talking about Microsoft Dynamics NAV installed on Azure, we have mainly two choices: use an Azure VM with SQL Server installed or use Azure SQL. In the Azure-based NAV deployments I see every day, it seems that using SQL Server on an Azure VM is the choice where everyone are going or prefer. However, too often I see that the installation is done like an on-premise SQL or without… Continue Reading demiliani’s Article...

Read More
the strange behaviour that I hate… the – Stefano Demiliani
Apr09

the strange behaviour that I hate… the – Stefano Demiliani

Events in Microsoft Dynamics NAV (and in Dynamics 365 Business Central) are one of the best features of the platform ever. With events, you can now extend your business logic without modifying the original objects and events are the core for the new Extension model that we’ll use for Dynamics 365 Business Central. However, there’s a little strange behaviour regarding events that… Continue Reading demiliani’s Article on...

Read More
Disabling users to access NAV with specific client types – Stefano Demiliani
Apr05

Disabling users to access NAV with specific client types – Stefano Demiliani

Today on forums was out this question: how to disable access to Microsoft Dynamics NAV Web Client for specific users? Unfortunately there’s no a native function for disabling a user to access the NAV system with a specific client type (web, mobile, tablet and so on), but this can be easily handled with a customization.  My suggested way (valid also for Extensions) is to create...

Read More