Microsoft Dynamics 365 Business Central and multiple cloud sandboxes – Stefano Demiliani
Apr09

Microsoft Dynamics 365 Business Central and multiple cloud sandboxes – Stefano Demiliani

The new April 2019 release for Dynamics 365 Business Central introduced lots of new features and one of the most interesting is for sure the possibility to have more than one online sandbox. With this new release (platform 14) you will be able to create up to three sandbox environments at a time per tenant (with different names) and: You can choose to create a sandbox based on the… Continue Reading demiliani’s Article on...

Read More
It’s time to evolve your ERP… – Stefano Demiliani
Apr08

It’s time to evolve your ERP… – Stefano Demiliani

Do you remember the Fiat Panda 30? It was released in the year 1980 and it was one of the best ever car models released from Fiat. Fiat Panda 30 was one of the most appreciated models ever expecially because: it was a rock it goes everywhere (you can use it as a city car but also as a tractor) it was simple to maintain it just works (ready for every usage) But today, do you ever want to… Continue Reading demiliani’s...

Read More
Bye Bye C/AL, welcome to the AL era… – Stefano Demiliani
Apr01

Bye Bye C/AL, welcome to the AL era… – Stefano Demiliani

This was in the air (Microsoft has clearly announced more than an year ago that in a year or so they will be ready to move their ERP codebase from C/AL to AL), something was under NDA and cannot be blogged but finally at Directions ASIA for the first time the plans were officially revealed in a clear way: April ’19 release (full of new features and with great improvements also in… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central CU04 and SOAP Web Services changements – Stefano Demiliani
Mar25

Dynamics 365 Business Central CU04 and SOAP Web Services changements – Stefano Demiliani

As you already knows, Microsoft has rolled up in these days the Cumulative Update 4 for Dynamics 365 Business Central. Unfortunately, there’s an (actually) undocumented breaking change that has affected lots of customers: if you have previously published some codeunits as SOAP web services, after this update if you try to reference your previously published web services you can’t… Continue Reading demiliani’s Article on...

Read More
online sandbox makes you crazy? Maybe remember these points. – Stefano Demiliani
Mar14

online sandbox makes you crazy? Maybe remember these points. – Stefano Demiliani

There are many areas in Dynamics 365 Business Central SaaS that are source of headaches for users and partners and I see often that one of that areas is the online sandbox environment. With this quick post, I want to try clearing some “foggy aspects” related to the online sandbox environment that I see every day and that generates noise and doubts/confusion: You can currently… Continue Reading demiliani’s Article on their...

Read More
Azure DevOps for Dynamics 365 Business Central projects – Stefano Demiliani
Mar11

Azure DevOps for Dynamics 365 Business Central projects – Stefano Demiliani

Together with Microsoft Italy, we’re pleased to announce an full day of Azure DevOps overview for Dynamics 365 Business Central developers and consultants. Event details and agenda can be found here. In the first part of the day we’ll see a full overview of the Azure DevOps features, while in the second part we’ll go in-depth about the DevOps features and strategies for… Continue Reading demiliani’s Article on their...

Read More
Using Dynamics 365 Business Central APIs in Microsoft Graph – Stefano Demiliani
Mar05

Using Dynamics 365 Business Central APIs in Microsoft Graph – Stefano Demiliani

2 days ago Microsoft has announced the availability of Dynamics 365 Business Central APIs in Microsoft Graph. Microsoft Graph is an interesting platform that permits you to have a unique gateway for REST APIs that spans across multiple Microsoft services (I’ve talked about it some days ago in my post about the interaction with Teams). Dynamics 365 Business Central is now one of the… Continue Reading demiliani’s Article on...

Read More
how to create extensions now? – Stefano Demiliani
Feb28

how to create extensions now? – Stefano Demiliani

As publicly announced yesterday, the February 2019 Developer Preview for Dynamics 365 Business Central launches the first public version of the application where all the base code is converted from C/AL to AL. If you open the old C/SIDE Development Environment, what you can immediately see is that you’ve only few system tables and system codeunits but no other application objects: how to create extensions now? – Stefano DemilianiBlog...

Read More
Dynamics 365 Business Central and Microsoft Teams integration part 2 – Stefano Demiliani
Feb26

Dynamics 365 Business Central and Microsoft Teams integration part 2 – Stefano Demiliani

About one week ago I’ve written a post on how to integrate Dynamics 365 Business Central with Microsoft Teams and after that post I’ve received a lot of questions (so surprised that the topic was so hot). My goal was to write a message to a Teams channel from Dynamics 365 Business Central because I think that (at least for my customer’s base) this is the most interesting and useful… Continue Reading demiliani’s Article on...

Read More
how to integrate them? – Stefano Demiliani
Feb20

how to integrate them? – Stefano Demiliani

Microsoft Teams is the new Microsoft’s collaborative platform for collaborative working and I’m quite sure that quite soon everyone of you will use this platform as a Skype replacement (at least for business). One of the request I’m receiving often is why Microsoft has not directly integrated Teams on Dynamics 365 Business Central. I agree, I think that this is something that… Continue Reading demiliani’s Article on their...

Read More
Moving an on-premise Dynamics 365 Business Central database to Azure SQL via Powershell – Stefano Demiliani
Feb07

Moving an on-premise Dynamics 365 Business Central database to Azure SQL via Powershell – Stefano Demiliani

If I have an on-premise installation of Dynamics 365 Business Central, can I move my database from a local SQL Server to Azure SQL by automating this task (no manual processing)? I’ve received this question in a forum some days ago and I remember that I had previously created a script for this task in the past. Today I’ve found it on my repos and it’s the time to share it 🙂 Moving… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central and direct printing – Stefano Demiliani
Jan29

Dynamics 365 Business Central and direct printing – Stefano Demiliani

This seems to be one of the hottest “problems” when using Dynamics 365 Business Central SaaS: actually you cannot directly print a document on a printer, but you need to open the PDF file and then print from the browser. This could be ok for documents or for other not so repetitive tasks, but it could be a problem on scenarios like warehouse or production and so on, where you need to… Continue Reading demiliani’s Article...

Read More
extensions disappeared in Sandbox environment – Stefano Demiliani
Jan24

extensions disappeared in Sandbox environment – Stefano Demiliani

I saw different tickets and questions related to the title’s topic in the last weeks and I think there’s the need for a clarification. I wrote a post some months ago by explaining the Dynamics 365 Business Central SaaS tenant upgrade process that Microsoft has in place (you can find it here) but there are some strange behaviours that start appear to partners and that must be… Continue Reading demiliani’s Article on their...

Read More
April 2019 release wave features – Stefano Demiliani
Jan21

April 2019 release wave features – Stefano Demiliani

Microsoft has revealed to the general public the new Dynamics 365 Business Central features planned to be released in the April 2019 wave (from April through September 2019). Here a quick summary of what to attend (so be prepared 😉 ): Web experience improvements: New shortcuts Work date settings Company indicator Totals for lists Improved search Advanced personalization… Continue Reading demiliani’s Article on their...

Read More
Object IDs things to know – Stefano Demiliani
Jan15

Object IDs things to know – Stefano Demiliani

I think that today everyone of you knows that with Dynamics 365 Business Central we have the following rules for Object IDs: 50.000-99.999: per tenant/customer customizations (no AppSource). 1.000.000-60.000.000: RSP range for partners that have an ISV solution for on premise / D365BC. When used in Business Central these extensions are obtained as apps from 

Read More
Storing sensitive data for your extension? Use the Isolated Storage! – Stefano Demiliani
Jan07

Storing sensitive data for your extension? Use the Isolated Storage! – Stefano Demiliani

This is a quick post to signal a “worst practice” I’ve see today in a partner’s extension. This extension needs to save some private data and the partner has decided to use the Service Password table for that scope. The Service Password table is a particular table (ID 1261, present also in NAV) with the following structure: This table was born in the NAV era for implementing the

Read More
a UI for managing your Dynamics 365 Business Central/Dynamics NAV containers – Stefano Demiliani
Jan03

a UI for managing your Dynamics 365 Business Central/Dynamics NAV containers – Stefano Demiliani

Do you know what Portainer is? In simple words, it’s a simple management solution for Docker and it consists of a web UI that allows you to easily manage your Docker containers, images, networks and volumes. All is based on a single container that can run on any Docker engine (Linux or Windows). Have you ever thinked on having something similar for Dynamics 365 Business Central?… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central End of year 2018 Survey – Stefano Demiliani
Dec29

Dynamics 365 Business Central End of year 2018 Survey – Stefano Demiliani

During this entire year 2018 the Microsoft Dynamics ERP family has changed (and you know that for sure) and Microsoft has pushed a lot for helping customers and partners to “change their mind” and embrace concepts like Cloud, SaaS and Extensions. The new ERP era has a name and it’s Dynamics 365 Business Central. During this year I had the pleasure to work with Microsoft Italy for a… Continue Reading demiliani’s Article on...

Read More
recommending extensions – Stefano Demiliani
Dec20

recommending extensions – Stefano Demiliani

There’s an interesting feature in Visual Studio Code that I see it’s quite unknown to all but that internally we use often when working with distributed teams: extensions recommendations. What is this? Everyone of you already knows that Visual Studio Code can become more and more productive if you add the right extensions for your work and your programming language. Visual Studio… Continue Reading demiliani’s Article on...

Read More
things to know – Stefano Demiliani
Dec17

things to know – Stefano Demiliani

I’ve written in the past how to use .NET assemblies in AL for your on-premise extensions and all is also officially documented here, but I think there are some tricky aspects that must be more explicited: In order to use your .NET assemblies (DLLs), in Visual Studio Code you need to set the assemblyProbingPaths option to point to the folders containing the assemblies that you will… Continue Reading demiliani’s Article on...

Read More
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: Dynamics 365 Release and Update Cadence In this session, we will discuss the latest about the latest optimizations announced to Dynamics 365 update policies: https://aka.ms/dynamics365updatesblog You will learn how your organization can benefit from...

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