But In this scenario I need 13 digits long number excluding naming series name(prefix). I don’t need to include SINV. prefix for barcode.
For Instance
// tabSeries Current value data length == 10
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| name | varchar(100) | YES | | NULL | |
| current | int(10) | NO | | 0 | |
+---------+--------------+------+-----+---------+-------+
In this table current value field can only store upto 10 digits(1234567890) value, If It’s more than ten digits, then behaviour of naming sequence will be unpredictable and you can’t predict which number will come next.
I have achieved the desired results using custom Doctype to maintain the naming series, but I would prefer Standard functionality of ERP over making customisation for minor changes.