Extend number series by current year

(0) Share

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 (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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