Submitting to Business Central Open Source, the code review…
Dec12

Submitting to Business Central Open Source, the code review…

So to continue where we left off yesterday when I did a pull request on the Business Central System App project on GitHub. After my pull request someone at Microsoft did a code review in order to make sure quality standards are respected. Here are the details: I have to admit something. First of all, this is not actually my code. It came from my colleague Michael Nielsen. Secondly… Continue Reading Mark Brummel’s Article...

Read More
Business Central System App is Open Source! Contribute, don't be shy…
Dec11

Business Central System App is Open Source! Contribute, don't be shy…

With the recent Wave II release of Business Central we also got the first wave of Open Source in our beloved NAV/BC product. This means that rather than making customization for one specific customer or ISV you can now have this pushed back into the product and stay there forever. Today I did my first Pull Request and I wanted to share how I did that. What did I need? With reports,… Continue Reading Mark Brummel’s Article...

Read More
Tip #65 | AppSourceCop & mandatoryPrefix
Dec05

Tip #65 | AppSourceCop & mandatoryPrefix

Today I was a bit puzzled by getting this error message and how to fix it. error AS0054: The AppSourceCop configuration must specify one of the following properties: ‘mandatorySuffix’, ‘mandatoryPrefix’, or ‘mandatoryAffixes’ Yes, you can google the message but that only brings you to pages that describe the message, not how to fix it. It appears to be easy so I wanted… Continue Reading Mark...

Read More
AL Extensions – File Naming and Organizing
Dec01

AL Extensions – File Naming and Organizing

This is a blog that I wanted to write for quite a while, but it’s only until last week or so that I think I’ve found what I like to call, a “best practice” or if you will, a “Design Pattern”. What is this all about? With the move from C/AL to Visual Studio Code we also moved to file based instead of stored in database. This means we also have to give these files a name and we… Continue Reading Mark Brummel’s Article on...

Read More
Managing DotNET Dependencies on AppSource for Business Central
Nov30

Managing DotNET Dependencies on AppSource for Business Central

When you try to convert existing C/Side objects to AL the first attempts are typically done while scoping OnPrem. This gives an overview of the errors to be fixed w.o things like DotNET. In this phase you typically switch between C/Side and Visual Studio Code all the time fixing the errors one-by-one and reconverting. Once the errors are fixed the software can be tested and deployed… Continue Reading Mark Brummel’s Article...

Read More
Monolith ≠ NoOfObjects | Breaking up your extension
Nov25

Monolith ≠ NoOfObjects | Breaking up your extension

If you have IP for Microsoft Dynamics NAV in C/Side your are either in the process of moving it to AL and Business Central or you are busy finding a buyer for your company. Both seem to be very valid options these days. When you talk to the engineers who are busy executing this task the number one question on their mind, once they got their stuff decoupled from BassApp, is how to break up… Continue Reading Mark Brummel’s...

Read More
NAVTechDays – It’s a peoples event…
Nov24

NAVTechDays – It’s a peoples event…

It’s the weekend after NAVTechDays and I rested from a busy week. Two days of pre-conference training and two days of talking at (a lot of) people mostly at the ForNAV booth but also at the booth of Meta UI, Continia, SQL Perform, Anveo, Prism and AL Ops. Design Patterns, once again Teaching the Design Patterns for AL the first time was fun, challenging and exhausting. It was fun because… Continue Reading Mark...

Read More
WARNING – The Data Upgrade Elephant
Nov18

WARNING – The Data Upgrade Elephant

Last Thursday I was at the QBShare event in Veghel, Holland. I’ve been attending these events ever since I joined ForNAV a few years back and since the audience is a bit different from my normal events (CEO vs. Developers) it took me a while to get to know people. No matter who you talk to at these events, all that they have on their minds is moving their IP to Business Central and most… Continue Reading Mark Brummel’s...

Read More
#BCALHelp
Nov17

#BCALHelp

It’s the week of NAVTechDays, the biggest Business Central Community event of the year and I thought it would be good to spend a few moments on the state of our community. Business Central is taking off. According to Microsoft there are more than 4000 paying tenants and the average number of users per tentant is 10+ which is the sweetspot where Navision used to be strong. I can also see… Continue Reading Mark...

Read More
Working with dates in AL vs. C/AL
Nov08

Working with dates in AL vs. C/AL

It’s friday afternoon and I’m goofing around a bit with the ForNAV AL Converter. I ran into something I want to share. AL seems to be more strickt in hardcoded dates than C/AL. Example < pre class=”wp-block-preformatted”>Constant value ‘99993112D’ is outside the range for a Date. The syntax for defining Date format is yyyymmddD, where D is a mandatory letter. For example, 20180325D, read as the...

Read More
Direct Printing to Label Printer from Business Central – YouTube
Nov04

Direct Printing to Label Printer from Business Central – YouTube

Preparing my webinar for Thursday with ForNAV source

Read More
Mapping Codeunit 10201 “Transfer Custom Fields” to Events (NA Only)
Oct30

Mapping Codeunit 10201 “Transfer Custom Fields” to Events (NA Only)

By Steve Krisjanovs Below is a list of all COD10201 external functions and where I believe their event equivalents live in. There were three functions in the list below that had me stumped so a second set of eyes would be helpful. I do still believe that BC’s out of the box COD10201 should still have been modified by MS to indicate that all of these external functions are dead. The… Continue Reading Mark Brummel’s...

Read More
AppSource; Prefix, Suffix & Intellisense
Oct30

AppSource; Prefix, Suffix & Intellisense

This article was triggered by a discussion on Yammer yesterday that I felt went a bit sideways. Business Central is a first class cloud citizen and it beats born in the cloud solutions easily but fact remains that it’s based on Navision, an ERP solution with a 30-some year legacy. Part of that legacy is a requirement for unique names in the objects, also in the cloud. Microsoft is… Continue Reading Mark Brummel’s Article...

Read More
Tip #64 | Show License Information in Business Central
Oct29

Tip #64 | Show License Information in Business Central

With the retirement of C/Side we have a challenge we did not have before regarding the license. We used to be able to see the license information from C/Side, upload the license and quickly create a new page that displays permissions. With Business Central this is no longer possible and we now need PowerShell to upload a license. On my GitHub you can find a repo you can clone to… Continue Reading Mark Brummel’s Article on...

Read More
Tip #63 | Export Warnings & Errors from Visual Studio Code
Oct24

Tip #63 | Export Warnings & Errors from Visual Studio Code

If I get asked the same question twice I am already tempted to blog about it. This one exceeds this number and is long overdue. It looks like the whole world is now converting from C/AL to AL and running into challenges with that. Right now I am analysing several databases and one thing you need after elliminating low hanging fruit and removing errors that crash the compiler is to find… Continue Reading Mark Brummel’s...

Read More
Business Central & Nintendo
Oct17

Business Central & Nintendo

WARNING!! Personal opinion here! Inspiration to write down idea’s are everywhere. Next week my youngest son has his birthday and we went out this evening with the train to the big city of Deventer to buy him (us) a Nintendo Switch. I’ve been loyal to Nintendo since the 1980ies and bought many of their consoles. I’m also loyal to Mario and have most of the games. When the Nintendo WII… Continue Reading Mark...

Read More
Directions EMEA 2019 Afterthoughts
Oct11

Directions EMEA 2019 Afterthoughts

It seems that when my blog posts appear some people hold their breath. Don’t worry, that won’t be nessesairy this time. I am at the Vienna airport and just wanted to write some thoughts I have after the event. When I look at 2.500 people wondering around I don’t see a community. I see individuals. We call it a community because we share the love of a product but we need to move to the… Continue Reading Mark...

Read More
Tip #62 | “Where-Used” in Visual Studio Code
Oct02

Tip #62 | “Where-Used” in Visual Studio Code

The “Where-Used” in Visual Studio Code is nice, but not always productive. Today I wanted to see where a field was used and came up with an alternative I wanted to share. ObsoleteState If you mark a field ObsoleteState::Pending the compile will throw warnings everywhere the field is used. This allows you to quickly use the error window to jump through the code and check whatever you want… Continue Reading Mark...

Read More
What if…
Sep22

What if…

