D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

BoM Consumption puzzle AX2009

  • 1.  BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 24 days ago
    Hi! I have a puzzle I can't solve. For our bulk manufacturing process we use 3 filters per manufactued batch. I have these on the BoM as 3 with constant consumption; however, in costing and net requirements they are coming up as 0. Is there a setting I'm missing to get the BoM to require 3 for each production?

    Thanks for any help!

    ------------------------------
    David Vezmar
    Project manager
    Dentsply Sirona
    Milford DE
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: BoM Consumption puzzle AX2009

    D365UG/AXUG ALL STAR
    Posted 23 days ago
    Hi David,

    How are your UOM set up on the filters and on the batches? Could it be possible that they are showing as inconsequentially small due to the size of the batch and the number of filters?

    ------------------------------
    Kelly Kane
    Business Analyst
    Ellipse Solutions LLC
    Dayton OH
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Thanks for the reply! I have this item set up as EA in all usages; there is no conversions set up. I'm not sure this would be the issue in this instance.

    ------------------------------
    David Vezmar
    Project manager
    Dentsply Sirona
    Milford DE
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: BoM Consumption puzzle AX2009

    TOP CONTRIBUTOR
    Posted 23 days ago
    Sounds like the "calculation" flag on the BOM line is not checked.

    ------------------------------
    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Hi Colby, Thanks for the reply.
      I do have Calculation checked for this item, I added a couple screen shot of the setup. For every batch of 1,816 KG's we use 3 filters; batch size can be variable, but we use 3 filters regardless of actual batch size.
    Thanks!
    Dave

    ------------------------------
    David Vezmar
    Project manager
    Dentsply Sirona
    Milford DE
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: BoM Consumption puzzle AX2009

    TOP CONTRIBUTOR
    Posted 23 days ago
    Definitely check the Calculation flag as Colby mentioned. When manually creating lines, this checkbox should default to enabled but I have seen it be unchecked when importing BOM lines or via other means.

    You should also check the coverage group/setup against the item to make sure it is properly setup for planning. If it has a manual-based coverage group for instance, it would not have any net requirements.

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    GA
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 23 days ago
      |   view attached
    Thanks for the reply Andrew

    I do have calc checked, my coverages look good, I'm using the same coverage I use for a majority of my purchased items.

    I attached the cost calc before and after; first shot is the cost with the item set as variable; second is when I changed it to constant. This was the only change i made.

    ------------------------------
    David Vezmar
    Project manager
    Dentsply Sirona
    Milford DE
    ------------------------------

    Conference-AXUG_200x200


  • 8.  RE: BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Hi David.
    Have you tried to use rounding up?
    I would say depending on your constant/variable consumption the quantity could be a small figure and then it needs to rounded up. I guess you need 1 pcs regardless of batch < 1816kgs.
    Another thing, your UoM is EA in captial lettes. Is this your normal UoM used in other BOM's?

    ------------------------------
    Glenn Linaa
    Tasklet Factory Mobile WMS
    aalborg, Denmark
    ------------------------------

    Conference-AXUG_200x200


  • 9.  RE: BoM Consumption puzzle AX2009

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Hi Glenn,
    I tried changing round-up to "Quantity", no dice, BoM line still is not calculating the cost for the fill 3 filters.

    Yes, we use capitol letters a lot. It does seen sometimes as though Ax is yelling at me, but you get used to it.

    ------------------------------
    David Vezmar
    Project manager
    Dentsply Sirona
    Milford DE
    ------------------------------

    Conference-AXUG_200x200


  • 10.  RE: BoM Consumption puzzle AX2009

    Posted 22 days ago
    David,

    Since consumption is constant, try changing your per series quantity on the BOM line to 1.​

    ------------------------------
    Jeff Henry
    Kai USA Ltd
    Tualatin OR
    ------------------------------

    Conference-AXUG_200x200


  • 11.  RE: BoM Consumption puzzle AX2009

    TOP CONTRIBUTOR
    Posted 17 days ago
    Not only set the rounding up to Quantity, but also set the Multiple to 3.

    If batch size is truly variable, then consider what happens if batch is less than​ (or greater than) per series value. Since you mention that 3 filters are used regardless of lot size, then use the Constant attribute. If you find historically that your batches are less than expected, you may want to resize the standard batch to distribute filter costs more appropriately.

    The BOM calculations you are doing seem to be for a lot size << 1816. What happens when the bom calc qty is for the expected lot size? If the expected lot size is 1816, you may set that value in the item details / Setup button/ Default order settings/ Inventory Standard qty.

    ------------------------------
    Mark Prouty
    Programmer / Analyst
    ANGI Energy Systems
    Janesville WI
    ------------------------------

    Conference-AXUG_200x200


  • 12.  RE: BoM Consumption puzzle AX2009

    Posted 20 days ago
    I've seen similar issues to this where by the item (filter in your case) either didn't have a calculation group assigned, or it was pulling the wrong price.

    1. On the filter's item record in Inventory Management > Item Details > References tab, check the filter has a BOM calculation group assigned. If not - you'll have to assign it one, and check the setting of that group (see below)
    2. In Inventory Management > Bill of Materials > Calculation groups, for the group assigned to the filter check where it's getting it's price from on the setup tab's Cost Price model field. We have four options in our installation: Item cost price, Item purchase price, trade agreement, stock price. The first two relate to the cost and price prices on the item's base cost and base purchase price of the filter's item record (can't advise on the other two as we do not use them). 

    3. Inventory Management > Item Details > Price/Discount tab, check that the relevant price type (cost or purchase) the calculation group is using, has a non-zero  price  set. Also on the same form, check via the Price button that the latest cost or purchase price is also has non-zero price and has a costing version (if the record doesn't have a costing version, then certain processes will not see it - possibly a bug)
    I hope this helps



    ------------------------------
    Nik Lawrence
    ERP Co-ordinator
    Hill and Smith Limited
    Wolverhampton
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role