IC Item Stock Unit Conversion Factor

SOLVED

Hi..I have a question which need advise from the experts here. 

If the Item is 16.7g per bottle. And every time to use in IC BOM, it required 0.35g. How do I set the Stocking Unit Conversion in the IC Item? As the Conversion Factor not allow to use decimal. Or is it correct to set the Stocking Unit = Bottle, and Conversion = 1? 

Appreciate if anyone could advise me on this. Thank you. 

  • +1
    verified answer

    Stocking unit must be the lowest common denominator, i.e., grams, and you must allow fractional quantities.

  • +1
    verified answer

    If you set your UOM as BOTTLE, then the BOM will be using 0.2095 of the bottle which can be used in a BOM.    or you can set your BOM to be made in multiples of a full bottle.   so 16.7 / 0.35 = 47.7.  so if you make your BOM setup to be made in qty's of 47 each time you can set it to use 1 full bottle.   47 is a weird number to make, but it takes care of having a fractional remainder left in inventory.

  • 0 in reply to Mike Cook

    Thank you Mike. This item will be used as component in the BOM, and every time will use 0.35g. In this case, can I set it with smallest stocking unit is Gram and 2nd unit is Bottle with conversion factor is 16.7? In BOM, then will set to use 0.35gram instead of 0.02095 bottle? Is this the correct way of setting this IC unit and BOM ?

  • 0 in reply to Jay Converse Acumen

    Thank you Jay. After enable the Fractional Quantities in the setting, now can enter the decimals in conversion factor and also decimal in the quantity.

  • 0 in reply to Agatha_Ruby

    Yes, the stocking unit and the BOM component unit should be in the lowest common denominator.  Grams are smaller than bottles.

  • 0 in reply to Agatha_Ruby

    Sorry, I missed the reply.  The "problem" with using 0.35 grams is that it's not going to 100% use the bottle after you make 47.  it will only use a total of 16.45 grams.  so you will have an inventory remainder of 0.25 grams.  Maybe that's not a problem for you?

    and no, you don't HAVE to have the lowest denominator as the default.  You can have a conversion in decimals or in integers.   So if your default is BOTTLE, then gram will have a conversion of 0.05988023952... which is messy and probably why Jay says to make gram the default at "1" and bottle at "16.7". The downside of that is your location details will always display in GRAMS instead of BOTTLE so it can really hard to understand how much you have left.  plus you probably buy them from the vendor using BOTTLE as a UOM.   

    My opinion is to set your default at BOTTLE of 1.  make your conversion to GRAM using conversion of 0.05988.

    We sell hose, so the default UOM is FT but we also sell in INCHES so FT is the default and INCH has a conversion of 0.08333

  • 0 in reply to Mike Cook

    FYI.  You can select a different UOM for that item in location details.

  • 0 in reply to Terry Gair

    yes, but that requires manual intervention.  We prefer to leave the default as the units that will cover 90% of the transactions. We also keep them consistent with how we buy the product.  Just makes for easier housekeeping.  Plus the reorder qty's are based on the default unit of measure.