Microsoft Dynamics 365 Business Central 2021 release wave 2 is a fact!
It’s here! v19 or in other words “Microsoft Dynamics 365 Business Central 2021 release wave 2” is released! Usually, when Microsoft releases their plans about an upcoming release (like it did some time ago), I create one or more blogs about it. I didn’t do that for this release. No particular reason other than time. It’s extremely busy on my end (not going to complain...
How to modify table data in business central
This week one of the customer post few transaction and found that one of the field user enter some wrong information. In ideal situation user need to reverse the transaction and post correct transaction which is safest approach. But do you remember those old days where we have access to the table and can modify the data but with business central this ability no more available . I just… Continue Reading Ammolh Saallvi’s...
What’s New in Business Central 2021 Release Wave 2?
Hi Readers, As we know that the next version of Business Central will be available. The Preview version is out in Docker Container. #msdyn365bc #2021RW2 If you want to setup a Preview Sandbox Environment, for Business Central Online then refer this article. If you want to setup Docker Environment for Business Central Preview then Watch recording. Starting this article, we will discuss what’s new in… Continue Reading...
Would you configure a Porsche…
…if you knew upfront that you would never get one? For obvious reasons I am getting a lot of questions lately about my transition and that is great. I love to talk about it and all the conversations I have help me process the transformation myself too. Some people ask me how long I knew about being a girl and the answer is, all my life. Even in my earliest memories I see myself in my… Continue Reading Marije...
Security in Dynamics 365 and in Business Central Online
Security in Dynamics 365 and in Business Central Online Some customers ask for information on the security of systems in the cloud world and also on Business Central Online; Business Central being part of the Dynamics 365 suite, it uses the same security framework as the other products. The whole Dynamics 365 Online suite is secure, everything is controlled in multiple points and with multiple… Continue Reading rs’s...
Page OnLookup Trigger
There are multiple ways in BC to create a Lookup button for a variable in a page or report. Generally speaking, I have seen three following methods being done to achieve the lookup button. 1. Using Table Relation field(fieldItemCode1; ItemCode) { ApplicationArea = All; Caption = ‘Item Code 1’; TableRelation = Item.”No.”; trigger OnValidate() begin … Continue Reading thatnavguy’s Article on their...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
#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...
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...
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...
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...
#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...
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...
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...
#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...
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...
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...
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...
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...
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
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...
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...
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...
#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...
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...
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...
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...
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...
#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...
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...
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...
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...