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

Error "The field Sales Unit of Measure of table Item contains a value (XXXX) that cannot be found in the related table (Item Unit of Measure)." in Navision 2018

(3) Share

Report

Posted on by joshtechsolutions

4,971

Dear Community,

I have an error in configuration package that i'm not sure how to rectify.

I'm trying to upload configuration package. I can't seems to find any table that contains Item unit of measure.

Can anyone advise?

Or which table to abstract to input sales/ purchase unit of measure?

Thank you!

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

Item unit of measure is table 5404.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, please check the following.

Item Unit of Measure (5404)

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
CU25091036-0 4 on at

Like (1)

Report

Hi This is Akshay from India. I have get the same issue.

Screenshots as follows.

1. Create a new production order and go to component directly

2. Open component and go to field unit of measure

3. Add your unit there

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://forum.mibuso.com/discussion/67954/unit-of-measure-issues-after-using-configuration-packages-to-upload-new-items

https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-setup-units-of-measure

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (0)

Report

It is important to note there is a difference between the "Unit of Measure" table and the "ITEM Unit of Measure" table. Most UOM look-ups will go to the "Unit of Measure" table, but if you select one that does not exist in the "ITEM Unit of Measure" table it will provide this error message. This is because you have not defined how the selected Unit of Measure relates to the Item's Base Unit of Measure, so the system doesn't know how to handle the Quantity.

To correct your situation, be sure the desired Unit of Measure is setup in the "ITEM Unit of Measure" table for the Item. This way the system can calculate a "Quantity (Base)" for the Item, which is a hidden by default field on the line.

P.S. Your Item's BASE Unit of Measure should be the smallest version of the Item, otherwise you'll likely end up with fractional (decimal) quantity on hand.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No