Item Code auto generation

ERPNext
, , ,
#1

Hi All,

I am new to ERPNEXT and I wanted to set the Item code to be auto-generated as per the below scenario.

I have created an “Item Type” with the type - “Select” with the below data
1)Finished Goods
2)Services
3)Raw Material
4)Consumables
5)Semi-Finished Goods

when the user selects say “Finished Goods” I want the Item code to auto-generated as FG000001 with incremental value, if they select “Services” it should be SCG0000001 and if they select “Raw Material” it should autogenerate RW000001.

please guide me. i was going through the forum, but was unable to find the right solution.

Thanks
Naresh

#2

You need to create one more field of short code like FG for finished goods. User will set this field before saving. In naming series you have to use filed_name. for auto numbering.

#3

Thank you so much Muzzy, please show me an example with a screenshot.

kind regards
Naresh.

#4

In Item Group Tree make a new custom field like the one on the right. Set FG, SCG etc. for each

image
image882×344 7.25 KB

In naming series Item use the code as below. There’s a dot between abbr and ###. Keep the dot and add number of ####. If 4 # then your item code will have max four digits. Use your field name.

item_group_abbr.#########

System generated item code using naming series.
image

3 Likes
#5

for this use case, you can use Document Naming Rule where you can Define the Item Type Wise Naming.

1 Like
#6

Thank you so much Muzzy,let me give it a try and get back to you.

#7

Thank you Ranbir, if you can please show me an example with a screenshot.

#8

Sure, here is a Example with Screenshot.
Use case - If Item Group = Raw Material, then New Item Code Generate as RM-0001.
you can also manage the Document counter in future if you want to reset.

Screenshot 2023-02-24 104107
Screenshot 2023-02-24 1041071652×858 38.8 KB

1 Like
#9

Thank you, I did try and was able to create multiple naming rules for each options in the group, but they are not appearing in the item code field when I create a new Item. please help me

#10
  1. Stock Settings >>Item Naming By (Naming Series)
  2. setup Document Naming Rule for each Item Group
1 Like
#11

Thank you so much santhida, it works like a charm

1 Like
#12

FYI. It will work only once 1st time at item creation. If you edit the group on item master it will not change. So set it carefully and correctly.

1 Like
#13

Thank you Muzzy