Share
ReportHi:
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
You’re offline. This is a read only version of the page.
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
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.
Hi, I have briefly discussed this topic before, and I hope the following information can give you some hints.
Thanks.
ZHU
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (