Armanino Blog
Article

"Serial/Lot tracked item's receipt layer adjusted unit cost does not equal unit cost" when running IV TB reset tool in Dynamics GP

July 01, 2013

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.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
IPO Prep & SOX Compliance: Instacart & Armanino Share Hard-Earned Knowledge
Webinar
Know your compliance requirements today to avoid obstacles tomorrow.

December 16, 2021 | 11:00 AM - 12:00 PM PT
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Why COP26 Matters for Your Business Webinar
Webinar
Get informed of COP26 developments and how you can act now.

December 15, 2021 | 10:30 AM - 11:00 AM PT