Hello, can you help me? I am creating a work order. It must have a unique number and start with the year. But start again at 1 in a new year. Is this possible?
The number have to look like this 24234, next is 24235 etc.
In the new year, 25001, 25002
Does it work using the “Current Time” → “Year (Short)” and then adding the remaining 3 digits?
Thanks for thinking along Afonso. But will the order number reset to 1 this way??
Why is this important. Let’s say you have a company that produces 20 work orders per day. After 3 years you get a huge number if you just keep counting. The first year 247300. The second year 2514600. The third year 2621900. I want to prevent this by resetting to 1 every year. That gives the maximum number of 247300, 257300, 267300 etc. every year
Would it be possible to create a formula somewhere that resets the workorder number to 1 on January 1st 00.00??
Maybe with a custom action??
Create a list of dates of the 1st o January each year, then when you’re generating a new order, that button should be a list of those dates, whose date is after current time and max number of elements shown is one. Then, when you press it, that order number will be Year (short) & (count # of orders whose date is after the date of that list element).
Please let me know if it works.
Hello Afonso, sorry, I was busy implementing the Advance calendar. I will try it out as soon as possible. Thanks for thinking along