I have a problem with one job giving an odd error whenever “Get Details” or “Delete Subassembly” clicked. The error says “Unit of measure not found for Class: UOM:EA” which seems like a part doesn’t have a UOMClassID. I’ve checked all the parts and nothing is missing a UOMClassID.
I can still add subassemblies and materials one at a time but that is very time consuming and error prone on something as complex as this job. There are hundreds of subassemblies and thousands of parts.
Has anyone encountered anything like this before or know where to look?
Wondering if there is a part record that somehow got corrupted. I would expect this to read something like
“Unit of measure not found for Class: COUNT UOM:EA”
It looks like the Class is blank.
Also, this…
Is there some kind of UOM conversion going on and it is not fully set-up?
Perhaps one of the parts (or the job) is trying to convert a length to a count, but the conversion is not setup correctly?
1 Like
That was my thought initially too. I checked all the parts and nothing is missing a UOMClassID. It is only on this one job and there are 3 nearly identical jobs currently ongoing. I would think it would have to be a problem in one of the Job tables but I can’t see anything wrong in them either.
I believe UOMConvInternal runs on everything in the job whenever you delete an assembly or get details for an assembly. There is nothing to convert though. The UOMs are the same in the MOM and Inventory.
Do you use the “Part Specific” functionality in UOM? If so run query on all the materials on that job to check that the conversion factor is filled in for the “EA” UOM on those materials.
Thanks Chris, I should have thought to check that earlier. Unfortunately, that’s not the problem. They are all set up. It is unlikely to be at the part level since there are 3 nearly identical jobs and only 1 has this issue.
I have opened a ticket with Epicor. They asked me to disable all BPMs and try again. There was no change. They seem at a loss to explain it too so far.
Just as an update. I had to upload my database and development is looking into it. I haven’t heard anything back yet and it’s been a couple of weeks.
I had this type of error once and it was on the JobPart table. Mine was missing so I built a ubaq to fix it.
Thanks @gpayne, I checked the JobPart table and it looked fine to me, but it made me want to take a closer look at other Job tables.
I checked the JobMtl table again for anything where the IUM and BaseUOM were different. I had previously checked all our parts for missing “Part Specific” conversions as @E102016 suggested, but what I hadn’t considered is someone putting a one-off part in there as material. I found one material where someone had put the job number as the part number. Since that part number doesn’t exist, Epicor must have defaulted the BaseUOM to EA. The person entered an amount in SQIN. And since that part doesn’t exist, it has no Part Class, resulting in the empty Class when trying to run a conversion that also doesn’t exist.
1 Like