Naming Series- Update Series Number Issue

1

I am having an issue with the starting number of a naming series. I created a naming series for Purchase Order as follows:

PD .####./.YYYY.
PDJ .####./.YYYY.
PO-

Then used the [Update Series Number] to set the starting number for the two newly created naming series to 20 and 10, respectively.
After doing [Reload] then saving a new Purchase Order with either of the two newly created series, the System is not setting the number to 21 for PD or 11 for PDJ as expected.
Then, I tried to replace the space between the PD/PDJ and the remaining parts of the naming series with a “-”. Still, the System won’t honor the series starting number entered.
When I checked the tabSeries table, I noticed that the System created the following records:

+---------------+---------+
| name          | current |
+---------------+---------+
| PD-           |       3 |
| PDJ-          |       0 |
| PD-0002/2019  |      20 |
+---------------+---------+

Any ideas?

ERPNext: v11.1.10 (master)
Frappe Framework: v11.1.10 (master)

2

see the naming series will not select itself. I say, you make a custom script or some code in python, and select the appropriate naming series when a certain condition is fulfilled. (I’m assuming there is a reason why you want two different series for the same document.)

3

I am sorry I don’t understand what you mean by “selecting itself”? And what condition are you referring to?
Enduser has the option to select whatever naming series for any document. That’s standard system behavior and feature. I am not expecting anything new.
The issue is only with the starting number of any selected series!
It seems I could not convey the message properly in my post.

4

I did not understand your problem well. I apologize.

Now why the Update Series Number page did not work, I don’t know since I haven’t read the code. But your problem can be mitigated by an SQL query that will update current for the required naming series.

5

As a workaround, I did just that. Updated the field for the series. I noticed that the series with the full naming structure had no effect (e.g. “PD-0002/2019”). The one that fixed the issue is the “PD-”.
Even, when you try to use the [Update Series Number] function on the Naming Series setup page, the System won’t fetch any of the current values in the DB, neither for the full series name (e.g. PD-0002/2019) nor the short one (e.g. PD-). It gets the current number for all as 0 (zero)