Microsoft Dynamics Blog

Welcome to Armanino’s Microsoft Dynamics Blog, where you’ll find information on topics across Microsoft Dynamics 365 ERP and CRM, Dynamics GP, Power BI, PowerApps, Flow and more. Use these tips, tricks and insights to get the most out of your applications! Want these articles delivered straight to your inbox? Subscribe to our newsletter below.

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.
UPDATE a
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.

COMMENTS

comments powered by Disqus
« | »