Unit of Measure issues after using configuration packages to upload new items

pabloquintanapabloquintana Member Posts: 20
edited 2016-11-20 in NAV Three Tier
Hello, I have been using the configuration packages to upload batches of new items. First, I faced a validation error related to the unit of measure not being found from the second line onwards. I disabled the validation for that field and everything went smoothly. I could then, directly in the item card, change the UOM to something else and then put it back and it worked.

Things got a little bit more complicated when I continued uploading manufactured items with BOMs attached. The items seem fine on the cards, I can even get their BOM structure reports, standard costs calculated, and everything.

Problem now is that it is complaining again related to the UOM when I try to plan a production order from the sales order. Message says:

The field Unit of Measure Code of table Prod. Order Component contains a value (PZ) that cannot be found in the related table (Item Unit of Measure)


Any advice as what to look for? I do not have access to developer code or anything, just a super user.


Best Answer


  • Options
    vremeni4vremeni4 Member Posts: 323

    It looks to me you imported the data for the items but you did not import the same UoM in the "Item Unit of Measure" table, hence the error message.
    You can correct in following way
    on the Item Card click on NAVIGATE tab and then "Units Of measure" Here you can insert the "Item Unit of Measure"
    Press F1 on the filed to get more information about how to setup an Item

    I hope this helps.
  • Options
    pabloquintanapabloquintana Member Posts: 20
    Hi, I found the problem. There were items in the BOM that didn't have PZ in their UOM table. Hopefully this will help someone else.
Sign In or Register to comment.