Sometimes I can be a bit emotional when it comes to changes in the software product I work with on a daily bases. An example of that was my previous blog that I took offline in order to do some editing making it less about emotion and more about facts. The emotion is probably justified for a few reasons of which most the fact that Navision, NAV, Business Central (I stopped caring about the… Continue Reading Mark Brummel’s...

Read More
How Do I – Prevent an epic clusterfuck…
Sep17

How Do I – Prevent an epic clusterfuck…

Now that the NDA on Business Central Wave II has been lifted and the DVD preview is released partners got time to look at the code Microsoft has refactored. The reactions vary from being marketing correct to more realistic. I have a strong opinion about what Microsoft did, and especially how they did it. First of all, I agree that it’s a great idea to split NAV up into modules and I… Continue Reading Mark Brummel’s...

Read More
Working with Azure Blob and NAV
Sep16

Working with Azure Blob and NAV

This is something that’s long overdue, I wanted to write this before my summer vacation. My reason for holding back is that I want to share all the code for this project and this needs cleaning up. This is still not done and if you want the code you’ll have to contact me. Why am I still writing this? I am actually writhing this from the “International” airport of Cork Ireland where I… Continue Reading...

Read More
Tip #61 | .gitignore for AL projects
Sep11

Tip #61 | .gitignore for AL projects

The Business Central Community loves Git, but GitHub does not seem to even know we exist. It recognises our projects as perl projects and there is no suggestion for a .gitignore file. Why .gitignore? It’s generally considered best practice to use Git for managing uncompiled code, but not to store the result of a project, nor it’s dependencies. Also, settings that may vary from… Continue Reading Mark Brummel’s...

Read More
Tip #60 | Suppress Warnings in Visual Studio Code
Sep11

Tip #60 | Suppress Warnings in Visual Studio Code

One of the most anoying things about writing AL code in Visual Studio Code is getting warnings that you cannot fix. Simply impossible. My “favorite” warning is this one For almost a decade it’s been possible to sort on flowfields from code and in reports and in most cases it works fine. On larger datasets it might require a covering index for performance. This warning is a joke… Continue Reading Mark...

Read More
Tip #59 | Multiple Start Configurations in Visual Studio Code
Sep11

Tip #59 | Multiple Start Configurations in Visual Studio Code

When developing extensions for Business Central you have a wide array of publishing options to choose from. My most used options when working on the ForNAV Customizable Report Pack are our Sandbox and Docker. Testing is best on the Sanxbox for two reasons. First because all the Azure Active Directory stuff actually returns something which is useful for licensing scenario’s. Second… Continue Reading Mark Brummel’s...

Read More
Episode 4 – BC Fall Release | Give Feedback
Aug26

Episode 4 – BC Fall Release | Give Feedback

Feedback is critical for Microsoft to improve Business Central and all of their other products. For this reason a preview is published of the upcomming release this fall. You can install this using Docker and I’ve been told a DVD will be made available soon. This release will be the biggest change since the introduction of the Three Tier model and Role Tailored Client and fits into the… Continue Reading Mark...

Read More
Episode 3 – BC Fall Release | Finding Stuff
Aug25

Episode 3 – BC Fall Release | Finding Stuff

UPDATE!! Microsoft is listening!! Big news, it seems that Microsoft is fixing the issues we’ve found in our App for AppSource. Both the functions on the TempBlob and the Language table will be added back! But also, let’s continue where we left off with the previous episodes because there are more challenges that won’t be fixed. Let’s see if we can fix some reference problems. Before… Continue Reading Mark...

Read More
Episode 2 – BC-Fall Release Wave II | Checking Your Extension
Aug15

Episode 2 – BC-Fall Release Wave II | Checking Your Extension

Before we dive into the list of (breaking) changes that I’ve discovered so far, I will first explain how to check your extension against the preview of the fall release. This is mostly interesting for those who are on AppSource or partners who have refactored their IP into On Prem extensions. I’m going to assume all of them have access to the Ready to Go program. If not, send me a message… Continue Reading Mark...

Read More
Episode I – BC-Fall Release Wave II | The Upgrade Dream Shattered
Aug14

Episode I – BC-Fall Release Wave II | The Upgrade Dream Shattered

Be careful what you ask for, you might actually get it. This phrase illustrates what we will see when Microsoft releases Business Central Wave II this October where C/Side is removed in favor of Visual Studio Code, The Windows Client discontinued in favor of the Web Interface and the old Navision application is broken into two parts and very heavy refactoring has taken place. For years,… Continue Reading Mark Brummel’s...

Read More
Opinion – What will happen in fall with Business Central
Jul12

Opinion – What will happen in fall with Business Central

As far as I remember, social media around Business Central/NAV(ision) has never been as quiet as in the last months. There is nothing from the MVP’s anymore and it seems the majority of partners are in the dark about that’s going on at Microsoft. While this is true, Microsoft is updating the GitHub with the new AL foundation periodically with new code but without explaining the strategy…. Continue Reading Mark...

Read More
Meta UI Control Add-Ins for Business Central, how and why…
Jul03

Meta UI Control Add-Ins for Business Central, how and why…

Today we’ve successfully completed a workshop at Vos Transport with Global Mediator where we did a demo/prototype of a new user interface defined on metadata embedded in Microsoft Dynamics NAV using client add-ins. We’ve been working on preparing this workshop for over 12 months and I am very happy and proud of the result. Client Add-Ins Within Microsoft Dynamics NAV, client… Continue Reading Mark Brummel’s...

Read More
Extending Role Centers
Jul01

Extending Role Centers

There should be a simple rule that applies to all members of our community. If you struggle with something and find out the answer, then share it. If everyone starts doing that I’m sure it will improve our community and bring back some joy in the world were even most MVP’s just blog so sell their marketing messages. Again, today I wasted much valuable time of my life chasing weird behaviour… Continue Reading Mark...

Read More
Extensions | An item with the same key has already been added
Jun28

Extensions | An item with the same key has already been added

If you work with Extensions in Dynamics NAV there is a fair chance that you’ve seen this message. Today I got it again, waisted half an hour of my live and decided to blog about it. What happened is that I have a Page Extension with the same variable name as already exists in my C/Side page. I’m working with NAV2018 CU17 and the compiler did not complain about this and the publishing… Continue Reading Mark...

Read More
‘Codeunit’ does not contain a definition for… (AL0132)
Jun25

‘Codeunit’ does not contain a definition for… (AL0132)

Today I got this error message while publishing an extension to our Development system. Since our Development system just moved to Azure last week our Azure Specialist and I spent some time troubleshooting this. As always with these things the root cause was not in Azure SQL, but in my C/AL code in C/Side. Our database is hybrid and what I did is removing a codeunit. This was a cleanup… Continue Reading Mark Brummel’s...

Read More
C/SIDE Development 101 #12 – Closing session – YouTube
Jun18

C/SIDE Development 101 #12 – Closing session – YouTube

In this webinar we close the C/Side development with stories and anektotes from two decades of C/Side and see where we are today source

Read More
C/SIDE Development 101 #11 – C/AL – Useful system and application functions – YouTube
May21

C/SIDE Development 101 #11 – C/AL – Useful system and application functions – YouTube

Both the system (platform) and the application have tons of very useful functions. This sessions will shed light on a number of them illustrated by various code examples. Book: Chapter 7 & 9 Presenter: Peter Wijntjes Moderator: Rob Sanchez source

Read More
Programming Microsoft Dynamics 365 Business Central – Sixth Edition | Mark Brummel Blog
May04

Programming Microsoft Dynamics 365 Business Central – Sixth Edition | Mark Brummel Blog

It’s a wrap. After 9 months of work the latest edition of the programming book is finished. This is the sixth edition but the first to be AL only. A very specific choice that I made when I started on the project. And a bit of a gamble since I was unsure how long C/Side would last when we started. When you buy the book you will recognise the script and programming examples. This is… Continue Reading Mark Brummel’s Article...

Read More
C/AL to AL, but better & faster | Mark Brummel Blog
Apr17

C/AL to AL, but better & faster | Mark Brummel Blog

At the airport of Copenhagen (CPH) eating my favorite burger. (Aamanns Burger). Then writing a blog. This is an awkward blog, a blog that was asked for by my colleague Jan when I spent a few days at our office. He asked if I could blog something about converting from C/AL to AL with the ForNAV converter based on the series of blogs by Freddy. (

Read More
Eternal Refactoring | Are you ready? | Mark Brummel Blog
Apr16

Eternal Refactoring | Are you ready? | Mark Brummel Blog

Microsoft Dynamics 365 Business Central is the best and most customizable ERP that ever existed. There, you have it. For some people it’s hard to understand that in one blog I am trying to protect our ecosystem from loosing C/Side and in the next I am praising Business Central to be miles better than any other cloud ERP. The reason is honesty and reflection. If you don’t… Continue Reading Mark Brummel’s Article on their...

Read More
Why C/Side will last another decade… at least… | Mark Brummel Blog
Apr03

Why C/Side will last another decade… at least… | Mark Brummel Blog

The move by Microsoft from C/Side to Visual Studio Code is a bit like Brexit. At first everybody thinks it is a great idea, until they realise the consequences. And then there is no way back. Why? Please let me explain… With C/Side we have issues, everybody knows that and these issues have to be solved. Issues like integration with source code management and other issues like…… Continue Reading Mark Brummel’s Article on...

Read More
C/SIDE Development 101 #10 – C/AL – How to access the data – YouTube
Mar26

C/SIDE Development 101 #10 – C/AL – How to access the data – YouTube

In Dynamics NAV, being a database application, a substantial part of our coding is about accessing this database. Retrieving and updating the data. What are the typical methods and coding patterns to achieve that? Presenter : Luc van Vugt Moderator : David Singleton source

Read More
Converting from C/Side to AL – Dynamics 365 Business Central – YouTube
Feb28

Converting from C/Side to AL – Dynamics 365 Business Central – YouTube

In this webinar we will show two use cases of converting from C/Side to AL. It;s full of tips and pointers. We also address the differences between the ForNAV converter and the standard Microsoft tooling. source

Read More
C/SIDE Development 101 #9 – C/AL – How to write C/AL – YouTube
Feb27

C/SIDE Development 101 #9 – C/AL – How to write C/AL – YouTube

Now that you know where “C/AL is hiding”, this session will take a little bit more formal approach on how to write C/AL: the syntax. Book: Chapter 6 & 7 Presenter: René Brummel Moderator: David Singleton source

Read More
Convert Dynamics NAV C/Side to AL for Business Central Extensions – YouTube
Feb08

Convert Dynamics NAV C/Side to AL for Business Central Extensions – YouTube

With the 100% free converter from ForNAV you can convert from Any version of Dynamics NAV 3-tier to Business Central directly from C/Side without any hassle. Download for free from www.fornav.com source

Read More
C/SIDE Development 101 #8 – C/AL – Where does C/AL hide – YouTube
Jan29

C/SIDE Development 101 #8 – C/AL – Where does C/AL hide – YouTube

In this first webinar on the real coding part of this series we will look at simple code examples and where to put them in the different objects. source

Read More
Real life experiences with Per Tenant Extensions – Business Central – YouTube
Dec18

Real life experiences with Per Tenant Extensions – Business Central – YouTube

In this webinar Dmitry Katson explains the learnings from working with per tenant extensions in Microsoft Dynamics 365 Business Central source

Read More
Xliff Compare & Finding Missing Translations | Mark Brummel Blog
Dec09

Xliff Compare & Finding Missing Translations | Mark Brummel Blog

When working with Extensions I would not recommend working with Xliff files unless you design for AppSource. Otherwise CaptionML will work fine for Per-Tenant projects. Unfortunately for me, I am working right now on submitting an AppSource project and I need to evaluate if my translations are complete. As I explained at my presentation in Antwerp at NAVTechDays we continue to code… Continue Reading Mark Brummel’s Article...

Read More
Compiling a 2000+ Objects Extension | Mark Brummel Blog
Dec02

Compiling a 2000+ Objects Extension | Mark Brummel Blog

Let’s start diving into working with Extensions in Real Life. I have a lot to blog about and at first I thought I would blog about a very small extension but I’m sure you’ve all seen that. At NAVTechDays I showed you the extension I created with the ForNAV converter that resulted in 2149 files which compiles and executes. I made the extension work on Business Central OnPrem,… Continue Reading Mark Brummel’s Article on...

Read More
Blogging & “The Gap” | Mark Brummel Blog
Nov25

Blogging & “The Gap” | Mark Brummel Blog

A little over a week ago I attended the Dutch Dynamics Community again, for the first time in a while. It was good to catch up and exchange news with peers in my network. “You’ve been quiet Mark!” is what I’ve been told a few times and that’s true. For some time I try to be quiet and focus on things that are more personal like being a dad of five now and trying to manage the… Continue Reading Mark Brummel’s Article on...

Read More
NAVTechDays 2018 | Muppet Show – YouTube
Nov25

NAVTechDays 2018 | Muppet Show – YouTube

Waldo & Vjeko opening their session with the Muppets show. Great performance. Recorded by Tino Ruijs. source

Read More
Symbols of madness | Mark Brummel Blog
Nov05

Symbols of madness | Mark Brummel Blog

As you know we have been happily developing extensions for a while now. Every once in a while I blog about some stuff I found out recently but it is mostly smooth sailing at the moment. Today I was stumped though. For some reason my symbols were not loading. I make it a point to always develop extensions on a standard NAV2018 database (our current version, move to BC on prem is planned but… Continue Reading Mark Brummel’s...

Read More