Monday, July 1, 2013
“Serial/Lot tracked item’s receipt layer adjusted unit cost does not equal unit cost” when running IV TB reset tool in Dynamics GP
Posted by Armanino Dynamics Team
I couldn’t find the answer to the above issue published in a tech doc anywhere so I thought I’d post it here so I could find it again.
I asked my friends at Microsoft how to resolve the issue and this is what I got back.
Make sure you have a good restorable backup before proceeding.
SET a.ADJUNITCOST = a.UNITCOST
FROM IV10200 a
JOIN IV00101 b ON
a.ITEMNMBR = b.ITEMNMBR
WHERE b.VCTNMTHD in (1,2)
and b.ITMTRKOP <> 1
and a.RCPTSOLD = 0
and a.ADJUNITCOST <> a.UNITCOST
Once this error is resolved, the Open Layer exists error should go away as well.
We enable an organization by supporting each stage of your company’s growth by implementing scalable Microsoft Dynamics solutions. As Microsoft Certified solutions experts and Inner Circle Partners, we work to eliminate redundant systems and leverage existing software investments, while keeping your goals for the future in mind.