Inexplicable delays when calling (OnPrem) Business Central API’s (and how to solve it)
So, I was reminded recently during a twitter thread about an issue we had been having that we investigated quite thoroughly to figure out what was going on. The issue We always try to upgrade all customers to latest release – and we encountered some delays in API communications, which seemed to got worse at every new upgrade. At some point, every API call took from 500 to 1000… Continue Reading waldo’s Article on...
A Business Central “Upgrade Code” saga…
Not too long ago, we had an upgrade issue at a customer: the upgrade timed out, and after investigation, it was simply because our upgrade code: it took too long to modify 130000 records (well – and quite some validations, I admit, but still – it’s not that much, is it?). This made me hold on to some things that I had been doing even for my own apps (like the waldo.BCPerftool (which I’m now… Continue...
The Business Central “Data Search” app (under the hood)
One of the things that totally slipped by me, is the new app from Microsoft that apparently was released in the last wave called “Data Search“. It’s a simple, but powerful concept: Search for “any” record in your data. Well, any record that you have set up to search for at least ;-). It is explained here: Search for Specific Data – Business Central | Microsoft Learn Yeah, I know,… Continue...
What objects were added?
Yesterday, I got a question that I found was too difficult to answer: “What tables were added in 20.5?” The reason for this question was simple: we need to update the manually created permissionsets in order for new tables to be supported after an upgrade. So – what tables were added? There are a number of ways to deal with this, like exporting the AllObj-table from both versions, and do… Continue Reading...
Setting the Sampling Interval for (in-client) performance profiling Business Central
Here’s a small blogpost about an undocumented, but not uninteresting “feature” (at least not in my book ;-)). Performance Profiling You’re probably very much aware of the Performance Profiler in Business Central: an ability to monitor code execution in terms of “durations” and “hit count”, and having a view on how the code/process performed.As a first version, we had in v19 the AL…...
My BCTechDays 2022
This does not need any introduction or will not come as a surprise – BCTechDays is just around the corner. At the time writing this blogpost, it’s only a mere 20 days away – and quite honestly, I’m starting to crap my pants . Why? Excitement, fear, nerves – you pick ;-). Why? Well, because also this year, I’ll be quite busy: 2 sessions, 2 workshops and an ISV… Continue Reading...
Microsoft Dynamics 365 2022 Release Wave 2 plan for Business Central
You cannot have missed it: the “2022 Release Wave 2” plans are out! There have been blogs, there have been tweets, and yes, Erik Hougaard already did a video about it as well of course – and as I always do – I’ll go over the plan myself, focused mostly on the Business Central part – and within that focus, a focus on the tech part ;-). And this time .. In the current state of the plans .....
Boolean buttons messed up in Chrome and Edge – what now?
There has been a lot going on about this the past couple of days – especially on Yammer and social media. This post is merely to help spreading the information. TL;DR As a picture says more than a 1000 words – let me steal a picture from Natalie Karolak (follow her, if you don’t already – she’s THE BC Docs Librarian ;-)) from this thread on Twitter. Here is what you might have… Continue Reading...
Should Microsoft keep installing apps behind your back?
In a way – I’m not going to tell anything new here. Microsoft has been adding apps to your environment for many years already. It’s just that a recent discussion on Twitter basically led to a general – let’s say – “feeling”, that made me decide to share my view on the matter as well :-). TL;DR When you are in BC SaaS, your environment is getting upgraded automatically once per month...
BCTechDays 2022
After too long (last edition was in 2019), we finally can look forward to a new edition of THE best technical conference for Microsoft Dynamics 365 Business Central: BCTechDays (formally known as NAVTechDays). If you run through my blog (or simply search for “NAVTechDays“), you probably notice that I’ve always been ecstatic about this conference. And the reason is that BCTechDays simply… Continue Reading...
Microsoft Dynamics 365 Business Central “Offering Apps”
Don’t worry – you didn’t miss any information regarding Microsoft coming out with a new type of apps . This is merely a post where I’ll explain a solution that I had to go through, and some thoughts that might be interesting for you as well ;-). Previous post, I explained about a “booboo” that I did. Let me go a bit deeper into that, and explain why it’s still a path we’d like to pursue...
Offerings are not “offerings”, and library apps are not “library apps”
I did a “little” boo-boo: I totally misunderstood something from the overly documented AppSource world, which has quite an impact for us to go forward. I’d like to apologize beforehand for the rant I’m about to embark – I just wanted to make sure this only happens to us and not you ;-). What happened? We’re in the process of uploading all our apps to AppSource. In total about 45 apps,…...
15 years waldo’s blog
Hi y’all. Get ready for the most useless post you’ll read all day. Not to me, though. I’d like to share a proud moment with you awesome people. Today, I’m blogging for 15 years ! I remember back in the day when I got my MVP Award, I was so proud that I actually wanted to give back to the community. I know, “wanting to give back” after I received an award because “giving back” sounds...
Business Central SaaS Environment Triggers
So – thanks to my colleague Márton Sági (the AL Studio guy ;-)), I came across a quite interesting, but highly under-documented ability today in Business Central. One that makes the below post purely based on assumptions ;-), since it’s undocumented, and resides only in the platform part of Business Central (so there isn’t much code to drill down into ;-)). Here is my assumption-based… Continue Reading...
Business Central API – leave out CompanyId from the URL
Here’s a nice trick I wanted to share with you simply because I didn’t know this was possible (probably a lot of you already know, but if not – here you go ;-)). It could come in handy in some situations. You probably are very aware about how we’re supposed to use Business Central API’s in general. Like: Get the CompanyId from a “companies” endpointThen use that Id to get to the data…...
Microsoft Dynamics 365: 2022 Release Wave 1 plan (Business Central)
The “2022 Release Wave 1” plans are already out there for quite a while – Erik Hougaard already did his video about it – and there are already blogs out there about it – so it’s about time that I do that as well (as I have been doing that for the previous major releases as well ;-)). As always, I’ll be focusing on the Business Central part of the plans – and even more – usually I...
Multi-line text search in VSCode (with RegEx)
Small post – just because I needed it recently – and it made me think of this little gem that I still had to share: what if you have to search over multiple lines in multiple files in VSCode .. something that actually might happen more than you want to admit. I actually never knew how to do this decently, until I came across this tweet: Well… after some digging I found it… Continue Reading waldo’s Article...
Happy Holidays!
Hey y’all. I just wanted to send my Holiday wishes to the community I value so much. It’s been another crazy year in terms of the world being upside down by this freaking virus. However, it has also shown us how strong this amazing community is – finding new ways to connect, share insights, or just hang out: The Beerinar, Virtual Conferences like DynamicsCon, the BC Launch Event,… Continue Reading waldo’s...
The “Universal Code Initiative”
A few months ago, I blogged about a new initiative from Microsoft: Microsoft Dynamics 365 Business Central Publisher program. At Directions EMEA, we got more insights to the program. There is still the same focus and intention – but with a different approach and name. I’d like to go more into details on that, as it simply gives me an opportunity to say “I told you so” a number… Continue Reading...
Contributing to “ALGuidelines.Dev”
I recently blogged about this new initiative .. the revival of the “NAV Design Patterns Wiki”: ALGuidelines.Dev . Time to talk a bit more on how you can contribute. I’m documenting this while I’m writing my very first pattern (I admit, I had this blogpost laying around for a while ;-)). Disclaimer We do have a contribution-page here: “Guide to Fork & PR :: AL Guidelines” that kind of…...
The “ALGuidelines.Dev” initiative – revival of a diamond
The cat is already out of the bag – since a few days, people already discovered it .. but the plan was to “launch” the initiative today .. so .. here we go .. ;-). As you can see on one of my previous posts – I initially was planning to share a bunch of guidelines with you, starting with a first: a reference to the existing “NAV Design Patterns Wiki“. I did this simply because that is…...
Microsoft Dynamics 365 Business Central 2021 release wave 2 Launch Event
As I mentioned on October 1st – we have a new release: Microsoft Dynamics 365 Business Central 2021 release wave 2 is a fact! Since today, Microsoft released the recorded sessions that goes with this release. Earlier releases, we really got an online event, with Q&A capabilities and all. But since this release, we only get recordings. I can only assume it’s because we’re nearing the… Continue Reading...
AL Development guideline 1: the “NAV Design Patterns Wiki”
Not too long ago, I followed one of Steve Endow’s amazing livestreams where he was talking about BC Coding Guidelines together with Henrik and Jeremy. And what I noticed was that it appeared to be that “coding guidelines” – whatever they are for you – are hard to find – at least if you’re searching for guidelines in the new AL Language. I was like, wait a minute, I know I have been...
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...
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...
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...
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...
The complexity of complex return types (updated) – Looping a record return type
Update for my previous post: The complexity of complex return types. (I could have just updated the post, but since that wouldn’t trigger the people that already read it, I decided to create a small update just to pin your attention to the following.. After a few comments from Marknitek and Dennis Reineck, I realized that I forgot one important ability, that actually makes it (kind of)… Continue Reading waldo’s...
The complexity of complex return types
Since Business Central 2021 Wave 1 – v18, if you will – we are able to return about ANY type from a procedure. For many languages, that’s the most normal thing, but for Business Central’s AL language, it was not. So, at the time this was announced, many people were ecstatic and talking about it in sessions, on blog posts, on Twitter and so on. And me as well. In fact, I did a session on… Continue Reading...
Business Central Default APIs are not localized – or are they?
Good news. You’re probably all familiar with the great work Microsoft is doing on providing us a huge set of useful out-of-the-box API’s. No? Well, you can find all the information right here: API(V2.0) for Dynamics 365 Business Central – Business Central | Microsoft Docs For Belgium, these have been useless in many situations though. Simply said: the Belgian localization has some… Continue Reading...
Documenting your Business Central (custom) APIs with OpenAPI / Swagger
For reasons that are not too important, I am trying to find a way to “describe my custom APIs”. You know. You’re at a project, you had to implement an integration with a 3rd party application, and you develop some custom APIs for it. When done, you have to communicate this to the 3rd party for them to implement the integration, so you need to pass the documentation, and kind of help through… Continue Reading...
A somewhat easier way to generate a DGML Dependency Graph of your Business Central extensions
You might have read my post “Visualize app.json dependencies in VSCode (using GraphViz)” where I explained “another” way to generate a dependency graph. Another than what? Well – other than the DGML that was just announced on Microsoft’s Launch Event of Business Central 2020 Wave 2 as being “on the drawing board”. Well – today Stefano Demiliani found out that the first bits are...
Stabilize your Job Queue – a few tricks
For a few people, this will be a very “current problem”, for other, that have suffered through years of “unstable” NAS and Job Queue for that matter .. this upcoming blogpost might be interesting. The primary reason for this post is an issue that – after quite some debugging – seemed to be an issue introduced in version 17.4 (and currently also v18.0). But I decided to tackle the issue in a…...
Microsoft Dynamics 365 Business Central Publisher program
The last couple of months, there has been quite some questions from ISVs (and especially the “old” ISV’s) on how to register their apps in their specific situations. Just to name a few: I only have OnPrem business – and I want to create a new product. How do I get a new object range?Do I still need to go through the CfMD program to certify my apps?App range? RSP range? What the hell is… Continue Reading...
Design Considerations for Upgrade Codeunits
Recently, in our product, we enabled support for the new “Item References” in Business Central. Basically meaning: when upgrading to the new version of our product, we wanted to: Make sure our code supported the new “Item Reference” table in stead of the old “Item Cross Reference” tableAutomatically enable the “Item Reference” feature” (necessary, because when your code depends on...
Business Central Development Life Hacks
I haven’t exactly blogged much lately, but that doesn’t mean I haven’t been active for or in the community. You might have seen my previous blogpost for example, where I explored the wonders of streaming (which is for a near future to pick up, by the way ;-)), I also have contributed a few sessions on a few occasions. One of these occasions was “Dynamics Con” – a free conference that was…...
So .. I did a stream ..
Not too long ago, I asked about opinions on whether I should just keep blogging, or if I should also jump on the streaming-wagon like many already did .. and start streaming content about business central. In fact, that poll is still on my website, and today, it says this result: So, a vast majority isn’t really waiting for me to bring out any streaming videos :-). But .. in all… Continue Reading waldo’s Article on...
Setting up docker containers with apps from AppSource
For a long time, we have been looking for a solution to be able to set up a docker environment, and then download the necessary apps from AppSource. Why? For different reasons. Like, to set up a development environment. I know we can do that in an online sandbox, but .. we’re already doing this on docker for OnPrem development, so if we could simply set up dev environments for any… Continue Reading waldo’s Article on...
Which API’s are available in my Business Central environment?
Here’s a short post with a small tip about something a lot of you probably already know. How’s that for an intro . If you remember these posts: Getting not-out-of-the-box information with the out-of-the-box web clientCheck Customer License in an OnPrem db – from the web client Then you know there’s quite a lot of information .. just under your fingertips of the web client. And… Continue Reading waldo’s...
Microsoft Dynamics 365: 2021 release Wave 1 plan
It’s that time again! Recently, Microsoft released their plans for the next major version for Dynamics 365. Quite some time ago, I started with commenting on that (I actually did that because one of the features at that point (being “code customized base app”), was something that I felt needed some criticism (and still do, by the way ;-))). So, by matter of tradition – and it being a…...
Publish & Run Current Object from VSCode – with a single command
I’m not writing a blog about every single (new) command in my “CRS AL Language Extension”. But this Sunday, I added an interesting one. One that I should have had created for a long time – but simply didn’t think of it, until Daniel (TheDenster.com) explicitly asked for it on GitHub. Just imagine, you’re building an app, with many pages, and you want to build a page, test it, build the…...
Check Customer License in an OnPrem db – from the web client
This is my first post of 2021, so I’d like to take the opportunity to wish all of you all the best, all the health, all the safety, and .. may we finally meet again in person in 2021! I’d be very happy to have much less of this: And more of this: Anyway ;-). Let’s get to the topic.. I got an internal question from our consultants on how they are able to access the license… Continue Reading waldo’s Article...
Model Driven software development for Business Central with “mdAL”
You might already have seen my session on DynamicsCon about Design Patterns. During that session, I mentioned a tool “mdAL”. If not .. well, here it is (starting at the mdAL part): This tool has seen some major updates – time to blog about it. ;-). Disclaimer I am not the developer of this tool – so not a single credit should go my way. The main developer of this tool is… Continue Reading waldo’s...
Download all Microsoft Dynamics 365 Business Central Source Code with PowerShell
You might wonder: why would I need this? Why would I need to download source code of Business Central, while I can simply access it through the symbols when I’m working in VSCode – or even better, while I can simply click the symbol, and look at the code from there? Well … Searchability Didn’t you ever wonder: “hey, previous version, this codeunit was still in this app – where is it… Continue...
Run your own AppSource Validation
Quite honestly, I’m fully into the process of getting our apps (about 30 of them) to AppSource. We chose to have OnPrem implementations first, basically to get the experience, and also because it just still sells better in Belgium (immediate market ;-)). Anyway .. Recently, there was a call with Microsoft with the topic “what to do in order to pass technical validation”. Given my current… Continue Reading...
Business Central V17.1 fails your pipeline .. and that’s OK
A few days ago, we upgraded our product from 17.0 to 17.1. We had been looking forward to this release, because we usually never release a product or customer on an RTM release of Business Central. So .. finally 17.1, finally we could continue to upgrade the product and start releasing this to customers before the end of the year. While this was just a minor upgrade .. things started to… Continue Reading waldo’s Article on...
Visualize app.json dependencies in VSCode (using GraphViz)
If you’ve been following the latest and greatest from Microsoft Dynamics 365 Business Central, you must be aware about “what’s cooking in Microsoft’s Lab“. In short, Microsoft is working on a possibility to generate a DGML file for your extension that you’re compiling. A DGML file is basically a file that contains all code cross references. Remember “where used” .. well .. that! I can...
Upgrade to Business Central V17 (part 1) – The Workflow
Recently, we have been going through upgrading our 65 apps to the newest release (v17). You might wonder: upgrade? Wasn’t this supposed to be seemless? Well, let me explain what we did, how we handle stuff internally – and then maybe it does make sense to you why we take the steps we took for upgrades like this. DevOps It seems I can’t stop talking about DevOps ;-). Well, it’s the… Continue Reading...
Microsoft Dynamics 365 Business Central 2020 release wave 2 is Released!
Just a small reminder for you that yet another major release has been thrown our direction: v17 aka “Business Central 2020 Release Wave 2“. Old news, I know. But I blame the pandemic ;-). I already blogged about this upcoming release, and basically the list is quite the same.In fact, besides the official Microsoft Docs documentation, Natalie Karolak shared a smart way to filter for… Continue Reading waldo’s...
You wonder how? The answer is “DevOps”!
You must have seen this blog post from Microsoft: Maintain AppSource apps and per-tenant extensions in Dynamics 365 Business Central (online) And/or this blog of AJ: Business Central App maintenance policy tightened And/or this post from James: SaaS enables progress, why block it? If you didn’t, please do. Because as a Microsoft Dynamics 365 Business Central partner, your job… Continue Reading waldo’s Article on...