As a reminder to new readers, Weekly Reviews are former Weekly Dynaimc tips that I want to make sure that you don't miss, just because you weren't with us back in 2007.
While cleaning out our year end inventory, we found an item with a wrong unit of measure, but a correct value. We didn't have 3 million feet of bubble wrap on hand, but if we could have gotten that for $1,100 it would be a steal. So the value is right, the quantity is wrong and I'm staring at this trying to figure out how to adjust the quantity without affecting the GL (because $1,100 is the right value) and without screwing up anything else.
Then it hit me, write the whole thing off. Bring the count and the GL value to 0 and then write the whole thing back on at the correct unit of measure and the same value.
It worked perfectly. No SQL adjustments, no inventory transactions that didn't post to the GL to explain to the auditors. Last cost is correct. FIFO layers are correct.
Originally Posted by Mark at 1/19/2007 05:18:00 PM
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
