BOM variant calculating absurd quantities for "Materials Required (Exploded)". Weird!

I have created a BOM for a chemical that we require to have in two concentrations: 2000ppm and 4000ppm.

The template BOM looks like this:

BOM2

I use the “Create” button to start a variant BOM and upon saving get this:

BOM-2k2

In the “Materials Required” section the sum of the quantities of the 4 items is 1.013650.

That number is then used as the percentage increase to the exploded quantities…

… or in other words: each exploded item quantity is the original quantity multiplied by the sum of all the original quantities. What?

Please, someone, help me understand :

  1. Is that a bug?
  2. Have I made a mistake?
  3. If it is correct, how does it make any sense at all?

erpnext 13.0.2
frappe 13.0.3

1 Like

Just found this also on a customer implementation. Shows just how little new features get tested!

Documented and fixed here:

Let me know if you want to know how to fix your database.

Thanks for looking at that.

This crap caused me a huge embarrassment in front of the whole company. As in, “There are so many ERP alternatives out there. Wouldn’t it have been better if you had picked one that actually works?”

Strip duly torn:

[fix: incorrect bom no. added for non-variant items on variant boms by nameduser0 · Pull Request #26320 · frappe/erpnext · GitHub](Comment link)

1 Like

Hear! Hear!

I started with ERPNext 18 months ago with high hopes and goals. After stumbling from one minefield to another during that time, I am terrified of trying to add anything new to what we are currently doing.

Set up a test site/bench/instance, restore a backup and try it out first! bench and instance options are good if you’re thinking of upgrading.

Oh yeah! I always do that!

I’m not so much afraid I’ll hand over bad code to users. Mostly, they don’t see what I haven’t tried myself, unless there’s a regression somewhere.

I am afraid of losing yet another week out of my life for each and every new [ AttributeError: 'NoneType' object has no attribute ... ] mystery or whatever "Oh gee, it seems we don’t have a test for that" that’s lurking in the bowels of what I need to do.