NavWithNav - Business Central & AL Programming Blog

Latest Articles

Business CentralOct 11, 2026

Introducing 247HO.com — Timesheet Management Built for Freelancers and Contractors

We are proud to announce the official launch of 247HO.com — a dedicated timesheet management platform built exclusively for freelancers and contractors. Whether you are logging hours from home or on-site at a client location, 247HO provides a unified solution to track, submit, and manage your time with precision and ease. Your time is your business — and we are here to help you manage it.

Read article

Business CentralMay 11, 2026

How to Use Temporary Tables in Business Central AL for Fast In-Memory Data Processing

Temporary tables are one of the most underused and most powerful features in Business Central AL development. They let you process, transform, and present data entirely in memory without touching the database. In this post we cover exactly how to use temporary tables, when to use them, and real world scenarios where they can dramatically improve your extension quality and performance.

Read article

Business CentralApr 28, 2026

Stop Writing Slow AL Code — Common Query Mistakes in Business Central and How to Fix Them

Most Business Central performance problems are caused by poorly written AL code, not server issues. This guide walks through the six most common query and data retrieval mistakes BC developers make — including nested loops, late filtering, missing SetLoadFields, and CalcFields abuse — with real world before and after AL code examples for each.

Read article

Business CentralApr 21, 2026

Why Your Business Central Customizations Break on Every Update and How to Fix It Forever

Direct base app modifications are the number one reason BC customizations break on updates. Learn how to use AL Publishers and Subscribers to build event-driven, upgrade-safe Business Central extensions with full real world code examples for both built-in and custom events.

Read article

Business CentralApr 13, 2026

How to Call an External REST API from Business Central Using AL

Learn how to integrate Business Central with any external system using AL HttpClient. This step-by-step guide covers GET and POST requests, JSON handling, and the allowedExternalEndpoints setup required for BC SaaS environments.

Read article

Business CentralApr 11, 2026

How to Use FilterGroup in AL to Isolate Programmatic Filters in Business Central

When writing AL code in Business Central, applying filters directly on a record can silently conflict with filters your users have already set in the UI. This post shows you how to use FilterGroup to keep your programmatic filters isolated, predictable, and safe — without breaking anything the user has configured.

Read article

DevelopmentMar 30, 2026

OnAfterGetRecord vs OnAfterGetCurrRecord in Business Central AL — Know the Difference

Many AL developers unknowingly hurt list page performance by putting logic inside OnAfterGetRecord that fires for every rendered row. In this tip, we break down the key difference between the two triggers, when to use each, and a real code example that keeps your list pages blazing fast.

Read article