Reset id no every month

format: YYMM-00001
january
example 2501-00001, 2501-00002…

feb
must reset to 2502-00001…when add new record it will 2502-00002

Hi ,

Use —> Document Naming Settings for it .

1 Like

Go to Document Naming Settings.
Choose your doctype and add the format like:

.YY..MM.-.#####

Then set it as the default naming by customizing the doctype.

1 Like

@volkswagner

But how to reset it based on our requirement like

my series : REP.##.DD.MM.YY.
I want to reset after 99, only two digit (currently number at 800)

I don’t understand your request. If you “reset” the counter back to zero, you’ll have repeating numbers within the same month. Either doc creation will fail due to non unique ID or the system will append with “-1”.

Your original request was to have it reset when the new month arises, which would occur with the suggested setting.

Your series REP.##.DD.MM.YY. Is missing periods surrounding variables and you don’t have the required trailing digits. If you expect to never have more than 99 docs in a single month you can use:

REP-.DD..MM..YY.-##

If there is any chance you’ll have more than 99 docs in a month, I suggest extending the number to “-###”

I’m not sure if the sequence works when it’s not at the end of the string, but you can try a properly formatted string like REP-##.DD..MM..YY.

REP-.DD..MM..YY.-##

I have 99 digit per day because
DD - Date
MM - Month
YY - Year

i don’t need more 99 per day

Thank for reply