Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Fixed Quantities on BOMS
Microsoft Dynamics NAV (Archived)

Fixed Quantities on BOMS

(0) ShareShare
ReportReport
Posted on by mescandon 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

  • Sigfredo Beerman Profile Picture
    Sigfredo Beerman on at
    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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans