ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Naming Series Current Value Is not Updating from naming series form

Hello Team,

I am trying to update current value for Journal Entry naming series From naming series form but its not updating. Its not getting updated value.
Can anyone help me to solve this??

As per the message you have already record created with the same name. First delete it then create a new one, as you reset the current value in naming series. The application does not allow you to create a record with the same name.

In Journal Entry Record created till 17 I want to create next record with 18 But It’s not updating.
That’s why I tried to set current value using naming series

But it’s trying to a create record of the name - JV-17.18-0011 not JV-17.18-0017
Something went wrong.

Check in database what is current value

Maybe query the database for the current setting:

frappe@erpnext:~/frappe-bench$ bench mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13052
Server version: 10.0.29-MariaDB-1~trusty mariadb.org binary distribution

Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [d56cb677eaab3383]> select * from tabSeries;
±------------±--------+
| name | current |
±------------±--------+
| PATCHLOG | 579 |
| INVTD | 21 |
| ITEM-PRICE- | 3 |
| OPTY- | 3 |
| QTN- | 3 |
| QUOD/ | 9 |
| TASK | 6 |
| SO- | 0 |
| SINV- | 1 |
| Q/ABR/ | 5 |
±------------±--------+
10 rows in set (0.02 sec)

And check tabJournal Entry or tabJournal Entry Account like this:

MariaDB [d56cb677eaab3383]> select name,naming_series from tabQuotation;
±------------------±----------------------+
| name | naming_series |
±------------------±----------------------+
| Q/AMA/00001/17/VT | Q/ABR/ |
| Q/AMA/00004/17/VT | Q/ABR/ |
| Q/HL/00002/17/VT | Q/ABR/ |
| Q/HL/00003/17/VT | Q/ABR/ |
| Q/HL/00005/17/VT | Q/ABR/.#####./.YY./VT |
| QTN-00001 | QTN- |
| QTN-00002 | QTN- |
| QTN-00003 | QTN- |
±------------------±----------------------+
8 rows in set (0.00 sec)

One other note - once a naming_series is set, for integrity reasons the database forbids you to update or replace that initial value

see this Can't edit Naming Series