Serial No that contains PROJ name

ERPNext User Forum
1

Hi

IS there a way to include the name of a manufacturing project in the serial no of the manufactured item ?

I tried to configure this on the serial no series of the manufactured item ..

SER-.{project}.-.#####

Hoping that this will yield serial nos such as …

SER-PROJ1-0001 , SER-PROJ1-0002 …..

then

SER-PROJ2-0001 , SER-PROJ2-0002 ……

but it didn’t work.

Would appreciate some suggestions ?

2

Hi @trainingacademy

You need to have project link field on serial number docytpe.

you can define project field either on item or work order level as both doctypes are there in serial number doctype form which project value can be fetched and used for naming series purposes.

3

Hi,

Yes, we can approach this by keeping the Serial Number Series field in the Item master empty and handling the serial number generation based on the Project during the manufacturing process.

I would not recommend adding a generic Naming Series directly to the Serial No DocType, because the Serial No naming process needs to know which Project is associated with the Work Order.

The proposed approach would be:

  1. Keep the Serial Number Series field empty for the manufactured Item.

  2. Add a custom field to the Project, for example:
    Project Serial Prefix

    For example:

    • Project 1 → PROJ1

    • Project 2 → PROJ2

  3. When a Work Order is created/submitted, get the Project linked to the Work Order.

  4. Use the Project Serial Prefix to dynamically create the naming series, for example:

SER-PROJ1-.#####
  1. Generate the Serial Nos using that series.

This would result in:

Project 1:
SER-PROJ1-00001
SER-PROJ1-00002
SER-PROJ1-00003

Project 2:
SER-PROJ2-00001
SER-PROJ2-00002
SER-PROJ2-00003

Each Project would have its own independent sequence because SER-PROJ1-.##### and SER-PROJ2-.##### are separate naming series.

The customization would be implemented in the custom app, without modifying the ERPNext core code. It would hook into the manufacturing/Work Order process, generate the required Serial No records, and then allow the Manufacture Stock Entry to use those Serial Nos normally.

This approach also preserves the standard ERPNext Serial No traceability, since the Serial Nos can still be linked back to the Work Order and manufactured Item.

So overall, I would recommend:

Item Serial Number Series: Empty
Project: Maintain a Project Serial Prefix
Custom logic: Generate the Project-specific Serial Number Series during manufacturing
Result: SER-PROJ1-00001, SER-PROJ1-00002, etc.

This should give us the required project-wise serial numbering without modifying the ERPNext core.

4

No Need of any custom app.

Just make sure to have project field populated in serial number doctype either form item or work order doctypes. Naming Rule can help you define dynamic nomenclature for each project FG items.