Open Forum

Expand all | Collapse all

Single Item Assembly BOM

  • 1.  Single Item Assembly BOM

    Posted 7 days ago
    Has anyone ever created an assembly BOM out of a single Item with no resources or process?
    Example:  A quantity of 1 for Item #123, becomes a quantity of 4 by adding water, however, the water is not part of the BOM (don't know why, but it's not).
    I not sure about this, but I'm being told that it can be done.​​​

    ------------------------------
    Xan
    Katy TX
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Single Item Assembly BOM

    TOP CONTRIBUTOR
    Posted 7 days ago
    Xan-  This is an interesting one.  Before we jump into solutioning, what have you tried?
    1. Did you make water a $0.00 cost/price item and consume it? 
    2. Did you try using a non-inventory item type (this is in BC, I don't remember if it was in NAV) for the water?
    3. Did you test playing with the UOM to try to make this work?  Converting from 1 to 4 is tough because the Assembly tool is designed to go the other way (4 components turn into 1 assembled item)
    This one is tricky.  Please share what you implement with the group.

    Best of luck!

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Single Item Assembly BOM

    SILVER CONTRIBUTOR
    Posted 7 days ago
    Hello Xan,

    We have a 1 item BOM.

    There's an item that we have to buy from our vendor as 1 part number, but it's quoted and sold as a different part number. So, we create a job order to pick the one piece and put it into stock as the other.

    Hope that helps. :)

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

    Conference-BCNAVUG_200x200


  • 4.  RE: Single Item Assembly BOM

    TOP CONTRIBUTOR
    Posted 7 days ago
    As far as using a single component line for a assembly item BOM is not an issue. The one to 4 is where you need to defime your UOM carefully on all the parts/resources.

    if say you add 1 gallon of water and it increases the item 123 to 4 cu ft from 1 cu ft the you would add 1 quart of water and .25 of 123 to make 1 cu ft of the final assembly.

    or something like that.

    ------------------------------
    Michael Carr
    VP , Finance
    Philadelphia Scientific LLC
    Montgomeryville PA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Single Item Assembly BOM

    GOLD CONTRIBUTOR
    Posted 7 days ago
    We do this all the time, especially when we have customers that order one tem number, but want their invoices, packing lists, and BOLS to show a different Item Number.   We set up their desired item number as a BOM with our Item Number going into theirs.   It is no big deal.   There are no special hoops to jump through in NAV to make this work, at least not in NAV 2015.  :-)

    ------------------------------
    Steven Hoag
    I.T. Manager
    Fashion Angels Enterprises, LLC
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Single Item Assembly BOM

    TOP CONTRIBUTOR
    Posted 6 days ago
    @Steven Hoag

    It is not necessary to use BOM to be able to reference an item by the customer's number.

    NAV has cross references to assign customer and/or vendor item numbers to your Item No. These are set up on the item card.

    Select the item from the Cross Reference field (you may need to make this column visible) on sales and purchase docs. Even if you select an item by using your internal NAV Item No., if one exists, the customer's cross reference will fill in the Cross Reference No. field.

    You just need to modify your sales and shipping docs to print the cross reference when one exists either in addition to or instead of your item no.
    CR

    SO



    ------------------------------
    Cynthia Priebe
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Single Item Assembly BOM

    GOLD CONTRIBUTOR
    Posted 6 days ago
    Yes, that is an option for some, but we need to segregate the items at the warehouse.   We often need to reserve goods at the distribution center for these customers, and by using the BOM method, the item numbers are changed to the customer specific item number and everyone then knows that those are only for that particular customer.  So we run Assemble to Stock operations using these BOMs.

    Probably not the most efficient way of dealing with this, but it did greatly reduce the number of issues we have had when dealing with reserve quantities at our DC as well as making it easier for our order entry people to see quantities available to sell when they are entering in orders.

    The other benefit that we have found is that we can quickly see what has been reserved for specific customers and we can look back at the date on the BOM to see how long these have been sitting around.   If the customer has not taken them after a month of being "on reserve", we can contact them and ask if they still want them.   Provides a chance to encourage the customer to reorder, and gives us a chance to get things off reserve if the customer no longer wants it and we can than sell those goods to someone else.

    Previous to this method, we had goods that had been put in a "reserve bin" for a customer that decided they did not want the entire quantity.   These goods would sit neglected in the warehouse as nobody was looking at it, and the "reserve bin" method did not show us who those items were reserved for.

    It is a system that has now worked for us and the way our DC and sales teams operate.    That is the great thing about NAV, you can make it work to fit your operating procedures, rather than having to change your way of working because your ERP is inflexible.   We had that issue before NAV.

    ------------------------------
    Steven Hoag
    I.T. Manager
    Fashion Angels Enterprises, LLC
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: Single Item Assembly BOM

    TOP CONTRIBUTOR
    Posted 6 days ago
    @Steven Hoag with this additional information I can see that you are actually not just referencing ​your item by a different number provided by the customer, but "transforming" an existing item to a customer specific items and stocking it for them.

    You are correct, we have flexibility with NAV and you found a process that works for you - nice!

    ------------------------------
    Cynthia Priebe
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: Single Item Assembly BOM

    Posted 6 days ago
    OK.  So if I understand this correctly, they need to "Assemble" a new Item number?

    ------------------------------
    Xan
    Katy TX
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: Single Item Assembly BOM

    GOLD CONTRIBUTOR
    Posted 6 days ago
    We do assign a new item number so that we can keep track of these separately.

    You want to keep the same item number?   So you will have some of item 123 as one each and some item 123 that are now 4 eaches?

    I can see where that could become very confusing.

    ------------------------------
    Steven Hoag
    I.T. Manager
    Fashion Angels Enterprises, LLC
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


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