Open Forum

Expand all | Collapse all

Item Assembly BoMs

  • 1.  Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 11:47 AM
    ​​Hi,

    I am using NAV 2015. I created a new item 6000030 and within this item I created an assembly BoM. I exploded the BoM to create the Purchase Order. The Purchase Order items pulled through and were later received. Up to this part it is all good.

    My item 6000030 has a 0 qty on hand. I did a positive adjustment on the item journal for this item.

    I added the item to my Production Order and consumed item 60000030.

    The qty on hand was reduced to 0 for item 60000030 but unfortunately the items within the assembly BoM on that item card were never relieved.

    Can you please tell me what I am doing wrong.

    Thanks for your input.

    Lorna

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 01:02 PM
    Edited by Stephanie Cornwell Jun 25, 2019 01:02 PM
    Did you create and post an assembly order for that item?  That would consume the items that were ordered in and when you post it, should put one finished item into inventory.

    ------------------------------
    Stephanie Cornwell
    ERP Support & Dev
    Farmers Union Industries, LLC
    Redwood Falls MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 01:20 PM
    ​I created an Item card 6000030 with an assembly BoM attached to it. When the Purchase order was created, should I have added the item 6000030 to the purchase order and received it which in turn would have posted that I received that item. When I add it to the production order, is that when everything would have been relieved behind the item card 6000030 attached to the assembly bom?

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 02:00 PM
    So, this is our process.  We would order all the parts individually.  When they are all received, we create an assembly order for the main item.  This should bring in all of the items on the assembly BOM.  When you post the assembly order, that will put 1 of the main item (that has all the other items attached to it) into inventory.  This will include the cost of all the parts needed for the assembly.  Hope this helps.

    ------------------------------
    Stephanie Cornwell
    ERP Support & Dev
    Farmers Union Industries, LLC
    Redwood Falls MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 04:16 PM
    thank you, this is helpful.


    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 04:20 PM
    I'm not entirely sure how 2015 and 2016 differ, but you will also want to be sure to change the replenishment system to assembly. This will allow you to use the "Item Availability by" function and select "BOM Level".

    Unless you are able to purchase this assembly item from a vendor, you won't ever worry about placing the parent number on a purchase order. Only the components. You won't be able to use the "SPECIAL" or "DROP" functions to automatically pull these items in from the assembly order either.

    Last added bit: Be sure to only ever add stock of the parent number through an assembly order UNLESS you have some already made and/or the components' stock levels will not be affected. If you do a transaction, you are ONLY affecting the one part number.

    I hope this helped and didn't cause any confusion. :)

    ------------------------------
    Taylor Boardman
    Materials Coordinator
    Motan Inc
    Plainwell MI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 05:06 PM
    Thanks, the parent number is not purchased from a vendor, I attach the components to the assembly BoM on the parent item card, when I add this parent item to my production order, when I consume my items, I consume the parent number, and I would expect that this in turn will consume the components behind the parent item, but it does not do this.


    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 05:09 PM
    There are both Production BOMs/Orders & Assembly BOMs/Orders, and as far as a I know, these each belong to their own separate modules.  If you created an Assembly BOM and then a Production Order, the order would not know what components to use.

    ------------------------------
    Eric Moe
    Global Supply Chain Manager
    Industrial Revolution
    Tukwila WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 05:14 PM
    sorry about all the back and forth on this, but these answers are really helpful to me.

    Even if I identify the parent item card number (assembly BoM) in the production order, it does not recognize the components behind it? If that is the case, I will need to find a different way to do this, and suggestions are very welcome.​

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 05:20 PM
    You will need to create an assembly order for that item to get all the lower level items on the assembly BOM out of inventory.  Once that assembly order is posted, you can consume that main item on a production order.

    ------------------------------
    Stephanie Cornwell
    ERP Support & Dev
    Farmers Union Industries, LLC
    Redwood Falls MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 11.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 25, 2019 06:15 PM
    thanks everyone.​

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 12.  RE: Item Assembly BoMs

    TOP CONTRIBUTOR
    Posted Jun 26, 2019 07:01 AM
    Another approach, create a Production BOM for 600030 and put it on the parent as a BOM (I'm not near my computer, that may not be the correct type name), not as an item. This consumes the components rather than the 600030 item. You will not see usage of 600030 because only the components are consumed.


    Sent from my Verizon, Samsung Galaxy smartphone



    Conference-BCNAVUG_200x200


  • 13.  RE: Item Assembly BoMs

    TOP CONTRIBUTOR
    Posted Jun 26, 2019 08:51 AM
    Ron hit the nail on the head with this.  You do not need to have an Item for 600030.  You would create a "Production BOM" 600030, and list the components there.

    If you are familiar with the term "Phantom" Item, that is what you are creating.  The phantom has a BOM, but you never actually build or consume the parent Item.  When you add a "Production BOM" to a Bill of Material, it will explode the components at the time the Production Order is created.  This causes demand for the components, and will consume them automatically (if Backward flush is set) either when you post Output (requires Routing Link Code) or Finish the Production Order.

    You will not buy nor make Item 600030.  It is best if you do not have an Item Card for it, as it is just a Production BOM.

    P.S.  The information shared about Assembly Orders was all correct, but not what you need for your specific example.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    carmel IN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 14.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 26, 2019 08:59 AM
    Yes, I would agree with Ben as well.  One of our company uses assembly orders, the other uses production BOMS with phantoms.  But if you're trying to consume it, then it should be a production BOM.

    ------------------------------
    Stephanie Cornwell
    ERP Support & Dev
    Farmers Union Industries, LLC
    Redwood Falls MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 15.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 26, 2019 10:34 AM
    Thanks everyone, I will try this today and let you know how I do.​

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 16.  RE: Item Assembly BoMs

    SILVER CONTRIBUTOR
    Posted Jun 26, 2019 03:21 PM
    Edited by Lorna Campbell Jun 26, 2019 03:22 PM
    Worked a charm. Thank you.​

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------

    Conference-BCNAVUG_200x200


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