ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Link field naming series doesn't work for serial number generation?


#1

Hi Everyone,

I’m trying to add item_code to the automated serial number list but it doesn’t seem to work… any idea why?
I’ve tried:
.{item_code}.-.DD.MM.YY.-.######
.item_code.-.DD.MM.YY.-.#####
.item_code-.DD.MM.YY.#####

All just returned item_code as ITEM_CODE.
How can I enable link field reference to serial number generation ?


#2

Hi all…

I’m also experiencing error for serial number generation in Sales Invoices.
SVB2B.YY.MM.####
SVB2C.YY.MM.####
The serial number are missing in order. ie.

SVB2B.YY.MM.0010
SVB2B.YY.MM.0013
SVB2B.YY.MM.0014
SVB2B.YY.MM.0015
SVB2B.YY.MM.0017
SVB2B.YY.MM.0018

here 11, 12 and 16 is missing.

Kindly do the needful to correct this error in v10.1.50
I’ve not updated self hosted erpnext to v10.1.51.

Thanks in advance.


#3

Hello, anyone can point me in the right direction? I would also like to include the batch number into my auto serial number generation, how do I go about doing it?


#4

You seem to be using two prefixes - what ordering are you expecting? Naming series reset issue


#5

Hi Clarkej, are you answering me? I’m not sure.

But my problem is not about using how many prefixes…

It’s naming series not working in serial number generation


#6

Are these not two prefixes? What is your actual versus expected result, IOW exactly what is the error you refer to here?


#7

Not Really clarkej… that’s ameerbabu hijacking my thread with his own set of problems.
I guess he’s just having problems with serial numbers skipping the normal order.

For me, my issue is when i Insert :
.{item_code}.-.DD.MM.YY.-.######
.item_code.-.DD.MM.YY.-.#####
.item_code-.DD.MM.YY.#####

these into the serial number generation input box, the end result would give me:

ITEM_CODE-19.09.18-00001
ITEM_CODE-19.09.18-00002
ITEM_CODE-19.09.18-00003
ITEM_CODE-19.09.18-00004
ITEM_CODE-19.09.18-00005

I would like to find out how can I enable the ITEM_CODE to be references to the actual item code of the serialized item itself instead . Just like how it was supposed to work as “Custom Field” in naming series.
For instance if the item_code is GY2020, then the end result should be:

GY2020-19.09.18-00001
GY2020-19.09.18-00002
GY2020-19.09.18-00003
GY2020-19.09.18-00004
GY2020-19.09.18-00005

instead.


#8

Thanks Jonathon pardon my confusion, check out make_autoname

For eg this Can't edit Naming Series

and Tyler’s good notes https://discuss.erpnext.com/search?q=%40tmatteson%20make_autoname


#9

Thank you clarkej ! Appreciate the direction greatly!

We will take a look at this and see how we can fix this.


#10

Sorry. I was not meant to hijack your thread. But I just intimated about the similar error I experienced.


#11

“about the similar error I experienced”

Not to hijack this thread further, ameerbabu you need to give clear evidence to support that your ‘error’ case is in the ERPNext court, and not on your part re how naming series works ie it’s design use and so too it’s limitations?

You will find much discussion to inform yourself here of misuse what you prefer to declare an ERPNext error…please start a new thread and make your case ok?