New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Write flexible and performant code with NumberSequences

This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 6th of the new functionality in the Development section is write flexible and performant code with NumberSequences.

Improvements to NumberSequences date type streamline the development and execution of code that creates and manages number sequences in the database, resulting in increased efficiency and speed.

Enabled for: Users by admins, makers, or analysts
Public Preview: Apr 2024
General Availability: Apr 2024

Feature Details

This release offers the following improvements to the NumberSequences data type:

• New Restart operation
  Prior to this release, a number sequence had to be deleted and recreated to restart it. Now, a new Restart operation simplifies and speeds up this process. The operation has the following syntax:

  Restart(name: text; seed: BigInteger; CompanySpecific: bool)

• New RangeStart operation
  A new RangeStart operation allows developers to request multiple values from the number sequence at once, meaning no gaps, and fewer SQL round-trips. The operation has the following syntax:

  RangeStart : = Range(name: text; count: integer; CompanySpecific: bool);

• Improved Next, Current, and Exists operations
  These operations are now 8 to 32 percent faster.