erpnext icon indicating copy to clipboard operation
erpnext copied to clipboard

feat: Share Serial Nos between unique Items

Open marination opened this issue 10 months ago • 14 comments

no-docs (temporary)

Case:

  • Serial Nos are purchased from Supplier and must be maintained in the system as per supplier
  • A company buys different items from a supplier, who (supplier) starts all their serialised items with 1 and then autoincrements. This way item A can have serial “3” and item B can also have serial no “3”.
  • Additionally: A serial no is also something that a supplier/ manufacturer can choose freely.

Solution:

  • Make Serial Nos unique only on Item level (Item A cannot have Serial No "3" twice)
  • This means Item A and B can have the same Serial No, but different Serial No document names Screenshot 2023-09-29 at 4 50 18 PM

Flow:

  • Serialised Item A receives some Serial Nos via a Purchase Receipt. These are auto created using a naming series. SN-0001 is one of them
  • We want to register a Serial No for Serialised Item B, which also has the same Serial No
  • We can do one of the following:
    • Create a new Serial No (manual or data import) > Use it in the new Purchase Receipt's popup, by scanning or entering it in the table
    • In the new Purchase Receipt popup, upload a CSV of the Serial No(s).
    • Create a new Serial and Batch Bundle > click on "Make Serial Nos" in the form > insert/upload the Serial No(s)
  • Now we should have a Serial and Batch Bundle created that includes a Serial No with ID: SN-0001-1 and Serial No: SN-0001

All of the above methods handle naming clashes via the autoname function in the Serial No.

Note: This does not work for naming series (auto naming) as the last count is maintained series wise. So if we have a series SN-.#### shared by two items, the insertion of the Item-A creates SN-0001 (series count is 1) and then the following insertion of Item-B will naturally create SN-0002.

For now only manual addition of serial no.s through various modes is supported for reusability

ToDo:

  • [x] Link formatting for Serial No in tables and reports
  • [x] Tests

marination avatar Sep 22 '23 17:09 marination