Best Way To Undo An Item Journal

Jonathan2708

Hi,

A journal has been posted to move stock from one location to another, however it was done incorrectly and the result is although the quantities moved are correct, the value of the stock has now changed dramatically. It seems the stock was booked out at one cost and booked back in at a much lower cost.

Searching this forum I have found suggestions saying to prepare an opposite journal using the 'Applies-to' and 'Applies-from' fields, but this can't be done because stock has been booked out since the adjustment so the quantities will not match.

I have tried posting a revaluation journal using the latest unit costs I have but this still leaves the stock valuation too low.

Any help appreciated on this one, I'm desperate to get this sorted as management reports are being delayed.

Thanks,

Jonathan

Alex_Chow

Because it deals with costing, what you've described is the best way of handling it.

In 5.0, you now have the option of Undo Application in inventory to use the Applies-to Entry function. What version are you using?

Jonathan2708

Hi Alex,

Thanks for the reply. It's Navision 4.01 objects (SP3 client).

It seems the revaluation journal is the way to go, I just need to retrieve what the unit costs were before the journal was posted, maybe from a backup.

One other thing though - I can see how much the cost value has moved for each item as a result of the journal being posted - is there no journal type I can use to just shift the cost movement back the other way?

Jonathan