Hi,
I’m having an issue regarding creating of work orders from BOM.
I have a few BOM’s where this issue present.
Basically in the BOM’s in question, I have a few items included, for example, Item 1 - 2 qty, Item 2 - 2 qty and Item 3 - 2 qty. This is what I have set in the BOM to produce the Finished Good.
When I create a work order from this BOM Item 1’s qty is being doubled so its showing 4 in the work order, while Item 2 and 3 remain at 2. If I try to make 2 of the finished good then it will show Item 1 - 8 qty then Items 2 and 3 - 4 qty.
If I create a new BOM to include Item 1 in combination with any other Items, it is always being doubled when I go to create a work order.
This issue is happening with a few items, and its always the same items that are being doubled every time.
Exploded Items are the same as what is included in the BOM item table. Same values and items. They were pulled automatically on creation of the BOM and they havent been adjusted.
Sub-assembly also hasnt been edited but is selected, I’ve tried eith it being disabled too to no difference. Previously these BOM have worked but recently are now starting to do what is mentioned above.
I am confirming this bug still exists in v15.87.1.
I have the exact same problem: some raw materials are having their quantities doubled in both Production Plans and Work Orders, while other items are fine.
To prove this was not a customization or database corruption, I deployed a brand-new, 100% clean, un-customized install of ERPNext and I was able to reproduce the bug immediately.
I made a bill of materials using all new items that i created and i created each of the items by “duplicating” so they are literally all the same item except different names with the default “all item groups” for the item group. It is still doubling some of the items and not others. I checked all settings ten times and there is nothing wrong with any of it.
This is a core bug in the manufacturing module and is not related to user configuration.
all of the items use the same UOM i created (LS). I checked the conversion factor and that wasn’t it. The quantity of the item i was building was 1 and the UOM was LS, all of the bom items had a qty of one with LS uom, all of the conversion factors were 1. I ended up deleting the three of 8 items on the boms that were causing the problem and created them again, one by one, with the same name, and it still did the same thing just to those three same items. Then, i deleted those items and created new items set up the same way but with different names and no problem, so i don’t know if that is a clue?
Try to identify any differences in the old item vs the new one you created. Not just visually, but in the console cur_frm.doc as well as in the database. Those are the next steps to debug the issue further.
I still think the default UOM and UOM conversion might be the culprit. Or if that isn’t the case, then the BOM raw material qty or UOM. Can’t think of anything else that might cause this issue.
thank you for your help. i just checked both of those things you suggested and the files are identical except for what is obviously expected to be different.
I checked the items and the item groups and here is the output:
ok, i found the trigger that was causing this…..it happens for any item who’s Item Code exactly matches that item’s Item Group Name. I haven’t found the code that causes it to do this, but that is the trigger.