Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

BOM Component Usage based on Multifactor of Finished Product

(0) ShareShare
ReportReport
Posted on by 15,435

Hi

I kind of stuck here. 

We have a product that we produce as a Lbs. Now we each 30 lbs of this product we need to consume 1 lbs of another product. But I do not know how to setup the bom here. I mean Fixed Qty does not work since it will not consume extra 1 lbs if I create 60 lbs. 

What is your suggestion here? 

For example

If we produce 30 lbs we consume 1 lbs

If we produce 45 or 55 lbs we still consume 1 lbs

if we produce 60 or 75 or 85 lbs we consume 2 lbs. 

Thanks 

  • MahGah Profile Picture
    15,435 on at
    RE: BOM Component Usage based on Multifactor of Finished Product

    Hi Robert Jolliffe

    You suggestion was brilliant. It helped me a lot. I tweak your suggestion (since I used 1 just to simplify the example). This is what I did

    For each component I setup new UOM for what I needed.

    Then in BOM I used that UOM for those components.

    I used your logic for QTY (like 1 divide on what I need)

    Thanks again

  • Robert Jolliffe Profile Picture
    859 on at
    RE: BOM Component Usage based on Multifactor of Finished Product

    No - Fixed Qty appears only once per production order.  The common use is either cleaning out a machine (ie: you need to run 100lbs of plastic through an extruder when you start each production order) or for destructive testing (you need to cut the first casting in half to check for porosity/air bubbles.

    The only way to do it is what I've suggested (I think).

  • Suggested answer
    YUN ZHU Profile Picture
    78,733 Super User 2025 Season 1 on at
    RE: BOM Component Usage based on Multifactor of Finished Product

    Hi, Sorry I didn't test it again, can Fixed Quantity do it?

    pastedimage1673911814643v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Verified answer
    Robert Jolliffe Profile Picture
    859 on at
    RE: BOM Component Usage based on Multifactor of Finished Product

    If you setup an item with a Rounding Precision of 1.0 then it's always rounded up to the next whole number.

    Example: I make a door that is 1' x 2' from a piece of Plywood that is 4' x 8' - I need 1 Piece of plywood to make 1 door.  Or 1 piece of Plywood to make 16 doors.

    In your example, if you have an item and have .0167 of that item - then it should use 1lbs (rounded up) from 1 lbs to 59 lbs, and use 2 lbs to make 60 to 119 etc....

    Try it and see if I am right.

    -Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans