web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Delete Item Unit of Measure after warehouse entries/Item Jnl

(2) ShareShare
ReportReport
Posted on by 3,344

Hi 
I can change the base unit of measure after zeroing out the current inventory Qty by negative warehouse adjustment (whse item journal and post item jnl). However after changing the base UOM, I cannot delete the old item UOM line attached to the item, So i just want to confirm this is by design and you cannot delete item UOM table entry after transactions?

I have the same question (0)
  • Suggested answer
    AndrewThomas81 Profile Picture
    2,398 Super User 2026 Season 2 on at

    You cannot delete a UOM which has been used on an item.

     

    Kind Regards

     

    Andrew Thomas FCCA MCP

    YouTube - Use Business Central

    LinkedIn

  • Suggested answer
    OussamaSabbouh Profile Picture
    18,776 Super User 2026 Season 2 on at

    Hello Samantha,

    Yes, in the scenario you described this is standard Business Central behavior. Zeroing the inventory can allow you to change the Base Unit of Measure, but it does not remove the historical Item Ledger/Warehouse Entries created using the old UOM; deletion of the old Item Unit of Measure is subject to a separate validation, and the standard Item Unit of Measure table includes the CheckNoEntriesWithUoM() validation specifically for this purpose. So I would recommend leaving the old UOM on the item and simply making sure the new UOM is used as the Base/Sales/Purchase UOM as required rather than trying to bypass the standard validation or delete historical references. Microsoft also confirms that the Base UOM is the basis for how inventory quantities and alternate UOM conversions are maintained.

    Regards,
    Oussama Sabbouh

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,458 User Group Leader on at

    Hi @Samantha73 ,

     

    What is the error you are seeing? 

    Is this the error message - You cannot delete the unit of measure because it is assigned to one or more records.

     

    If this the error message then make sure that Unit of measure should not be assigned to any item.

     

    Regards,

    Saurav Dhyani

    YouTube: saurav dhyani - YouTube

    LinkedIn: Saurav Dhyani | LinkedIn

    Blog: Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 524 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 399 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 354 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans