if i do an inventory adjustrment for an item with average costing, can i just do quantity and the subledger work out the average cost for the GL impact?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Yes, when you do an inventory adjustment for an item with average costing, you can just adjust the quantity and the subledger will work out the average cost for the General Ledger (GL) impact. When you adjust the inventory negatively, it will come out at its current average cost. This should bring the current value/cost to zero if you take out the total inventory quantity at a location. When you adjust it back in, you can specify the new cost. It is typically recommended to do the move-out inventory adjustment first and separately (and on a different posting date) than the move-back-in inventory adjustment, to keep things clean. However, depending on your system settings, the average cost on the item record is not necessarily updated immediately after saving transactions. You should check your inventory costing preferences page. Also, 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 then on Monday bring the inventory back up to stock at the correct value. Just remember that this will change the financials in that period, and you need to use an appropriate expense account or a holding account for both inventory adjustments. Please note that even after the inventory worksheet adjustment, the Cost of Goods Sold (COGS) account may still be affected by the original cost, not the new average cost that you put in the inventory worksheet.