Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Patricia Rounds]

Hello,

We sometimes use negative consumption on our production BOMs and find that it works quite nicely. I was trying to do so on an assembly BOM, however, it would not let me enter a negative quantity on the BOM.

Any ideas how to create negative consumption on a assembly BOM?

——————————
Patricia Rounds
Saf-T-Cab, Inc.
Fresno CA
——————————

[David Wiser]

Unfortunately, the short answer is that assembly BOMs aren’t designed like production orders and do not allow negative quantities. It is really just designed to assemble some items quickly to make something else and doesn’t deal with by-products from that process (like negative consumptions from the production order process does).  Your partner may be able to modify the system to allow it.  Don’t know if anyone else has done that yet.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
————————————————————————-

[Patricia Rounds]

Thanks Dave,

I suspected it wasn’t going to work.  I am trying to find a way around having to create a new item card for a slight variation in the end product. We manufacture “stock” cabs with one windshield wiper. The components for the wiper are included on the BOM of the item we are selling. Occasionally, the customer wants two wipers. I don’t want to create a new item card  for the modification, because when we are actually building them, we don’t always know they want this modification. What I was trying to do was create an assembly item for the two wiper “kit” and when it was added  to the sales order, it would replenish the components for the one wiper kit that were included in the BOM of the end product.

Any ideas on how to deal with this? I could remove the wiper components from the BOM completely, and then create two assembly items, one for one wiper and other for two wipers. Problem  is this is not the only “minor” modification we have to deal with

——————————
Patricia Rounds
Saf-T-Cab, Inc.
Fresno CA
————————————————————————-

[Jason Luchka]

From an outsider’s perspective, you are selling two different items. 1 with one wiper and another with two. If a customer orders a unit with 1 wiper and gets a units with 2 (or vice versa) they have received the wrong item – which tells me I should just make two separate item nos. respectively. Then your BOM is easy and clean and your cost is correct for each finished good.

——————————
Jason Luchka
Programmer / Analyst
FFR Merchandising, Inc.
Twinsburg OH
————————————————————————-

[John Grant]

Patricia –

I just wanted to point out an issue that can happen when using negative BOM lines which you may already be aware of but thought for this discussion it is something to point out. Using negative BOM quantities will net demand in planning. What I mean is if I need 10 of the component on a Prod Order on 1/13/17 and have another Prod Order listing the component on 1/13/17 as a negative 10 the Planning will net the result to 0 for planning purposes. Something to consider when designing your process using negative qty’s in BOM.

And yes Assembly BOM’s do not allow negative qty’s as was already pointed out.

Best Regards

——————————
John Grant
Senior Application Consultant
Innovia Consulting
————————————————————————-