---
id: video/OLN-2Ec2GMM
type: video
title: "What’s New: AL Runtime and Database (2024 release wave 1)"
summary: "AL runtime and database changes in Business Central 2024 release wave 1: new number sequence methods (restart, range start), change log cleanup and an on-premises alter key method, table-level field tooltips, test field navigation links, and the move to .NET 8 and PowerShell 7."
tier: official
language: en
tags:
  - number sequence
  - change log cleanup
  - alter key
  - field tooltips
  - translatable texts
  - actionable errors
  - test field
  - error handling
  - .net 8
  - powershell 7
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:10:47.726Z"
  flags: []
generated:
  at: "2026-10-07T23:10:47.779Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 626eb0d54fcb34a73a341418c15abf3f5cac0ee08b588768571446c1d0b097b6
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=37s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 37
    quote: next current exist methods are up to 32% faster
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=108s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 108
    quote: so you're basically saving a datab base call for every time you need a number so if if you have a range of 100
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=145s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 145
    quote: change log entry tables growing to very large sizes to the point where even setting up retention policies would time out
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=307s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 307
    quote: with this release wave as developer you can now Define field tool tips once on the table and any page uh that that use
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=544s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 544
    quote: we've added new capabilities to test field so that it can add link to add a navigation link to the failing data
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=730s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 730
    quote: for this release we have switched to net 8 which is a faster and more efficient runtime
  - kind: video
    url: https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=750s
    title: "What’s New: AL Runtime and Database (2024 release wave 1)"
    date: "2024-04-04T13:30:11.000Z"
    commit: null
    t: 750
    quote: with doet 8 we're moving to Powers shell 7
links:
  learn: []
  objects:
    - object/table/98
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: OLN-2Ec2GMM
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=OLN-2Ec2GMM
published_at: "2024-04-04T13:30:11.000Z"
duration_s: 1025
captions: full
audience:
  - developer
  - administrator
  - functional consultant
chapters:
  - t: 0
    title: Number Sequence enhancements
  - t: 145
    title: Change log cleanup and alter key method
  - t: 272
    title: Field tooltips on table level
  - t: 348
    title: Translatable text storage system
  - t: 470
    title: Actionable error improvements and test field navigation
  - t: 658
    title: Error handling documentation
  - t: 710
    title: Runtime migration to .NET 8 and PowerShell 7
  - t: 822
    title: Summary and takeaways
  - t: 902
    title: Related sessions and resources
features:
  - name: Number sequence next/current/exist methods performance
    status: unclear
    t: 37
    verified: false
    status_source: video
  - name: Number sequence restart method
    status: unclear
    t: 57
    verified: false
    status_source: video
  - name: Number sequence range start method
    status: unclear
    t: 88
    verified: false
    status_source: video
  - name: Change log entry cleanup optimization
    status: unclear
    t: 145
    verified: false
    status_source: video
  - name: Alter key method for on-premises
    status: unclear
    t: 185
    verified: false
    status_source: video
  - name: Removal of force order and loop join server settings
    status: unclear
    t: 272
    verified: false
    status_source: video
  - name: Field tooltips on table definition
    status: unclear
    t: 307
    verified: false
    status_source: video
  - name: System tables for translatable texts
    status: unclear
    t: 429
    verified: false
    status_source: video
  - name: Actionable errors with test field navigation
    status: unclear
    t: 544
    verified: false
    status_source: video
  - name: Error handling documentation expansion
    status: unclear
    t: 658
    verified: false
    status_source: video
  - name: Runtime migration to .NET 8
    status: unclear
    t: 710
    verified: false
    status_source: video
  - name: PowerShell 7 migration and backward compatibility bridge
    status: unclear
    t: 750
    verified: false
    status_source: video
objects_mentioned:
  - other number sequence
  - other change log entry
  - other test field
  - table general ledger setup
  - other currency card
quotes:
  - t: 37
    text: next current exist methods are up to 32% faster
    check: exact
  - t: 108
    text: so you're basically saving a datab base call for every time you need a number so if if you have a range of 100
    check: exact
  - t: 145
    text: change log entry tables growing to very large sizes to the point where even setting up retention policies would time out
    check: snapped
  - t: 307
    text: with this release wave as developer you can now Define field tool tips once on the table and any page uh that that use
    check: exact
  - t: 544
    text: we've added new capabilities to test field so that it can add link to add a navigation link to the failing data
    check: exact
  - t: 730
    text: for this release we have switched to net 8 which is a faster and more efficient runtime
    check: exact
  - t: 750
    text: with doet 8 we're moving to Powers shell 7
    check: exact
---

# What’s New: AL Runtime and Database (2024 release wave 1)

> AL runtime and database changes in Business Central 2024 release wave 1: new number sequence methods (restart, range start), change log cleanup and an on-premises alter key method, table-level field tooltips, test field navigation links, and the move to .NET 8 and PowerShell 7.

[Watch on YouTube](https://www.youtube.com/watch?v=OLN-2Ec2GMM) · Microsoft Dynamics 365 Business Central (YouTube) · 2024-04-04 · 17:05 · tier official · reviewed (checked by Opus)

## Overview

The session covers developer-facing runtime and database updates in 2024 release wave 1. Number sequences get faster next, current and exist methods (up to 32%), a restart method, and a range start method that fetches an interval in one call. Change log entry deletion is optimized for very large tables, and an on-premises alter key method disables keys for the current transaction to speed up bulk deletion.

It also covers field tooltips defined once on the table, new system tables for translatable texts, test field adding navigation links to failing data, expanded error handling documentation, and the server runtime move from .NET 6 to .NET 8 and from PowerShell 5 to PowerShell 7 with a backward compatibility bridge.

## Key points

- Number sequence next, current and exist methods are up to 32% faster. A new restart method resets a sequence to a given number without dropping and recreating it.
- The range start method gets an interval of numbers in one call, so a range of 100 needs 1 database call instead of 100.
- The alter key method disables keys for the current transaction to speed up bulk deletion of change log entries. It is marked on-premises only, and keys are re-enabled when the transaction ends.
- The force order and loop join server settings are removed in this release. They were deprecated in version 23.
- Field tooltips can be defined on the table and are inherited by pages using the field. Page-level tooltips can still override them.
- Test field adds a navigation link to failing data when conditions are met: read permission, available drill down page ID and card page ID, and a target that is a different page or record.
- The runtime moves to .NET 8 and PowerShell 7. A bridge through the nav admin tool relays PowerShell 5 calls, but scripts that import assemblies directly may need minor changes.

## Chapters

- [0:00](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=0s) Number Sequence enhancements
- [2:25](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=145s) Change log cleanup and alter key method
- [4:32](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=272s) Field tooltips on table level
- [5:48](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=348s) Translatable text storage system
- [7:50](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=470s) Actionable error improvements and test field navigation
- [10:58](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=658s) Error handling documentation
- [11:50](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=710s) Runtime migration to .NET 8 and PowerShell 7
- [13:42](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=822s) Summary and takeaways
- [15:02](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=902s) Related sessions and resources

## Features

| Feature | Status | At |
|---|---|---|
| Number sequence next/current/exist methods performance | status not stated | [0:37](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=37s) |
| Number sequence restart method | status not stated, demoed | [0:57](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=57s) |
| Number sequence range start method | status not stated, demoed | [1:28](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=88s) |
| Change log entry cleanup optimization | status not stated | [2:25](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=145s) |
| Alter key method for on-premises | status not stated, demoed | [3:05](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=185s) |
| Removal of force order and loop join server settings | status not stated | [4:32](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=272s) |
| Field tooltips on table definition | status not stated, demoed | [5:07](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=307s) |
| System tables for translatable texts | status not stated | [7:09](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=429s) |
| Actionable errors with test field navigation | status not stated, demoed | [9:04](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=544s) |
| Error handling documentation expansion | status not stated | [10:58](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=658s) |
| Runtime migration to .NET 8 | status not stated | [11:50](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=710s) |
| PowerShell 7 migration and backward compatibility bridge | status not stated | [12:30](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=750s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- other "number sequence" at [0:37](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=37s)
- other "change log entry" at [2:25](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=145s)
- other "test field" at [8:44](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=524s)
- [table 98 "General Ledger Setup"](../objects/table/98.md) at [9:45](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=585s)
- other "currency card" at [10:18](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=618s)

## Quotes

- [0:37](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=37s) "next current exist methods are up to 32% faster"
- [1:48](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=108s) "so you're basically saving a datab base call for every time you need a number so if if you have a range of 100"
- [2:25](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=145s) "change log entry tables growing to very large sizes to the point where even setting up retention policies would time out"
- [5:07](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=307s) "with this release wave as developer you can now Define field tool tips once on the table and any page uh that that use"
- [9:04](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=544s) "we've added new capabilities to test field so that it can add link to add a navigation link to the failing data"
- [12:10](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=730s) "for this release we have switched to net 8 which is a faster and more efficient runtime"
- [12:30](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=750s) "with doet 8 we're moving to Powers shell 7"

## Disclaimers in the video

- [3:05](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=185s) preview: new method which for now is mar for on premises
- [5:48](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=348s) not-in-this-release: that's science fiction not coming in this release wave
- [6:29](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=389s) coming-later: I'm afraid it didn't make it for this release but um it will go out with a later um compiler update
- [13:22](https://www.youtube.com/watch?v=OLN-2Ec2GMM&t=802s) coming-later: will deprecate Parell five within the next years

Presenters (as heard): Kenny Pidan, Yan M Peterson.