Possible to create products with duplicate serial numbers.

[michaelslade54]

Impacted versions: 12.0, 13.0

Steps to reproduce:

1. Create 2 products "Serialized Product Parent" and "Serialized Product Child".
   Product Type - Storable Product
   Tracking - By Unique Serial Number
   Routes - Manufacture
2. Create a BoM for "Serialized Product Parent" with "Serialized Product Child" as a component.
3. Create a BoM for "Serialized Product Child" with any consumable component.
4. Create 2 Manufacturing Orders for "Serialized Product Parent" and 2 Manufacturing Orders for "Serialized Product Child".
5. Produce the product "Serialized Product Child" using the Manufacturing Order from step 4, giving it serial number 0001.
6. Product the product "Serialized Product Parent" using the Manufacturing Order from step 4, using serial number 0001 as the "Serialized Product Child" component serial number.
7. Produce the product "Serialized Product Child" using the Manufacturing Order created in step 4, using the same 0001 serial number used for step 5.

Current behavior:
Product can have the same serial number on multiple instances of the component (as shown in screenshot below). This can also occur if the product is in a different location than the location the product is being manufactured (i.e. picking, packing). In this case, the serial number is only validated when the product is being moved into a location where there is a duplicate serial number (by this time it is too late, and the product has already been manufactured/serialized).

Expected behavior:
Validation Error "A serial number should only be linked to a single product" should be thrown when trying to create the child product during it's MO, as the serialized product already exists, it's just installed in another product (or potentially moved to another location).

Video/Screenshot link (optional):

[pedrobaeza]

I don't see instructions enough detailed for reproducing the problem. What do you mean by "Complete a MO"? Please record a video showcasing the problem.

[michaelslade54]

Original description updated for clarity. I will endeavor to post a video when I can.

[michaelslade54]

Video showcasing the issue. The same serial number, in this case TEST01 can be continually used in manufacture and 'installed' in multiple manufacturing orders.

https://www.loom.com/share/51b36db7b4634fed82ca700ac2b84e6a

[pedrobaeza]

OK, thanks for the video. I see the potential problem, although not sure if this can be prevented the way serial numbers work, as the control is quantity per physical locations, and as you have already consumed the other raw material, the quantity is in the virtual location "Production".

@amoyaux @sle-odoo maybe something to take into account for manufacturing ?

[michaelslade54]

Thanks for taking time to view it!

The same duplication can occur if you produce product "Serialized Parent Product" with a serial number and transfer to a different location (even a physical one), you could then produce another "Serialized Parent Product" with the same serial number as the first. In fact, the duplication can occur by simply completing Inventory Adjustments at any two locations, the same serial number can be used for both.

Given the above, it must only be checking the finish location of the current operation, not necessarily limited to physical locations. I will endeavor to record another video and find some code snippets.

When I get an opportunity I will look into possible solutions and their implications, as this issue has some serious consequences, namely traceability, warranty and recall of products, not to mention the cost of producing duplicate serial numbers and the potential rework involved when it is discovered.