Why does Sage 300 not seem to convert the unit weight when clearly using a UOM that is different than the stocking UOM?

SOLVED

Sage 300 OE module has 3 units of measure per line.  A pricing UOM, invoice UOM and costing UOM.  However it does not have a weight UOM, so it is taking the unit weight (which is for the default stocking unit of measure, and not using the conversion factor to determine the actual weight of the goods on the line.
Obviously, this can be an issue for shipping, especially if data is transferred from one system to another without manual intervention.

Andy ideas out there?

Thanks in advance.

  • 0

    for example:  Unit Weight is .7921 lbs.  for a dozen toothbrushes.  However, a customer ordered 20 eaches, which we have got the pricing and invoice UOM's correctly for display on the customer invoice.

    But the weight is not calculating based on the different UOM settings, which are correct.  So it is saying that 20 toothbrushes weighs 15.54 lbs, which is crazy wrong.

    Also, when the system picks up the weight of the order through the shipping system, because it is not converting here, it is rating the shipment at 15lbs instead of at 1.32 lbs.

    Am I missing something?

  • 0 in reply to Jody Roberts

    we don't know how you setup your conversions.  You main UOM should be EA with a conversion of 1.  so then the unit weight would be 0.7921/12 if that's the weight for the dozen.   you could have a UOM of "DOZ" with a conversion of 12 so then when you type up 12, it should equal 0.7921

  • +1 in reply to Mike Cook
    verified answer

    Like Mike said, the unit weight is the weight of the the Stocking Unit of Measure.  If your Stocking UOM is dozen then the Each UOM should have a conversion factor of 1/12 or .083333.  

    Another way of doing this is making your stocking UOM Each with a unit weight of 0.066008. 

    Dana