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
Costco Travel Webinar
Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022