anyone know the best way to revalue inventory items - backdated to 1 month ago - without changing quantities? We're trying via inventory worksheet adjustment. It all looks good on screen - shows the value as of date of the worksheet vs the new value. But the GL impact (actual adjustment) seems to be based on today's inventory value (which is lower because some of the items have sold since then) ... so the adjustment is over-stated.

@Lisa We have this exact issue. The average cost of many of our items have been thrown out, and although they are all fixed now, any transactions made before the fix has the old (incorrect) average item cost in the transactions GL impact. we have also looked into worksheet adjustments but cant seem to find a way to back date them and as such have decided to just do an journal entry to correct the accounts.

ah well - we're not alone then 🤷‍♀️ - thanks!

If you have a 3 day window in history with no inventory transactions, you can bring inventory to 0 on a Friday backdated with an inventory adjustment and the on Monday bring the inventory back up to stock at correct value