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

1 Like
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

2 Likes
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

14

Hello All Experts,

I am looking to auto generate the description of Item.
For example, I have below :slight_smile:

2 check boxes -
Gate - Check box
Globe - Check Box

1 Select Field -
Material - (SS, MS, CS, etc in list)

1 Select Field -
Ends - (flange, threaded, etc in list)

Now based on above selection - I want Description Field to auto generate - Like if i check “Gate” and select “SS” and “flange” then the description shall display “Gate, SS, Flange”

Workout Something like this, your valuable inputs will be helpful.

15

Client or Server Script

16

I tried various scripts but unable to do so. In fact the earlier deleted script is running but the current one is not showing up or working. Can you please guide.

17

It looks almost like the thing I want to do. However I have a few Items Groups that I want to combine into the same number range. I created a custom field at the item group, with a selection.
In the Document Naming Rule, I would like to use that new custom field for the Rule Condition, however I cannot select that field from the list. Is there a way to use that field in the Rule Conditions? Or can I only use the Item Group field?
And is it possible to leave the Prefix field empty? I would just prefer to have a different number range for different groups. Like

Group A - Number 1000 - 4999
Group B - Number 5000 - 8999
Group C - Number 9000 - 9999

18

I have a custom script deleted (created on item doctype) but it still works on item form. And I tried on other browser, it still works, and i reset chrome but it still works. I have a self hosted on virtual box. In fa t the other vms also give same script but it is not in script list.

19

No need to any script and all programming skill…
Create item group what you want and then go to document naming rule and follow my this post.

This post considering journal entry doctype.

  1. you can select “item” in document type field
  2. make it rule condition field in item_group = <Your_item_group_list> like Finished Goods
  3. set prefix what you want like FG.-.
  4. Finally, set digit like 5

so once you create item then generate code like FG-00001

20

Thanks. I tried that, but somehow it doesn’t work as hoped.

  1. Selected Item in document type
  2. Made two rules: is_sales_item = Yes + item_group = Events
  3. Set a prefix EVT
  4. Set digit.

Now when I create a new item, define the name, item group Events and mark it as a sales item and save, it creates an item code: STO-ITEM-2023-00001.

I selected Naming Series under Item Naming By in Stock Settings. Where else do I have to define that?

One other question:

How can I omit the Prefix set in 3? I just want a number, not a CHAR0000 format