Auto generate number is not working at the start of new year

[droopsnoot]

@itsumarnazir

oh I also found that issue! I have 6000 plus record, now have to change all of them ??? is there any other way to handle situation ?

If only that had been mentioned when you first asked about auto-generating the number.

@droopsnoot

My opinion is that the second part of the bill number should be YYMM rather than MMYY, though you might have some reason to use the order that you stated. I can’t think of why it would be better to sort by month then year, rather than by year then month.