Dynamics 365 Business Central: introducing the AL profiler
Sep20

Dynamics 365 Business Central: introducing the AL profiler

With the Dynamics 365 Business Central 2021 Wave 2 release (version 19), silently a new hidden feature was introduced: the AL profiler. I’ve mentioned this feature on a blog post announcing my top new features for the v19 release and someone of you asked me for more infos. What is this feature? How can I use it? Snapshot captures now include a performance profile of the executed code… Continue Reading demiliani’s...

Read More
How to Post Transactions using Configuration Package in business central
Sep19

How to Post Transactions using Configuration Package in business central

Two days back one of the customer asked me is there any way that I can post sales transactions using configuration package and I said yes it is possible to do that by using processing rules in configuration package. Today’s blog post will explain how it is possible. In this blog post we will see how we can post sales transaction using configuration package. Step 1:- Create configuration… Continue Reading Ammolh...

Read More
How to Extend Preview Posting in business central
Sep17

How to Extend Preview Posting in business central

Do you know one of the great feature provided by Navision called as Preview posting. When posting journals or documents with a large number of entries, accountants want to make sure that the posting will be correct beforehand. Previewing the posting helps prevent the need for corrections, making accountants more productive. In upcoming version of Business Central Wave 2 2021 preview… Continue Reading Ammolh Saallvi’s...

Read More
Can you “force” VSCode extensions on your team’s PC’s?
Sep17

Can you “force” VSCode extensions on your team’s PC’s?

You must have seen the launch of Vjeko’s extension: the “AL Object ID Ninja”. If you haven’t, well, let me make your day and show you some resources: AL Object ID Ninja – Vjeko.comAL Object ID Ninja v1.1.0 released – Vjeko.comAL Object ID Ninja – Visual Studio Marketplacevjekob/al-objid: Vjeko.com AL Object ID Ninja (github.com) In short: it’s a VSCode extension that will help you… Continue...

Read More
How to Setup default document line type for Sales transaction in business central
Sep16

How to Setup default document line type for Sales transaction in business central

This is one of new feature going to be in October release of Business central. On Sales transaction user need to select the line type such as Item, G/L Account ,Fixed asset etc. but sometime users says can we have default type as Item on every new sales orders rather than selection . With upcoming business central version it is possible to set default line type as setup. Go to… Continue Reading Ammolh Saallvi’s Article on...

Read More
Dynamics 365 Business Central and Excel Organization data types
Sep15

Dynamics 365 Business Central and Excel Organization data types

About one year ago, Microsoft has announced the preview of the so called “Organization data types” for Excel and Power BI that add “connected data types” on top of the standard strings and numbers options. A connected data types (based on a shared Power BI dataset) gives you access to a lot of related information of your data. Once cells have been converted into linked data types, you can… Continue...

Read More
Cumulative Update 05 for Microsoft Dynamics Business Central 2021 Wave 1.
Sep14

Cumulative Update 05 for Microsoft Dynamics Business Central 2021 Wave 1.

Hi Readers, Microsoft Have Released Cumulative Update for 05 for Business Central 18 (on-Prem). Below are the Links to Download the Latest Cumulative Update. #msdyn365bc18 #msdyn365bc Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Cumulative Update 05 for Microsoft Dynamics Business Central 2021 Wave 1. Microsoft Have Released Cumulative Update for 05 for Business Central 18 (on-Prem). Below are...

Read More
Dynamics 365 Business Central: cleaning sensitive configurations when copying production to sandbox
Sep14

Dynamics 365 Business Central: cleaning sensitive configurations when copying production to sandbox

When working with Dynamics 365 Business Central on real projects, I think that it’s quite common to have the need to create a Sandbox environment as a copy from a Production environment. This is useful for testing purposes but also for some troubleshooting. You already know that you can create a new Sandbox environment as a copy of a Production environment directly from the Admin… Continue Reading demiliani’s Article...

Read More
Is GitHub Copilot Any Good for Business Central Development?
Sep13

Is GitHub Copilot Any Good for Business Central Development?

TL;DR No. At least, not yet. Maybe later. But even then, maybe not. Intro For now this is necessarily a simple, first impressions post about GitHub Copilot. I’ve used it for a few weeks, tweeted enthusiastically in the first couple of days’ use and have now disabled it. What is it, how does it work, what’s good, what’s not so good? What is GitHub Copilot? Your AI pair… Continue Reading james’s...

Read More
HELP! My entire Business Central SAAS stopped running!
Sep13

HELP! My entire Business Central SAAS stopped running!

Today was my first day back at the (home) office programming in 2 and a half months. I had already spend a lot of time in the last month or so changing email addresses and other account names to my new name but I only looked at my BC Saas sandboxes today. When I looked at the admin portal it looked like this: All environments where set to Not Ready, all options to restart, delete… Continue Reading Marije Brummel’s Article...

Read More
Microsoft Dynamics Business Central Cumulative Update Summary For September 2021.
Sep10

Microsoft Dynamics Business Central Cumulative Update Summary For September 2021.

Hi Readers, Microsoft Have Released Cumulative Update for September 2021 for Business central 14, 16 & 17. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 16 & 17. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14, #msdyn365bc16 #msdyn365bc17 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog...

Read More
Business Central OneDrive CloudStorage integration
Sep10

Business Central OneDrive CloudStorage integration

Onedrive integration in Business Central With business central you can use OneDrive to save documents from Business Central; in practice it is possible to use your own personal Onedrive drive (if you already have one activated) or create it on the fly by passing through Sharepoint online. The use of Onedrive integrated in BC can be done in two ways: Classic (folder on disk) Modern (via .ASPX… Continue Reading rs’s Article...

Read More
Microsoft Dynamics Navision Cumulative Update Summary For September 2021.
Sep08

Microsoft Dynamics Navision Cumulative Update Summary For September 2021.

Hi Readers, A new month and new cumulative updates. Microsoft Have Released Cumulative Update for September 2021. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2017 & NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2017 & #NAV2018 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Navision Cumulative...

Read More
Business Central Wave 2 2021 Preview available
Sep08

Business Central Wave 2 2021 Preview available

The preview of Business Central 2021 Wave 2 (release 19) was released It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are removed at most thirty days after the official release of the product. Now lets get ready to explore new… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Dynamics 365 Business Central: new indexing features on 2021 Wave 2 release
Sep07

Dynamics 365 Business Central: new indexing features on 2021 Wave 2 release

Dynamics 365 Business Central 2021 Wave 2 release (version 19) introduces some new indexing features that you can use on your tables definitions from AL. Now you can: Define columnstore indexesDefine included columns in indexes Columnstore indexes were first introduces with SQL Server 2012. These indexes are very useful for data warehouse workloads and large tables. They can improve… Continue Reading demiliani’s Article on...

Read More
Dynamics 365 Business Central: introducing resource exposure policies for extension’s code
Sep06

Dynamics 365 Business Central: introducing resource exposure policies for extension’s code

I think that everyone of you knows that with Dynamics 365 Business Central extensions your code is by default protected against downloading or debugging. For managing this, in the extension’s app.json file there’s a property called showMyCode that allows the code to be debugged from other extensions when it has been published. The default setting is false and this means that debugging into an… Continue Reading...

Read More
Dynamics 365 Business Central 2021 Wave2 preview is available
Sep06

Dynamics 365 Business Central 2021 Wave2 preview is available

Microsoft Dynamics 365 Business Central 2021 Wave 2 preview The preview of Business Central 2021 Wave 2 (release 19) was released and made available today; you can test it both Online and on Docker. It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are removed… Continue Reading rs’s Article...

Read More
Business Central 2021 release wave 2 – Preview Environments.
Sep06

Business Central 2021 release wave 2 – Preview Environments.

Hi Readers, Yes the future version of Business Central is about to release in October. But as developers we need access to Next version to be ready for what's changing and how our App Source Extensions and Per Tenant Extension will be impacted with Next Release. Today Microsoft have released Preview Features of Business Central 2021 Release Wave 2. Read Complete Article » Continue Reading Saurav Dhyani’s Article on their...

Read More
Public Dynamics 365 Business Central 2021 Wave 2 environments are here…
Sep06

Public Dynamics 365 Business Central 2021 Wave 2 environments are here…

Starting from today, you can create new Dynamics 365 Business Central environments based on the 2021 Wave 2 release (version 19): Please remember that the newly created preview sandbox environment contains demonstration company data only. Trying the preview on a copy of your current production data is not yet supported and also testing the upgrade from your current version to the… Continue Reading demiliani’s Article on...

Read More
#msdyn365bc – Export Multiple Sheet To Excel Report.
Sep02

#msdyn365bc – Export Multiple Sheet To Excel Report.

Hi Readers, This is one of the question that I received as comment to Previous article. In this article we will develop a report which can extract data from multiple Tables. I am not going into details as its already discussed in last article. You can refer that article here. For Demo, I will be export few fields from customer & vendor table to Excel. Read Complete Article » Continue Reading Saurav Dhyani’s Article on their...

Read More
Get Client Type in AL
Sep02

Get Client Type in AL

If you want to know, if a user accessing BC from a device, desktop, or API, you can use the Client Type. Let’s say for an example, you want to limit user modifying from from tablet or phone, you can use CurrentClientType method. field(12; “Item No.”; Code[50]) { Caption = ‘Item No.’; DataClassification = CustomerContent; trigger OnValidate() begin if… Continue Reading thatnavguy’s Article...

Read More
Test Explorer in Visual Studio Code
Sep01

Test Explorer in Visual Studio Code

The July 2021 release of Visual Studio Code (1.59) introduced a new testing API and Test Explorer UI. From v0.6.0 this API is used by AL Test Runner. Test Explorer Demo Improvements UI The biggest improvement is the Test Explorer view which shows your test codeunits, their test methods and the status of each. Hovering over a test gives you three icons to run, debug or open… Continue Reading james’s Article on their blog...

Read More
msdyn365bc Preprocessor Directives – Pragma Directives.
Sep01

msdyn365bc Preprocessor Directives – Pragma Directives.

Hi Readers, In the Introduction article of series we understand different types of Preprocessor  directives available in Business Central. Preprocessor Directives are available starting Business Central 2020 Release Wave 2.  You can read other articles in this series using this link. In this article we will understand how to use Pragma Directives. The #pragma directive gives the compiler special… Continue Reading Saurav...

Read More
#msdyn365bc – How Do I Create an Empty Database?
Aug31

#msdyn365bc – How Do I Create an Empty Database?

Hi Readers, This article based on a question that I have.  In Dynamics NAV World you can create a new database in Dynamics NAV Development Environment and import objects in database. With Business Central Era all base Microsoft objects are now part of Base and System App's. In this article, we will discuss about steps to create a new database, with Business Central on-prem. Read Complete Article… Continue Reading Saurav...

Read More
Business Central Insider Releases Artifacts
Aug30

Business Central Insider Releases Artifacts

Business Central Insider Releases Artifacts Some have asked me about the Insider releases of Business Central; you can find some information on Microsoft Docs about specifics but in order to download these versions, you need to use the ready-made, published and available artifacts insider releases.   Insider Release Artifacts These versions are made available to be able to test the new… Continue Reading rs’s Article on...

Read More
Azure AD authentication for Application Insights: how to use it and the impact on Business Central telemetry
Aug30

Azure AD authentication for Application Insights: how to use it and the impact on Business Central telemetry

Microsoft has recently announced the public preview of a new capability for Azure Application Insights: the support for Azure Active Directory (Azure AD) authentication. By using Azure AD, you can ensure that only authenticated telemetry is ingested in your Application Insights resources. By using this new feature you can now choose to opt-out of local authentication and ensure that only… Continue Reading demiliani’s...

Read More
#bcopendiscussion – ExportToExcel and Emailing.
Aug30

#bcopendiscussion – ExportToExcel and Emailing.

Hi Readers, During Last #bcopendiscussion on 28-Aug-2021 we discussed about few commonly asked question about Export to Excel Scenarios and also about Emailing Export to Excel Files via Email using Streams. Below is the Video, Demoing both the features in #msdyn365bc. If you would like to register for next #bcopendiscussion then register here. Regards, Saurav Dhyani www.sauravdhyani.com Continue Reading Saurav Dhyani’s Article...

Read More
The complexity of complex return types – Looping a record return type (extended)
Aug27

The complexity of complex return types – Looping a record return type (extended)

Short post Do you remember my post about The complexity of complex return types? And the update The complexity of complex return types (updated) – Looping a record return type? Well, since the release of Microsoft Dynamics 365 Business Central 18.4, I have a another update for you! Let’s call it an “extension” for the update . As I mentioned in the second post that it actually WAS… Continue Reading...

Read More
Cumulative Update 04 for Microsoft Dynamics Business Central 2021 Wave 1.
Aug26

Cumulative Update 04 for Microsoft Dynamics Business Central 2021 Wave 1.

Hi Readers, All of us were waiting for Cumulative Update 04 for Business Central 2021 Wave 1 (BC18). Microsoft Have Released Cumulative Update for 04 for Business Central 18 (on-Prem). Below are the Links to Download the Latest Cumulative Update. #msdyn365bc18 #msdyn365bc Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog https://www.sauravdhyani.com/2021/08/cumulative-update-04-for-microsoft.html...

Read More
Protected Variables
Aug26

Protected Variables

“Protected Variables” might not be a familiar topic in the Business Central world. It was at least not that familiar to me ;-). So I wanted to make a small post to make this more known in the community, so that at least you are aware that it exists .. and it might give you some more extensibility options that you might not have considered.. . The concept is simple: protected variables are… Continue Reading...

Read More
Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare!
Aug25

Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare!

Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare! Business Central 2021 Wave2 (release v.19) is expected to be launched in early October; I want to point out some features news of the product that I consider interesting (there are many …) For all the news and features, I refer you to the links below which contain everything that will be released between October 2021 and March… Continue Reading rs’s...

Read More
What is planned for Business Central Wave 2 2021 release
Aug24

What is planned for Business Central Wave 2 2021 release

As we are gearing up for new release of business central and already the buzz is started for new version . Here I will list few upcoming features which I am looking forward in new version. Following features I am looking forward. Richer access control for extension source in cloud environments Add additional columns through personalization in various pages to gain more insight

Read More
Docker Desktop Failed to Initialize
Aug16

Docker Desktop Failed to Initialize

After updating the Docker Desktop to the latest version successfully, the docker was acting up and refused to start up. To fix this issue, try to delete below folders. %USERPROFILE%AppDataLocalDocker%USERPROFILE%AppDataRoamingDocker%USERPROFILE%AppDataRoamingDocker Desktop Once deleted, you should be able to start Docker Desktop as normal. If the docker is stuck at… Continue Reading thatnavguy’s Article on their blog...

Read More
Word Layout Reports: repeat header lines on every page with Word 2019
Aug13

Word Layout Reports: repeat header lines on every page with Word 2019

Word Layout Reports: repeat header lines on every page with Word 2019 In Microsoft Word 2019 there is a property that allows you to determine if a row should be repeated for each page (Header Lines). This option saves us from inserting in the header, for example: “column names”, for example this tip eliminates the problem of aligning the column name row with the data (that after each… Continue Reading rs’s Article on their...

Read More
Dynamics 365 Business Central: Sandbox vs Onprem Docker containers
Aug12

Dynamics 365 Business Central: Sandbox vs Onprem Docker containers

I saw this question popping up frequently on different forums also recently: what are the main differences when creating a Dynamics 365 Business Central Docker container by using the Sandbox artifacts vs by using the on-premise artifacts? I think that every reader of this blog knows that with the BcContainerHelper Powershell module you can retrieve the latest artifacts of a particular… Continue Reading demiliani’s Article...

Read More
#msdyn365bc – Export To Excel Report.
Aug12

#msdyn365bc – Export To Excel Report.

Hi Readers, This is one of the common question that I keep on skipping for a while to write an article about how to export data in Business Central. The Process is similar but during the Upgrade or writing code we kind of used a function C/AL World CreateBookAndOpenExcel which is not supported with Business Central. The type or method 'CreateBookAndOpenExcel' cannot be used for 'Extension'… Continue Reading...

Read More
Quickly Navigate to a File in VS Code
Aug12

Quickly Navigate to a File in VS Code

If you are working with hundreds of files in VS Code, you can easily navigate to that file by using “Ctrl + P” (Quick Open) and start typing in the file that you are looking for. Ctrl + P If you want to navigate between all currently opened files in an editor group, Hold Ctrl and press Tab to switch between it. Hold Ctrl + Press Tab Extra tip: You can also use @ to access the file… Continue Reading thatnavguy’s...

Read More
Microsoft Dynamics Business Central Cumulative Update Summary For August 2021.
Aug10

Microsoft Dynamics Business Central Cumulative Update Summary For August 2021.

Hi Readers, Microsoft Have Released Cumulative Update for August 2021 for Business central 14, 16 & 17. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 16 & 17. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14, #msdyn365bc16 #msdyn365bc17 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Business...

Read More
Microsoft Dynamics Navision Cumulative Update Summary For August 2021.
Aug09

Microsoft Dynamics Navision Cumulative Update Summary For August 2021.

Hi Readers, A new month and new cumulative updates. Microsoft Have Released Cumulative Update for August 2021. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2017 & NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2017 & #NAV2018 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog...

Read More
Add Total Page Number to Report
Aug05

Add Total Page Number to Report

To add total page number into RDLC report, you can use =Globals!TotalPages on the textbox. If you want to reset the Total Page, for example when you print a new Document No., you can set the ResetPageNumber to True under the PageBreak properties. Using Report Builder Using Visual Studio Code __ATA.cmd.push(function() { __ATA.initDynamicSlot({ id:… Continue Reading thatnavguy’s Article on their blog Add Total Page Number to...

Read More
#msdyn365 End of the Beginning.
Aug04

#msdyn365 End of the Beginning.

Hi Readers, If you haven't noticed End of the Beginning already started 05 months ago. In this article we will discuss about what does that mean and how does that impact #msdyn365bc customers. #msdyn365bc, #endofbeginning Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog #msdyn365 End of the Beginning. If you haven’t noticed End of the Beginning already started 05 months ago. In this...

Read More
Service to service authentication in Business Central 18.3 – How to use in AL
Aug04

Service to service authentication in Business Central 18.3 – How to use in AL

Because I got the question if it was possible to use the client credentials flow in Business Central I decided to write a quick blog post about that as well. Codeunit OAuth2 provides a number of functions to acquire access tokens with different authorization flows, including the client credentials flow. The function AcquireTokenWithClientCredentials can be used for this purpose. Read more… Continue Reading ajk’s Article on...

Read More
Service to service authentication in Business Central 18.3 – How to use in C#
Aug04

Service to service authentication in Business Central 18.3 – How to use in C#

We continue the series about Service to Service authentication, aka Client Credentials Flow, with some tips about getting and using the access token with C#. Please see the previous posts in this series for more information about how to set up and test the Client Credentials Flow: Usage and license termsHow to set upTest with VS Code REST Client and Power ShellTest with Postman and… Continue Reading ajk’s Article on their...

Read More
Using custom C# code when creating Custom Connectors for Power Platform or Logic Apps
Aug03

Using custom C# code when creating Custom Connectors for Power Platform or Logic Apps

If you’re doing integrationw between Dynamics 365 Business Central or other applications and the Power Platform, I think that sometimes you have the need to create a custom connector. Custom connectors are useful when you don’t have a pre-built connector with a particular application or API and they permit you to create (and even share) a connector with its own triggers and actions…. Continue Reading...

Read More
Microsoft Dynamics Business Central Cumulative Update Summary For July 2021.
Aug03

Microsoft Dynamics Business Central Cumulative Update Summary For July 2021.

Hi Readers, Sorry for Delay in Posting Cumulative Updates. Microsoft Have Released Cumulative Update for July 2021 for Business central 14, 16, 17 & 18. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 16, 17 and 18. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14, #msdyn365bc16 #msdyn365bc17 #msdyn365bc18 Read Complete… Continue Reading Saurav...

Read More
Microsoft Dynamics Navision Cumulative Update Summary For July 2021.
Aug02

Microsoft Dynamics Navision Cumulative Update Summary For July 2021.

Hi Readers, Sorry for delay in updating the cumulative Updates. A new month and new cumulative updates. Microsoft Have Released Cumulative Update for July 2021. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2017 & NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2017 & #NAV2018 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their...

Read More
Dynamics 365 Business Central on-premise and SQL on Azure VM: reducing storage costs
Jul30

Dynamics 365 Business Central on-premise and SQL on Azure VM: reducing storage costs

If you search on my blog, I’we written in the past a lot of articles with suggestions and best practices for using Dynamics 365 Business Central (and Dynamics NAV too) with SQL Server installed on an Azure Virtual Machine or also with Azure SQL Database. Onmy personal recommendations, I’ve always emphasized the importance of using Premium Storage with SQL Server on a production environment…. Continue Reading...

Read More
Service to service authentication in Business Central 18.3 – How to test (Postman & Insomnia)
Jul27

Service to service authentication in Business Central 18.3 – How to test (Postman & Insomnia)

This is the next blog post in a series about service to service authentication in Business Central. Please see the previous blog posts for more information: Usage and license termsHow to set upTest with VS Code REST Client and Power Shell In this post, I want to give some tips on how to test with Postman and Insomnia. Both are tools that are being used by Business Central developers,… Continue Reading ajk’s Article on...

Read More
What’s new and Planned for 2021 release wave 2 plan (a.k.a BC19).
Jul26

What’s new and Planned for 2021 release wave 2 plan (a.k.a BC19).

Hi Reader, Last week Microsoft released what's New and Planned for 2021 Release Wave 2. In this article, we will discuss about what's will be available in #msdyn365bc 2021 release wave 2 (a.k.a bc19). You can either browse the release plan online or download the document as a PDF file. Business Central updates are available from Page – 199 to 242. Read Complete Article » Continue Reading Saurav Dhyani’s Article...

Read More
BizApps Wiki – a great place for ERP, CRM and other experts
Jul26

BizApps Wiki – a great place for ERP, CRM and other experts

New platform BizApps.Wiki has just started. On the first sight it looks like as well know Wikipedia, but there is ‘but’… In comparison with Wikipedia there is highly focused content only with business applications (solutions/software) and other related topics. By the business application topics you can find information about almost all possible business application solutions as well as

Read More