Item Code auto generation

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

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.

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

kind regards
Naresh.

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

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

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

1 Like

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

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

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.

1 Like

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

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

Thank you so much santhida, it works like a charm

1 Like

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

Thank you Muzzy