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
SaaS Market Trends
Webinar
Between the uncertainty of 2022 and the highs of 2021, what will 2023 hold?

December 14, 2022 | 09:00 AM - 10:00 AM PT
Fraud: Current Trends & Hot Topics
Webinar
Don’t let fraud negatively impact your organization.

December 8, 2022 | 11:00 AM - 12:00 PM PT
Year-End Tax Planning for High-Net-Worth Individuals
Webinar
Optimize your tax position before December 31.

December 8, 2022 | 09:00 AM - 10:00 AM PT