Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Unit of Measure when less than a unit

Posted on by 170

I have a unit if measure problem.  For example, a unit of ours can have 12 bottles in a box.  1 Unit = 12 Bottles.  So, I have a unit of measure schedule of an inner (or bottle) to be 1/12th of a unit or a Bottle = .08333, fully using the 5 decimals places available.  We have large customers that only order by the bottle, via EDI that I can't change.

So, when they order 12 bottles it does not equal 1 unit.  It equals .99996 ... which should be 1 unit.  This is causing problems when picking the order(s).  Anybody know how to get around this kind of issue?

*This post is locked for comments

  • Suggested answer
    Olaf Laos Profile Picture
    Olaf Laos 1,890 on at
    RE: Unit of Measure when less than a unit

    Tim is right that it may not be popular with warehouse staff, but a Base UOM of bottles would work the best.

    We have in the past used the Distribution Elementz module from www.gpelementz.com to get round the warehouse staff issue.

    Distribution Elementz has various Inventory View windows that have the ability to switch the quantity views into different units of measure (based on each Inventory Item's specific options).

    Just thought it was worth mentioning...

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Unit of Measure when less than a unit

    I would suggest to consider the "Bottle" as the base Unit of Measurement as well.

  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Unit of Measure when less than a unit

    the best thing for GP purposes is to start with the smallest unit of measure and work your way up.

    with a volume unit of measure such as bottle I would even ponder using ML or Litre in metric , or oz or gallons in imperial.

    then you will be able to have different sized bottles as well as bottles, units of bottles (cases).

    With the translations in place you should be able to write reports that will please all users.

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Unit of Measure when less than a unit

    The only solution I know would be to switch to a Base U of M of Bottles.  This will probably not be popular with your warehouse manager.  Your customers will be able order in Bottles or Units and your purchasing department will be able to order it in appropriate units.  All your inventory reports and inquiries will report Bottles though.

    Tim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans