Serial Number Formatting

(0) Share

Report

Posted on by john.ellis

3,518

Hi:

Is there a means of having Business Central automatically format item serial numbers as "year", followed by "month", and followed by a system generated number?

Thanks!

John

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,788 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi john.ellis

Item Item serial number does have a field which is bind with the No. Series table and that No. series does have a records which we assigned No. series manual or auto increase, so in that case whatever the No. series code you will provide it will have the same but can not be auto defined the code as you are looking for. You need to change that No. series code every year or month.

Thanks.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I have briefly discussed this topic before, and I hope the following information can give you some hints.

https://yzhums.com/16424/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,835 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

John,

Yes, you can. It requires setting up several lines within the "Lines" section of the No. Series. Below is an example of Year - Month - Three Digit Code. You need to establish the Start Date as the first day of the month so it starts picking up the new series. You can set this up far in advance, just make sure you document it somewhere so you remember when it becomes time to do it again.

You need to be careful how many you produce within the month, as you'll see in the example, if I produce more than 1000 serial numbers it is going to go into the next month. You could adjust for this by adding an alpha character to create a separation.

Was this reply helpful? Yes No