Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Unit of Measure Within a Unit of Measure

Posted on by 3,482

Hi:

A lot of our items have a base unit of measure, such as "EA" for each.  These items need to be accounted for, within the unit of measure called CS for "case".

In Inventory, how would we accomplish placing a base unit of measure within the CS unit of measure?

Thanks!

John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: Unit of Measure Within a Unit of Measure

    Hi, I did a simple test here, maybe it will help you understand.

       

    Thanks

    ZHU

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit of Measure Within a Unit of Measure

    Hi Kim,

    Items are being created from Dataverse. The Base Unit of Measure is populated through Item Template but this doesnt update sales unit of measure?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Unit of Measure Within a Unit of Measure

    Generally, when you enter the Base Unit of Measure, the purchase and sales unit of measure fields get automatically populated. If you imported data and these fields are empty, that is why you are being prompted. Please updated the sales unit of measure field on your items and that will fix the issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit of Measure Within a Unit of Measure

    I only have one Unit of Measure for the item, but still being asked to provide sales unit of measure while doing sales order processing.

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Unit of Measure Within a Unit of Measure

    If you only have one Unit of Measure for the Item, that will also be your Sales Unit of Measure.  There should be no additional steps necessary to do what you are asking.

    If you do have multiple Units of Measure for an Item, then you use the Sales Unit of Measure field to select your preferred unit for Sales.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit of Measure Within a Unit of Measure

    I dont use multiple units, I require the sales unit of measure to be automatically populated or created. Is there a way to do so.

    Or if we can disable sales unit of measure requirement for sale orders processing?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Unit of Measure Within a Unit of Measure

    So Base Unit of Measure is your lowest unit of measure and typically how you want to count for physical inventory. As Ben stated, you can setup an unlimited number of units of measure that all related back to the base. You can purchase, sale, price in different units of measure as long and there is an 'item unit of measure' record defining the relationship to base unit of measure.

  • Verified answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Unit of Measure Within a Unit of Measure

    On the Item List/Record, go to the Item Units of Measure List.  From there you can associate the different Item Units of Measure to the Base Unit of Measure for the Item.  Here is an example:

    pastedimage1646145058964v1.png

    PCS is the Base Unit of Measure, there are 10 PCS in a Box, there are 20 Boxes in a Case, so 200 PCS, and there are 40 Cases on a Pallet, so 8,000 PCS.

    As a common rule, the Base Unit of Measure should always be the smallest unit, otherwise you start getting into fractional inventory.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans