This is a new one for me. Changing the UOM, no jobs, no inventory, but got this error:
Cannot convert to UOM Class Count. CCDtl records already exist for this part.
cycle count dtl records maybe. ive never seen that either. See if you have any open cycles.
Ok, how do I do that? I’ve never dealt with that before.
If you have had any cost adjustments, that will freeze your UOM as well.
@Will79 do you know Sql or have access to it?
if not you will need to do a BAQ to find the cycles where that part lives.
Yes, I do have access.
This will get you the Cycle year, month and cycleseq
from that you can find the part and remove it from the cycle. that should be all you need to do
select *
from erp.CCHdr
inner join erp.CCDtl on
ccdtl.ccyear = CCHdr.CCYear and ccdtl.CCMonth = CCHdr.CCMonth and ccdtl.CycleSeq = CCHdr.CycleSeq
Where ccdtl.partnum like ‘PArtNum goes in here’
Use Part Transaction History. If anything shows up there, you’ll have some real issues changing the UOM.
Sorry to post on an old one here but I have the same issue. UOM conversion. Got this error. I made a UBAQ to update the cycle count record and swap the part to later swap back.
Well, it won’t let me update it.
Tried to delete the record from the REST API and no go either.
So I’m wondering if there is a solution.
I do not have SQL access.
SQL access is just quicker. You can do this with a ubaq. I happen to have one of these from a while back.
CycleCountClear.baq (44.9 KB)
THANK YOU! This worked perfectly!
1 Like