Update custom naming series

I have setup name series like this:
R.#./.YYYY (so the number is not in the last place)
But when trying to update the series instead of updating some value in tabSeries sql table I get a new entry for example name=“R1/2020” current=“0” (1 being the current last number before updating, 0 being the requested new starting value).
I suspect the reason for this bug is that actual number is in the middle of the string instead of being the last item in naming scheme…
I can manually tinker with sql database but would prefer not to. What should I do?
Thanks and best regards,