Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Unit of Measure in Item Category

(0) ShareShare
ReportReport
Posted on by 245

Hi Business Central experts!

Can users set or edit Unit of Measure in Item Category page?

pastedimage1650758280023v1.png

Can Business Central Item Card change Base Unit of Measure based on Item Category dynamically?

pastedimage1650758571526v2.png

Thank you.

  • Suggested answer
    Dallefeld Profile Picture
    175 User Group Leader on at
    RE: Unit of Measure in Item Category

    Two additional things:

    1. You cannot change unit of measure once transactions have been posted

    2. Since you cannot change, this is more of a setup issue for new items. You should look into using item templates.

  • Suggested answer
    YUN ZHU Profile Picture
    81,827 Super User 2025 Season 1 on at
    RE: Unit of Measure in Item Category

    Hi, Standard can't do it, but you can do a small customization.

    pastedimage1650845928029v1.png

    For example,

    pastedimage1650846454018v3.png

    pastedimage1650846426524v2.png

    pastedimage1650846463240v4.png

    Source Code:

    tableextension 50104 ItemCategoryExt extends "Item Category"
    {
        fields
        {
            field(50100; "ZY Base Unit of Measure"; Code[10])
            {
                Caption = 'Base Unit of Measure';
                TableRelation = "Unit of Measure";
                DataClassification = CustomerContent;
            }
        }
    }
    
    pageextension 50104 MyExtension extends "Item Category Card"
    {
        layout
        {
            addafter("Parent Category")
            {
                field("Base Unit of Measure"; Rec."ZY Base Unit of Measure")
                {
                    ApplicationArea = All;
                }
            }
        }
    }
    
    tableextension 50105 ItemExt extends Item
    {
        fields
        {
            modify("Item Category Code")
            {
                trigger OnAfterValidate()
                var
                    ItemCategory: Record "Item Category";
                begin
                    if ItemCategory.Get("Item Category Code") then
                        if ItemCategory."ZY Base Unit of Measure" <> '' then
                            Validate("Base Unit of Measure", ItemCategory."ZY Base Unit of Measure");
                end;
            }
        }
    }

    Hope this helps.
    Thanks.

    ZHU

  • Verified answer
    Guy McKenzie Profile Picture
    1,330 on at
    RE: Unit of Measure in Item Category

    Not as standard. The unit of measure field you are looking at is the attribute unit of measure so wouldn’t be an ideal field to do this with.

    Reason? The attribute table allows you to have a many to one relationship to the item table so which attribute uom would you use?

    Attributes don’t need UOMs but a use case is where you record multiple attributes for a single item such as length, widths, weight, volume etc. each of these may have a different uom and none of them are necessarily the correct default uom for the item.

    In most cases, a better way to achieve what you need is with templates. Assign a default category and uom in the template. Although I have found using power automate and forms allows structured item creation with more flexibility and less maintenance than templates.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,281 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans