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

pabloquintana

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.

Thanks

pabloquintana

Thanks vremeni4. I did check what you suggested here. I actually went to the table Unit of Measure and found that every item No. has the UOM PZ there.

I see in that table 5404 Item Unit of Measure one line with a blank Item No. field. Could that be an issue? How can I delete that line without developer access?

vremeni4

Hi,

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.

pabloquintana

Thanks vremeni4. I did check what you suggested here. I actually went to the table Unit of Measure and found that every item No. has the UOM PZ there.

I see in that table 5404 Item Unit of Measure one line with a blank Item No. field. Could that be an issue? How can I delete that line without developer access?

pabloquintana

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.