web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Extend number series b...

Small and medium business | Business Central, N...

Suggested Answer

Extend number series by current year

(0) Share

Report

Report

Posted on by Community Member

Hey guys,

I would like to know the following from you guys:

I have created a number series that looks like this:
CTR000096 for example.

Now for each record the number series is drawn and increased by one. So then the next number is: CTR000097.

But now I want to extend the number series by the current year:

2021_CTR00096 and as soon as the year change was, the next data record should automatically get the number 2022_CTR00001. Is this possible?

I have the fear that this will not work...

Thank you very much ;)

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

I know a number of clients who make it an annual activity to ramp up the year on their number series. If by code is your preferred style I would explore using one of the integration events from the noseriesmanagement codeunit. You could add a new field to the number series table to calculate year. With the event you can then append the value providing you allow manual numbers.

Another option which would be more long winded is to create a new field to hold the value. Hide the main number field on pages.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,870 Super User 2026 Season 1

#2

YUN ZHU 1,138 Super User 2026 Season 1

#3

Dhiren Nagar 915 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans