Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Fixed Quantities on BOMS

Posted on by 473

We have a number of parts that we stock in Board Feet and Linear Feet. These items, regardless of how many we make will use the same amount of Packaging materials (plastic bags or cardboard tubes). How can I get NAV to assign a fixed quantity for those components instead of multiplying the "quantity per"  by the number of pcs made?

And before anybody says I can change the quantity required on the production order line, I should point out we have way too many items to modify components on individual production orders. It needs to be setup at the BOM level.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed Quantities on BOMS

    Hi,

    i did it for several customers in the following way.

    Add the component to the Bom with a very small quantity (0.00001 i.e.).

    Set the Item Rounding Precision to 1.

    Every time you create a production order, the quantity on the production bom line will be rounded to 1.

    There are some limitations, because you will exceed a quantity of 1 when you have very large production orders, but this might not be the case for you.

    kind regards,

    Francis

  • RE: Fixed Quantities on BOMS

    You can also customized the Calculation Formula in Production BOM Line and add a new one (ie. you can call this Calculation Formula= "Static").

    This is what you later will used when calculating expected quantities in components. This is now being done in the OnValidate of Calculation Formula from Prod. Order Component table (T5407). Currently, it shows:

    CASE "Calculation Formula" OF

     "Calculation Formula"::" ":

       Quantity := "Quantity per";

     "Calculation Formula"::Length:

       Quantity := ROUND(Length * "Quantity per",0.00001);

     "Calculation Formula"::"Length * Width":

       Quantity := ROUND(Length * Width * "Quantity per",0.00001);

     "Calculation Formula"::"Length * Width * Depth":

       Quantity := ROUND(Length * Width * Depth * "Quantity per",0.00001);

     "Calculation Formula"::Weight:

       Quantity := ROUND(Weight * "Quantity per",0.00001);

    END;

    "Quantity (Base)" := Quantity * "Qty. per Unit of Measure";

    VALIDATE("Expected Quantity",Quantity * ProdOrderNeeds);

    So, I guess the above should be easy to modify with a new Calculation Formula.

  • Suggested answer
    Ishan Profile Picture
    Ishan 1,285 on at
    RE: Fixed Quantities on BOMS

    Hi mescandon,

    When you create a BOM the components entered in BOM lines are per piece quantity only.

    I think your case is like some items are consumed in same quantities irrespective of production order quantity.

    Then you can consume those quantities using consumption journal against respective production order numbers. In this case you will not enter these items in the BOM. System allows to consume items that are not in the BOM.

    Feel free to ask if any more clarification required.

    Regards,

    Ishan

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Fixed Quantities on BOMS

    You can use XML upload or Run a ProcessOnly report to modify the quantity.

    If you want to update the quantity based on a equation ( QTY.Per PCS * PCS) then use a process only report.

    If you have excel working, then use a XML upload.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Fixed Quantities on BOMS

    hi,

    create a report (processingonly=yes) to change the BOM Line(s) of all items you want to change the quantity.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans