Cost Rollup fails due to UOM Issue!

We are having issues with a Cost Rollup. We get this error during the Load process.

Unit of measure conversion not found for Class:Length UOM:EA

I wrote a quick query to see if there were any parts in the database where the UOM Class was Length and the IUM was EA. No records were returned. Has anyone seen this and do you have any other suggestions on what to do next? We are on 10.1.600.8 and have about 350,000 parts in the database.

Hey Rick,

Have you written a BAQ linking Part to PartMtl and look for the UOM in PartMtl <> the UOM in Part. I would think that these are the two pieces that would be used by the roll up.

Mark W.

1 Like

It could happen if a part was originally on a BOM as Buy To Job, and then a Part entry - using the same PartNum - was created, but with the class Length.

To add to @Mark_Wonsil suggestion about a BAQ for Part to PartMtl, Iā€™d add the table criterias of

PartMtl.UOMCode = 'EA'
AND Part.UOMClassID = 'Length'

Edit:

Might also need to query the PartTran table to see if any entries exist for a Part whose Class is Length, but the transaction UOM was EA

2 Likes

Thanks Mark and Calvin. The query looking at those tables did return a part number. We are running the Costing Workbench again and will advise on how it worked out. Thanks again for your help!