MB-820 Exam Cram: Reports, Report Extensions, and Queries in Business Central Master Data Presentation and Analysis for MB-820 Certification Reports are the lifeblood of any
Learn AL the Way Developers Actually Learn — With Someone Guiding You Reading time: ~5 minutes · Silviu Virlan There’s no shortage of ways to
MB-820 Exam Cram: Pages and Page Extensions in Business Central The ultimate guide to mastering Business Central’s user interface development If you’re building extensions for
MB-820 Exam Cram: Tables and Table Extensions in Business Central I’m excited to announce the release of the eighth booklet in my MB-820 Exam Cram
MB-820 Exam Cram: Integrating Business Central with Microsoft Teams Your Complete Guide to Mastering Teams Integration for MB-820 Certification Are you preparing for the MB-820
MB-820 Exam Cram: Integrating Business Central with Outlook Transform Your Productivity with Seamless Outlook Integration Are you preparing for the MB-820 certification exam? Do you
MB-820 Exam Cram: Create New Companies in Business Central I’m excited to announce the release of the fifth book in the MB-820 Exam Cram series:
What if you could manage your entire fixed asset lifecycle — acquisitions, depreciation, and disposals with automatic gain/loss calculation — just by handing an AI
What happens when you spend a weekend connecting Claude to Dynamics 365 Business Central? The Setup: From Zero to Connected This weekend, I went down
I’ve been writing C/AL and AL code for years. Table extensions, codeunits, page customizations — I could scaffold a Business Central extension in my sleep.
I’m excited to announce the release of the fourth book in the MB-820 Exam Cram series: Business Central Cloud Migration Tool – A Complete Guide
🚀 New Resource: Master Performance Testing in Business Central Performance issues can sink a Business Central implementation faster than almost anything else. Slow page loads
I’m excited to announce the release of the second book in the MB-820 Exam Cram series: Business Central Administration and Automation API! 📚 About This
I’m excited to announce the release of my new book: MB-820 Exam Cram: Install & Upgrade Codeunits in Business Central! This focused, practical guide is
Are you still using ApplicationArea = All in your PTE code? In this blog will learn how we can extend ApplicationArea ensuring that users only
Just dropped a new video that I wish I had when 2025 Wave 2 landed or a few waves ago …Every BC release, the question
Microsoft has introduced the field “AL Namespace” in AllObjWithCaption system table. But that’s not all, we can format a recordid to show us the fully
Check out my latest Youtube video where I demo the two text overloads of RecordRef.FieldExist and RecordRef.Field().
Business Central includes already 2 tools to copy data between companies. Of course, we can duplicate two companies, but you can also copy specific tables,
Just dropped a new video! I’ve been using GitHub Copilot for a while, but THIS is next-level! Watch how I went from zero to hero
Snapshot Debugging With snapshot debugging, you can record AL code that runs on the server, and when it has completed, debug the recorded snapshot in Visual Studio
If you want to see a practical walkthrough for testing outbound API calls please navigate to my latest video: The video focuses on recent innovations
AL development is at the root of customizing and extending Microsoft Dynamics 365 Business Central, a powerful ERP solution for businesses. This post explores the
With Business Central 2025 wave 1 Microsoft introduced 3 new apps: At the heart of all these 3 apps stays the External File Storage app.
The new “Continue” keyword arrived in AL with runtime 15, or BC 2025 wave 1. Curious how the “Continue” keyword in AL can turbocharge your
In this video I’m looking at: ✅ Factboxes: elegant frame [rounded corners + resizable] ✅ Report Explorer: executing page or report opens in new window
In Business Central you can set an item as blocked for sales, purchasing, and servicing. With 2025 wave 1, we can now set an item,
Last few years we witnessed how Microsoft introduced slowly more and more Copilot capabilities in the product. With Business Central 2025 wave 1 we’ve got
With Business Central 26.2 you can now add fields from related tables to your analysis. The main table and the new table have to be
With the Business Central 2025 wave 1 (runtime 15) we can now bypass getting the token for a JsonObject to get the value of a
Yaml Viewer in Business Central web client? Yes, we can read now a Yaml file into a Json object, format it nicely and load content
The introduction of the overloaded IncStr function in the AL compiler for Microsoft Dynamics 365 Business Central, which now accepts an increment value greater than
With Business Central 2025 wave 1 Microsoft enhances the Database Missing Indexes page by adding a few new columns: In my latest video, I took
With Business Central 2025 wave 1 we get a new page type: UserControlHost. These type of pages can only host one control in the content
With Business Central 2025 wave 1 we have 2 new triggers we can use to generate launch.json. Additionally, in the page Extension Management we have
With the Business Central 2025 wave 1 we can now use CardPageId property on base or any other extension list pages. If you want to
With Business Central 2025 wave 1 Microsoft introduces List and Dictionaries of Interfaces. Take a look at a 5 minute video I recorded on this
With the Dynamics 365 Business Central 2025 Wave 1 release arriving on April 1, 2025, developers get a new tool in their AL toolbox: the
Have you ever experienced the need to consolidate common tables in a new extension from a behemoth original extension? Well, I have some good news.
Administrators can define retention policies to specify how often to delete outdated data in tables that contain log entries and archived records. For example, cleaning
Each year, I review the content I’ve created over the past 12 months, analyzing its performance metrics and comparing them to previous years. In 2024,
Master error handling in MB-820! Episode 18 of ‘Let’s pass MB-820’ dives into Try Functions & Collectible Errors. Watch now to boost your AL skills!
Learn essential report development skills for #BusinessCentral: ✅ Additive changes vs breaking changes ✅ Report extensions ✅ Triggers for report extensions ======================================================== Github repo —
Hey everyone, welcome back to the channel! Are you deep in the trenches, studying for the MB-820? How’s it going with the report object? Got
We discussed in the last episode about introductory concepts about AL reports: report properties, report triggers, dataset, dataitems … Let’s continue today with additional concepts
Learn essential report development skills for #BusinessCentral: ✅ Report properties & triggers ✅ Request pages ✅ DataSet & DataItems items; properties and triggers ✅ Layouts
In this episode, you will learn about debugging AL projects, securing your IP, generate documentation on the fly with ALDoc and make it available via
In the NAV days the access to the ERP system was done through a combination of a license file and permission sets. You would have
The “Page” is the object type in Business Central designated to represent the user interface for different entities. In my latest Youtube video you will
Last video I looked at table objects, the backbone for making data persistent in the database. But what do you do if the schema defined
Business Central is an ERP system that manages data. Data is stored in tables, and Business Central has a way to manage SQL server tables,
Jobs in Business Central have been renamed to Projects since Business Central 2024 wave 1. So, if you’re used to Jobs, Job Tasks, Job Planning
Did you know Extended Text in #MSDyn365BC now works with Projects too? 📝 If you haven’t explored this yet, take 8 minutes to watch my
Ternary operator has been used for some time on a few programming languages. But now, with Business Central 2024 wave 2, AL developers can leverage
Business Central 2024 wave 2 will make a lot of people happy! Starting with version Business Central 2024 wave 2, users and consultants can now
“This” was introduced with Business Central 2024 wave 2. If you want to self-reference your codeunit in an external function call, or make field assignments
Performance Profiler was introduced a few versions ago and it proved to be one of the most useful tools in the hands of users to
For years, getting the version of the code deployed to a specific tenant, meant a trip to github/DevOps and pulling locally the version of the
With this new feature in Business Central 2024 wave 2, you can now create profile extension objects in your AL code. They can be used
Interfaces were introduced a few versions ago but now you can extend one or more existing interfaces when you declare an interface. When implementing an
We’ve seen in the last episode how we can integrate Business Central with Outlook here. Why be interested in Integrating Business Central with Microsoft Teams?
Come join our session on Ad-hoc analysis in Business Central on Wednesday October 16th, in Room 225D at the Convention Center in San Antonio. You’ll
To get started with Business Central integration with Outlook, you need to do some setup in Business Central and some setup in Outlook. More about
🚀 Just Released: “Beyond the Ledgers: Cutting-edge Data Insights with Business Central and AI” by Silviu Virlan! 📊Unlock the full potential of your data with
In this blog post will explore one of the learning paths for MB-820, the one that covers creation of a new company in Business Central.
Cloud Migration Tool is included with MB-820. Check out my video to learn more about it, and don’t forget to subscribe!
What is BCPT? BCPT (Business Central Performance Toolkit) lets you simulate concurrent usage of realistic scenarios with many users. To learn how to get started
Hello everyone, welcome back! This episode is part of the “Administer Dynamics 365 Business Central online – Training | Microsoft Learn” lesson and I will
Today I’m starting a new blog and video series dedicated to the new certification exam for AL developers: MB-820. The main topic of this blog
99% of the time I use the same coding patterns, and same commands, same data types … but once in a while you find something
A few days ago I wrote a blog about Actionable Errors. We learnt that Actionable Errors are designed to help users identify, navigate to, and
In case you haven’t seen an actionable error yet, here is one: With Business Central 2023 wave 2, AL developers got a tool, part of
My first conference, where I participated as a speaker, is a wrap. Organizers have mentioned this was the largest gathering of people since inception, which
This blog post and YouTube video has been addressed more extensively in my published book on Business Central ledgers. The book covers many, many other
This blog post and YouTube video has been addressed more extensively in my published book on Business Central ledgers. The book covers many, many other
New with Business Central 2024 wave 1 is the page Microsoft AppSource Apps. This page is pulling data from AppSource straight into a Business Central
Attention all Copilot enthusiasts! 🚀 The Dynamics 365 Business Central 2024 Wave 1 release now offers expanded Copilot capabilities. Check out my latest video where
This blog post and YouTube video has been addressed more extensively in my published book on Business Central ledgers. The book covers many, many other
This blog post and YouTube video has been addressed more extensively in my published book on Business Central ledgers. The book covers many, many other
The following demonstration was executed on a Cronus database for Business Central version 23.5. Purchase discounts in Dynamics 365 Business Central are a sophisticated feature
A natural follow-up to my previous blog post, Customer Ledger Entries in Business Central – Business Central Musings, on svirlan.com, which explored the Order to
This blog post and YouTube video has been addressed more extensively in my published book on Business Central ledgers. The book covers many, many other
On February 21st, 2024, the Dynamics Summit Roadshow in Tampa provided an exceptional platform for professionals across the Dynamics ecosystem, and it was here that
Average Days to pay invoices This customers’ metric is very useful to forecast cash flow. It is part of Business Central offering and can be
Working with ChatGPT and its plugins is an iterative process. We send a prompt, measure the completion, adjust the prompt, send it again for completion
🌟 Honored and thrilled to share that I’ll be a speaker at Dynamics Con 2024 in Denver 🏔️!🎤 Excited to delve into Dynamics 365 Business
Hello readers! A few days ago I stumbled upon a youtube video showing how you can create a chart of accounts for Quickbooks Online. But
Do you want to learn about the reasons behind their usage? Join me as I delve into the specifics of when and why these loading
Query output Analysis-Mode toggle was a missing feature pre-2023 wave 2. In fall of 2023, with the 2023 wave 2, we’ve got Analysis Mode on
In this video:
It’s funny how, with all this rush to get everything Copilot-ed, I became one of the few NAV experts in my team. And boy, there’s
Analysis Mode is a relatively new feature in Microsoft’s Business Central. I first heard of it in 2022, and during 2023 was heavily promoted at
Developing extensions for Microsoft Dynamics 365 Business Central can be a complex and time-consuming task, especially when it comes to keeping track of various components,
FieldGroups, originally a concept from Dynamics NAV, has undergone a migration to VS Code and AL. With the latest release of Business Central in 2023
Microsoft introduced data analysis mode on list pages in BC 2023 wave 1. It was discovered over the summer that not all list pages are
We can switch now between Released version of AL extension for VS Code and Pre-release (next release) all from VS Code. IntelliSense gets a refresh,
1. You can hover over labels now and you immediately see the string associated 2. You can produce the app files in a folder of
Check out my video on Inlay Hints for VS Code for AL developers. If you like it, please subscribe!
Since I started working with Business Central APIs, Postman proved to be an essential tool for API Testing. Postman allows you to create and execute
Hello readers, If you really were burning to find and read one more piece of teaching on permissions and access to BC, your search can
This is a second article targeting BC On-Prem installations. First one referred to auditing BC cmdlets usage using powershell transcription. Give it a read! PowerShell
Whenever you have a process that takes longer use the Performance Profiler page in Business Central, sometimes also called the in-client Performance Profiler, to record a snapshot
With Business Central 2023 Wave 1, Microsoft introduced a new way of composing permission sets. Find out more in my video …
With version Business Central 2023 wave 1, Microsoft has implemented a few changes around permissions. If you are a business user or functional consultant, there
One of the sessions I attended at Directions North America in May 2023 was Jesper Schulz’ session, “Enhanced Interactions using mail merge with Word Templates”.
This article could be useful for both business users and consultants as a follow-up to my previous blog post, which was centered on providing tools
Business Central Online is a cloud-based version of the software that is designed to be fast and efficient. Since Business Central Online is hosted in
Earlier in February 2023, I blogged about how AL compiler talks to SQL Server. Please visit my earlier blog here. I explained how basic AL
Many of us, AL developers, have seen the launch of Github Copilot late last year and some of us have already tried it. I recently
There are about 3500 apps for Business Central in App Source as of this moment built by ISVs for the Business Central community and who
I’ve been meaning for a while to blog about AL language methods and how the get translate into t-sql. In this blog post I will
A lot of us, Business Central professionals, have noticed recent changes to the Business Central Admin Center. The changes consist of a new action and
Who has not noticed a rad.json file during development or in the source code management blade in VS Code? I did, and I got curious
Most professionals working with BC online are receiving notifications of environment changes via email. But did you know that is possible to receive Business Central
As of December 2022, Microsoft offers a variety of communication channels to get notified when Business Central environments are affected. What events are considered to
Telemetry logs via AppInsights Logs In my previous blog post I experimented with 9 use cases involving 4 BC application extensions. I performed new installations,
Business Central is a cloud-based, modular business management solution that can be customized and extended through the use of extensions. These extensions are packages of
Intro About a year ago I wrote an article on the new features that Microsoft introduced on Business Central Admin Center. This time, in this
Intro In this article I will share my findings on how PowerShell transcription can answer audit questions related to extension management in BC. One of
Preamble Soon after starting to work with Business Central, users discover the hierarchical structure of how Microsoft flagship ERP system is designed. They soon hear
In the previous blog post I explained how we can leverage one of the Twilio’s products to send a WhatsApp message from Business Central. By
In this blog post I am going to dive into the use case of sending a WhatsApp message from Business Central utilizing Twilio framework. Most
An end-user wants the company address on all sales invoices, but, when printing checks, the address should be a different one.
Recently I received a question coming to the support ticketing system on how to get a listing of all folders inside c:\Users folder and their
While going through what is new in BC 2022 wave 1, I found out a cool tool. Here comes the new Performance Profiler. While many
Intro Business Central’s Page Inspection is a core component for Microsoft’s flagship ERP for SMB. Something similar existed in Dynamics NAV (zoom) and Microsoft carried
Hello readers, This morning I noticed we can create a sandbox with Business Central 2020 in Preview. In your BC admin center, click on +New
Happy new year, readers! Time for another Feynman technique exercise. Today I tried for the first time (Duh Silviu …. it’s been out there for
This post is about Cloud Migration changes in BC 19 wave 2. If you want to read more about the original Cloud Migration have a
Reasons why data size matters To see the current data size, for the entire database and per environment, in the admin center, click on the
Microsoft keeps adding new features to all facets of Business Central, including the admin center. In this blog post I will go over 5 changes
In Business Central, sales and purchase documents have lines and lines can be of different types: When editing a sales line document, a user would
With Business Central 2021 Wave 2 there is a new page to inspect the chart of accounts. Search for “Chart of Accounts Overview”. This new
News around Preview Posting in Business Central
With BC 2020 wave 2 a new feature was introduced that allows for background checks on journal lines. See more about this new feature here.
Hello Readers! A few weeks back, I watched Erik Hougaard‘s youtube video “Make your own Date Filters in AL and Business Central” and thought of
Hello readers! Recently I have been working on a customization for a customer with the goal of changing the out-of-the-box Positive Pay export for a
Did you ever need a DateTime field in your Business Central extension? I recently added, in one of my customer extensions, a DateTime field, and
There is also the GP migration tool. More about it here.
Using this tool ensures the most important entities, master data and open transactions, will make it into BC. But what if a GP end-user wants additional GP data in BC?
#Dyn365bc #dynamicsGP
As most probably know, it is not possible to access the file system while in Business Central cloud environment. For example, in Dynamics NAV, we
Preamble In the previous blog post I’ve described the usage of Power Automate when copying files from Azure Blob Storage somewhere locally. Today, we’ll learn
I found an older post on community.dynamics.com in which someone was asking for ways to automatically drop data extracts originated in BC SaaS into a
One way to make available data from Business Central to different parties and users is to leverage Azure Storage. Customers will need to have an
In the latest versions of Business Central one could find an Advanced Settings page. In the Navigation Bar, click on the magnifying glass icon on
When using web services or API exposed entities you might find useful to request the application service to grab the latest version of the underlying
Intro I started to use Postman for testing Business Central API recently, concomitantly with my engagement in projects involving migrating Dynamics GP customers to BC
Formatting Date fields in Word Layouts
How do we know at what level of hardware requirements will be enough to not only guarantee good performance at deployment, but down the line months and years from deployment?
MB-800 study materials
“Business Central customers can use up to 80 GB of database storage capacity across all of their environments (production and sandbox), meaning that the sum
While reviewing options to alter existing queries, I felt trap to the fact that now queries do not need a new page to display results,
RunRequestPage allows developers to record the request page settings of a Dynamics NAV/Business Central report without actually running the report. The output of this command
Starting in 2019 I found learning increasingly more about Docker and Microsoft Powershell libraries that get you a running instance of NAV or Business Central
One of the things I bumped into recently was to show a portion of an order confirmation(a portion of the header) only on the first
Long time no blog 🙂 A few days ago I tried to stop a NAS on a NAV 2009 server. The problem was that I
It’s 4 pm. To my surprise a skype call from one of the customers I usually talk maybe once a month. She cut the niceties
PowerApps – Intro What is PowerApps? PowerApps is a service for generating cross platform (iOS, Android, Windows Store) applications. It allows connectivity to different systems,
Problem A bit of context here … I was trying to create an environment in which to write an extension around workflows and notifications. I
As soon as I started working with Containers, more specifically with Azure Containers, around mid-December 2018, I quickly run into a few questions: how can
To start writing extensions for Business Central we have a few choices: installing locally one of the release candidates that comes in the same format
Recently Microsoft announced that dotnet can still be used with installations on premise of Dynamics 365 Business Central. However, if our extension is to make
When you turn On PerTenantExtensionCop in Visual Studio Code and you forgot to create a Permissions.xml file, you get a compile error in your extension.
So much to read, so little time … the speed at which Microsoft adds new Business Central and AL features is overwhelming 🙂 In this
As C/AL is my number one language to code, I wanted since last summer to give it a try to Microsoft Flow. And as Twitter
If there is something that changes in NAV every few releases, is how we backup and restore data (be that full backup, application data, companies
As stated here, beyond the setup and usage of dimensions, developing with NAV requires a better grasp of dimension’s internal design. I’ll be diving shortly into the
Recently I’ve been asked to explain the concept of dimension in NAV and while I managed to come up quickly with an answer I wanted
Thanks for landing here! Microsoft has developed a series of automated tests that allow developers to test various features of the standard application before releasing
We can still deliver our custom code as a fob in NAV 2017 as most VARs will continue to do so in the foreseeable future,
Thank you for landing here. It’s quite common nowadays to hear NAV people talking about Dynamics 365, AppStore, extensions, new AL language and the Visual
The first step in my last NAV upgrade was to back up customized tables. Although having database backups throughout your upgrade process is a no
Deferral accounts, or Prepaid expenses accounts, as defined by Larson, Jensen and Carroll(2002) are asset accounts. These deferral accounts contain payments made for assets to be used
Not long ago I stumbled upon a question on the popular NAV forum dynamicsuser.net. The question was “What is the use of CAPTIONCLASSTRANSLATE command in NAV?”.
Starting with NAV 2015 there is an easier way to migrate data between old and new structures of NAV tables. From msdn excerpt, the upgrade
As of October 2016, NAV 2017 is the latest version of the popular ERP system. To complement the brand new features, NAV team worked on enhancing current features.
Upgrading a NAV AddOn is not solely merging code and upgrading the database through all NAV versions in between source and target. It involves analysis and prototyping
More and more NAV servers are being deployed to the cloud, yet a large number of NAV customers are keeping their NAV installations on premise (either on a physical
From the earliest to the newest NAV versions, long-running tasks are usually accompanied by a progress bar or windows with multiple progress bars. It’s developer’s
I’ve done a few C/AL code merging for Dynamics NAV in the past, and while I don’t mind working with BeyondCompare for a few hours every now and
