D365 Business Central : StringConversionManagement Codeunit
There are lots of Management Codeunit in D365 Business Central. Let us talk about one of them which is StringConversionManagement Codeunit. There are currently four procedures in this Codeunit that you can call:– WindowsToASCII– GetPaddedString– RemoveDecimalFromString– RemoveNonAlphaNumericCharactersLet’s look at it one by one. WindowsToASCIIThis procedure is used to convert text into… Continue...
Dataverse Virtual Table Creation Wizard (preview)
If someone of you was at Directions EMEA in Hamburg and attended the “Real world solution architecture with Dynamics 365 Business Central and Power Platform” session I made with Josh Anglesea, when explaining the implementation details of our business case there was a part related to connecting external data sources to our Dataverse environment via Virtual Tables. One of these external sources… Continue Reading...
Dynamics 365 Business Central and Power Automate connector: using environment variables
When working with Dynamics 365 Business Central using the Power Automate connector, when you sleect its actions and triggers you need to select the environment and the company name from a dropdown box: This is quite noisy if you want to move your flows between environments, because you need to specify again the connections on every trigger and action. Unfortunateky there’s no… Continue Reading demiliani’s Article on...
Business Central Server Administration tool – Removed.
Hi Reader, With announced of Business Central 2022 Release Wave 2, there are few changes for that impact on-prem customers. During installation of Business Central 2022 Release Wave 2, you will notice that it will not be part of installation component. #Retire #msdyn365bc #2022RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Business Central Server Administration tool – Removed. With...
Azure : Using Logic Apps to Monitor Azure App Registration Expiration
When we switched to use OAuth2 authentication, we now need to create Azure AD App Registration with expiration date. The client secret expiration date can only be set to maximum of 24 months. We cannot set a client secret that will never expire due to security reason. Unfortunately, Azure currently does not natively provide a way to notify expired client secret. An expired secret can cause… Continue Reading thatnavguy’s...
#msdyn365bc 2022 Release Wave 2 – Launch in a specific company from Visual Studio Code.
Hi Readers, In this series we are discussing what's new in Business Central 2022 (Wave 2) a.k.a BC21. This article we will discuss about – Launch in a specific company from Visual Studio Code. With this series we will understand what's new the product and learn it. Hope you like the series, please add comments to article. #msdyn365bc #2022RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on...
D365 Business Central : Lazy Evaluation
Hi and Happy New Year 2023 !! For the start of the year, let us talk about Lazy Evaluation. What is Lazy Evaluation ? If you have never heard of lazy evaluation, it is basically a technique where the compiler do not process an expression until it’s needed. What does that mean ? Let’s take a look at example in AL conditional statements. if <Condition1> and <Condition2> then … Continue Reading...
Microsoft Dynamics Business Central Cumulative Update Summary for January 2023.
Hi Readers, A New Month and a new set of cumulative updates. Microsoft Have Released Cumulative Update for January 2023 for Business Central 14, 19, 20 & 21. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 19, 20 & 21. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14 #msdyn365bc19 #msdyn365bc20 #msdyn365bc21 Read Complete… Continue Reading Saurav...
Extending Dynamics 365 Customer Engagement Apps with Low Code
Welcome to my library This book should be part of the basic library of professionals who specialize or are preparing to be Microsoft business solutions architects. The first impression one gets from reading it is that one needs a medium level of technical knowledge. However, the structure and organization of the contents ensure that those readers who do not master any of the areas… Continue Reading Javier.Armesto’s Article...
Microsoft Dynamics Navision Cumulative Update Summary for January 2023.
Hi Readers, A new month and new cumulative updates. Microsoft Have Released Cumulative Update for January 2023. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2018 #cumulativeupdate Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Navision Cumulative Update Summary for...
Dynamics 365 Business Central: new Power Automate actions for handling images and attachments
Starting from this week, the Power Automate connector for Dynamics 365 Business Central adds new actions for handling images and attachments and these new actions are available on all regions. I previewed these new actions in Microsoft Italy one at the partner events in end of November, but now we can share more details about that. The newly added actions are the following: and they… Continue Reading demiliani’s Article on...
Dynamics 365 Business Central: AL permission sets and name length errors
This is a very quick post to answer a question sent to me privately today by a Dynamics 365 Business Central partner. Question was the following: Why a permission set can have only 20 characters in the name? Is it standard or is it an AL extension bug? AL permission sets name length check has a sneaky behaviour in Visual Studio Code. Let’s create a simple permission set like the… Continue Reading demiliani’s Article...
ChatGPT di OpenAI test con Microsoft AL Language: creazione di una app per leggere una pagina web e salvare i dati presenti nella pagina in un foglio Excel
Chat GPT-3 di OpenAI La chat GPT-3 (Generative Pre-trained Transformer 3) è un modello di linguaggio di ultima generazione sviluppato da OpenAI. Si tratta di una delle maggiori reti neurali per il linguaggio naturale mai create, con una capacità di circa 175miliardi di parametri. Una delle principali peculiarità della chat GPT-3 è la sua capacità di generare testi di alta qualità in modo… Continue Reading rs’s Article on...
#msdyn365bc 2022 Release Wave 2 – See the primary key for table fields in IntelliSense.
Hi Readers, In this series we are discussing what's new in Business Central 2022 (Wave 2) a.k.a BC21. This article we will discuss about – See the primary key for table fields in IntelliSense. With this series we will understand what's new the product and learn it. Hope you like the series, please add comments to article. #msdyn365bc #2022RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on...
Azure Service Bus: introducing partitioning in Premium tier
If you was at my recent training about extending Dynamics 365 Business Central with Azure services in Microsof Italy or if you attend some of my sessions about Dataverse extensions, I think you already know that I’m a huge fan of using Azure Service Bus for handling messages in the cloud. Azure Service Bus is a fully managed enterprise message broker with message queues and… Continue Reading demiliani’s Article on...
What is New? Aplicación de Power BI para Telemetría en Business Central Enero 2023
“La telemetría es una forma de recopilar y transmitir datos de un lugar a otro“ Telemetría en Microsoft Dynamics 365 Business Central En el contexto de Microsoft Dynamics 365 Business Central, la telemetría puede ser utilizada para recopilar información sobre el uso y el rendimiento de la aplicación y luego transmitirla a un lugar donde pueda ser analizada y utilizada para… Continue Reading Javier.Armesto’s Article on...
#msdyn365bc 2022 Release Wave 2 – View size of text, code fields in page inspection.
Hi Readers, In this series we are discussing what's new in Business Central 2022 (Wave 2) a.k.a BC21. This article we will discuss about – View size of text, code fields in page inspection. With this series we will understand what's new the product and learn it. Hope you like the series, please add comments to article. #msdyn365bc #2022RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their...
Dynamics 365 Business Central telemetry: new year improvements and news
I think that you already know that the area of telemetries is a fast moving area in the Dynamics 365 Business Central field. The new year has started, some improvements on this area are cooking and our “King of the Heroes” Kennie has just shared the monthly report about the Power BI Telemetry Apps news. Just for reference, you can download the Power BI apps from here (Power BI Pro license… Continue Reading...
🔔 New App version for Power BI Telemetry in Business Central: How to upgrade the application
New version January 2023 How to update Power BI application version I bring you a mini-pill where we show you how to update the version in a few clicks. Take note of this Mini Pill and I hope you find it of interest and : Subscribe to the channel ( encourage and give that push to all this). Click «like» if you liked it. If you don’t want to miss anything, you… Continue Reading Javier.Armesto’s Article on their blog 🔔...
#msdyn365bc 2022 Release Wave 2 – Country/regional expansion.
Hi Readers, In this series we are discussing what's new in Business Central 2022 (Wave 2) a.k.a BC21. This article we will discuss about – Country/regional expansion. With this series we will understand what's new the product and learn it. Hope you like the series, please add comments to article. #msdyn365bc #2022RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog #msdyn365bc 2022...
Remove unsupported characters with Sanitizing Your #msdyn365bc Data.
Hi Readers, With start of New Year, I saw a new issue and learned something with that. This reminded about an old article that I have written in past during data upgrade from Classic to RTC Version. While writing that I thought this will never come up again but to my surprise that it's still there, but this time story is little bit different. This time Microsoft added a process to fix these data… Continue Reading Saurav...
Summary of 2022 – What All Happened this Year.
Hi Reader, As 2022 is ending, let's review year from our prospective. While doing this review, I had some insights and would like to share those with my Business Central Family. I always try to keep working towards what I hear from you and to be true this blog and YouTube channel is actually yours. Your suggestions and advice make it what it is today. So, let's dive it in and see what all we did… Continue Reading...
Tres Propósitos para el 2023 Business Central
Ya llega 2023 y como no podía ser de otra manera comienza el carrusel de publicaciones de buenos propósitos. Y desde Tech Sphere Dynamics no nos queremos quedar atrás ,así que aquí van los tres propósitos para Business Central para el año que entra. 1. Last Call para actualizar a Business Central «Ultima… Continue Reading Javier.Armesto’s Article on their blog Tres Propósitos para el 2023 Business Central Ya llega 2023 y...
Are you using proxies with Azure Functions? Start moving to Azure API Management.
When working with lots of Azure Functions apps or in microservices architectures with a moderate workload, it’s quite common to use (or at least evaluate using) a not so well-known feature of Azure Functions called proxies. What are Azure Functions proxies? With proxies, you can specify endpoints on your function app that are implemented by another resource. You can use these proxies to… Continue Reading demiliani’s...
New Post Sothis : Piensa en la plataforma: no mires el dedo, mira la luna
Piensa en la plataforma: no mires el dedo, mira la luna Os traigo una entrada que he publicado en el blog de Sothis donde expongo como poder empezar a conocer las capacidades en Inteligencia Artificial al servicio de nosotros : los usuarios. Aquí os dejo el enlace Espero que os resulte de interés y : Suscríbete al canal ( anima y da ese empujón a todo esto). Pulsa… Continue Reading Javier.Armesto’s Article on their blog...
Dynamics 365 Business Central and bulk inserts
Today I’ve discovered that not everyone knows how Dynamics 365 Business Central (but also Dynamics NAV) handles inserts on the SQL backend, so I think it’s worth writing a quick post on explaining this. Let’s consider this piece of AL code: In this code I’m retrieving an existing Item record (the first) and then I’m doing an INSERT operation that obviously fails. Then after that… Continue Reading...
D365 Business Central : Test OAuth2 Connection
Last time we talked about how to setup OAuth2 to connect to Business Central API. This time, let’s talk about how to test the connection. We will use two methods: Postman and REST Client. Postman We are going to use below URL to test. We are going to put it under URL. https://api.businesscentral.dynamics.com/v2.0/Sandbox/api/v2.0/companies Let’s start by setting up the… Continue Reading thatnavguy’s Article on...
Some tips to improve security of your Azure Blob Storage (expecially with Dynamics 365 Business Central)
In these days I’m happy to see that after my latest Azure training in Microsoft Italy (3 weeks ago) many partners are starting to use Azure Blob Storage in their projects with Dynamics 365 Business Central. Some of you asked about security of the Azure Blob Storage in case you want to store important informations from Dynamics 365 Business Central. Here is what I personally recommend in… Continue Reading demiliani’s...
Feliz Navidad – Merry Christmas
Desde Tech Sphere Dynamics os deseamos unaFeliz Navidad.Descansad y disfrutar de estos últimos días del año.Un abrazo y gracias por hacer esto posible.Tech Sphere DynamicsJavier Armesto Gonzalez Continue Reading Javier.Armesto’s Article on their blog Feliz Navidad – Merry Christmas Desde Tech Sphere Dynamics os deseamos unaFeliz Navidad.Descansad y disfrutar de estos últimos días del año.Un abrazo y gracias por hacer esto...
A Business Central “Upgrade Code” saga…
Not too long ago, we had an upgrade issue at a customer: the upgrade timed out, and after investigation, it was simply because our upgrade code: it took too long to modify 130000 records (well – and quite some validations, I admit, but still – it’s not that much, is it?). This made me hold on to some things that I had been doing even for my own apps (like the waldo.BCPerftool (which I’m now… Continue...
D365 Business Central : Setup OAuth2 Authentication
We need to use OAuth2 when we want to connect to Business Central API. In this post, I would like to talk about how to setup OAuth2 authentication. OAuth 2.0 (Open Authorization) is a standard authorization protocol designed to allow a website or application to access resources hosted by other web apps on behalf of a user. There are basically two things that we need to do to set it up:… Continue Reading thatnavguy’s...
D365BC SaaS Read-Only environment
One of the greatest hidden features using Dynamics 365 Business Central on a SaaS environment is the availability of a read-only replica of the database. Until latest versions it was not possible to manage the use of this database without Development/Technical skills. There is a great post from Demilliani about it ->
Dynamics 365 Business Central telemetry report as Adaptive Card on Teams
During my telemetry session at last Directions EMEA in Hamburg and also on my latest Telemetry workshop in Microsoft Italy some weeks ago, when talking about being proactive with Dynamics 365 Business Central telemetry data, I’ve done a demo creating advanced alerts and one of them used Teams as a channel to redirect notifications of tenant’s anomalies. The created alert used Azure Logic… Continue Reading...
Where is the limit in Business Central CRM capability when integrating it with D365 Sales? (part 3)
As I have told you in the previous blog post for part 3, I will introduce you to the Data Synchronization feature, and I will try to explain all capabilities of Data Synchronization. Before we start creating and explaining how it works, one step needs to be made before we Synchronize Sales Professional and Business Central. You will need to create Synchronization between Dataverse and… Continue Reading Marko Totovic’s...
Pongamos a trabajar a Business Central y AI Builder: Introducción
Hola ¿conoces a Microsoft AI Builder? AI Builder pertenece al ecosistema de Microsoft Power Platform y permite a los usuarios crear y utilizar modelos de aprendizaje automático sin necesidad de tener conocimientos profundos en ciencia de datos o en el desarrollo de estos modelos. ¿Conoces a TED? dale al play y despues sigue leyendo. < h2 class=”wp-block-heading has-large-font-size”>En dos palabras: Accesible y…...
Business Central from On-Premise to Cloud APIs
Business Central Cloud Migration Scenario It’s possible to use APIs to perform the data migration in automatic mode (Silent Mode). All existing functionalities usable via pages are available, through powershell scripts it is possible to launch the migration in Silent Mode. Data Migration Scenario Microsoft has created some Powershell Scripts for: Automate already existing manual… Continue Reading rs’s Article on their blog...
Azure : Deploy Diagnostic Settings using Bicep
Azure Diagnostic Settings is used to send Azure resource’s platform logs and metrics to the destination of your choice. We can use this to connect a resource to a Log Analytics Workspace for log gathering. We can add the Diagnostic Settings manually under each resource. The challenge is that when we try to do export template, the diagnostic settings is not included in the template. It’s… Continue Reading...
Microsoft Dynamics Business Central Cumulative Update Summary for December 2022.
Hi Readers, A New Month and a new set of cumulative updates. Microsoft Have Released Cumulative Update for December 2022 for Business Central 14, 19, 20 & 21. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 19, 20 & 21. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14 #msdyn365bc19 #msdyn365bc20 #msdyn365bc21 Read Complete… Continue Reading Saurav...
Microsoft Dynamics Navision Cumulative Update Summary for December 2022.
Hi Readers, A new month and new cumulative updates. Microsoft Have Released Cumulative Update for December 2022. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2018 #cumulativeupdate Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Navision Cumulative Update Summary for...
Azure AI y Business Central, el gran olvidado
Photo by Anete Lusina on Pexels.com Business Central que incluye ciertas capacidades de inteligencia artificial (IA). Estas capacidades pueden ayudarnos a automatizar tareas repetitivas y a tomar decisiones más informadas en nuestro negocio. Algunas de las capacidades de IA que se incluyen en Business Central incluyen: Análisis predictivo: Business Central incluye herramientas de… Continue Reading Javier.Armesto’s...
Dynamics 365 Business Central: scheduling job queue tasks via API
The Dynamics 365 Business Central 2022 Wave 2 version 21.2 update silently introduces a long requested feature: the possibility to scheule job queue tasks via APIs in an integrated session using Service-to-Service (S2S) authentication. Service-to-Service (S2S) authentication is suited for scenarios where integrations are required to run without any user interaction and prior to this new… Continue Reading demiliani’s...
Dynamics 365 & PowerPlatform Conferences in 2023
We are close to the end of this, and we mostly have important conference dates for the following year. I would like to have all Dynamics 365 (and/or Power Platform) conferences in one place, with all dates planned for 2023. So, you can find them here and start planning your attendance as most of them have early bird: conneXion APAC, Bali, Indonesia (March 8-9, 2023) Days of Knowledge… Continue Reading Marko Totovic’s...
Dynamics 365 Business Central and AL language: it’s the time to give us namespaces!
Naming objects is one of the hardest problems in software development. In programming, a namespace is a technique used to uniquely identifying one or more objects from other similarly named objects. A namespace defines a scope where identifiers like variables, functions, obejcts, etc., are declared. The main purpose of using a namespace is to prevent ambiguity when two identifiers have the… Continue Reading demiliani’s...
Prepare for the new invoice posting engine!
Introduction In version 2021 wave 2 (v19) a new feature was introduced, called “Extend general ledger posting aggregations”. The reason for this new feature is that the table “Invoice Post. Buffer” could not easily be extended. This table is used to buffer the entries that will be created during a posting procedure. Entries are combined (amounts are added up) based on their values in the… Continue Reading...
D365 Business Central : Using Service-to-Service (S2S) Authentication with Job Queue
Minor update 21.2 for Business Central 2022 release wave 2 has just been released. You can check the release update here. It’s a minor update, but one of the most important part is that the integrated session using service-to-service (S2S) authentication can now schedule tasks. This is great news for people who are dealing with integration. Prior to the update, scheduled tasks must be… Continue Reading thatnavguy’s...
Dynamics 365 Business Central: DataTransfer on upgrades and performances
At the beginning of September 2022 I wrote this post introducing the new DataTransfer data type (available from Business Central version 21). DataTransfer is an AL data type that supports the bulk transferring of data between SQL based tables. Instead of operating on a row-by-row model, like the record API does, DataTransfer produces SQL code that operates on sets (direct operations in SQL,… Continue Reading demiliani’s...
Where is the limit in Business Central CRM capability when integrating it with D365 Sales? (part 2)
So, after introduction to this topic, it is time to continue with it and say when you would need to consider extending your Business Central with a license for Sales Professional. First, what I would like to introduce you to is a small dictionary. The reason is that we have a few of the same, but they have different names. The reason is that Business Central is a financial-focused system,… Continue Reading Marko Totovic’s...
Dynamics 365 Business Central telemetry: Grafana dashboard template
PREFACE: Microsoft has created two wonderful Power BI apps for analyzing Dynamics 365 Business Central telemetry: Dynamics 365 Business Central Usage Analytics: Power BI app that permits you to visualize different aspects of a Dynamics 365 Business Central tenant usage. Available at https://aka.ms/bctelemetryreport Dynamics 365 Business Central App Usage: Power BI app that permits you… Continue Reading demiliani’s Article...
Dynamics 365 Business Central: new option to enable/disable the “save as you type” feature.
The “save as you type” feature in Dynamics 365 Business Central is like a black cloud over your head… if you start forgotting it, than something happens Dynamics 365 Business Central 21.1 on-premise introduces a new setting in the web client’s navsettings.json file called SaveValueToDatabasePromptly. This new setting permits you to enable/disable the “save as you type” web client...
Trigger a Power Automate Flow from Business Central for a Selected Record
Intro This is my first stop on the Power Platform learning train. As I mentioned in the first post, this seems like a significant moment to me. Over the last few versions users have had more control over the web client. Between the Personalise and Design options you can tweak a lot of the elements on a page. If you wanted to introduce some logic you could do that through Power Automate…. Continue Reading james’s Article on...