https://twity.de/ All Around Microsoft Dynamics Business Central en-us https://twity.de/performance-comparison-building-filters-with-textbuilder-in-al When working with AL (Dynamics 365 Business Central), we often need to dynamically construct complex filter strings. A common example is filtering users based on their User Security ID. For this purpose, AL provides the TextBuilder, a wrapper around the .NET StringBuilder, optimized for efficient string manipulation. Tue, 25 Nov 2025 10:29:08 +0100 https://twity.de/event-subscriber-performance The Situation With newer versions of Business Central, it's now possible to have multiple page and table extensions for the same objects within a single app. This flexibility allows us to build apps in a modular way and group functionality together thematically. Tue, 11 Nov 2025 12:37:45 +0100 https://twity.de/business-central-tryfunction-performance-overhead While investigating the Business Central 26 CallStack performance improvements, I stumbled upon an interesting question: Does the TryFunction attribute add significant overhead when there are simpler alternatives? The answer might surprise you. Tue, 04 Nov 2025 10:49:49 +0100 https://twity.de/business-central-26-callstack-performance-improvement Back in 2016, I wrote a blog post about how to check if your code was being called from a specific function using a try function and an empty error to access the callstack via GETLASTERRORCALLSTACK. For example, checking if you were inside a SaveReportAsPDF function. This technique was useful but came with a performance penalty. Mon, 27 Oct 2025 15:45:34 +0100 https://twity.de/debunking-a-decades-old-myth-in-business-central-efficiently-retrieving-grouped-data In many Business Central implementations, there’s a recurring need: extract a distinct set of document identifiers from a filtered set of detail records. Whether you’re working with sales lines, purchase lines, ledger entries, or custom transactional data — the goal is the same: identify which documents are involved based on line-level criteria. For years, a particular coding pattern has circulated as “best practice” in many organizations. It looks something like this: Fri, 24 Oct 2025 12:06:25 +0200 https://twity.de/business-central-140-symbols Business Central 140 has two ways to work with symbols. Way 1 – The default way Fri, 24 Oct 2025 11:59:24 +0200 https://twity.de/create-dynamics-nav-docker-images-with-a-custom-sql-database I created a simple Dockerfile and a Powershell script to create an custom docker image based on an offical Microsoft image. Based on an custom image you can create multiple Test and/or Development Environments with an minimum storage footprint. Fri, 24 Oct 2025 11:59:24 +0200 https://twity.de/debug-httpclient-request-inside-a-container If you use a BC Container to develop a WebService connetction, it is hard to analyse the traffic with only the Debugger. Fiddler Classic can be used to solve this problem. Fri, 24 Oct 2025 11:59:24 +0200