Skip to main content

Notifications

Announcements

No record found.

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

Serial Number Formatting

Posted on by 3,482

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

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Serial Number Formatting

    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.

    pastedimage1673964861092v1.png

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Serial Number Formatting

    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

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Serial Number Formatting

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans