Dear All,
Whenever I try to adjust the posted inventory transactions and on hand inventory through 'adjustment' functionality in 'closing and adjustment' but some of transactions are populated on other than many of transactions didn't.
Scenario:
Item A received 10 Qty @ USD 500 with existing opening inventory of 5 Qty @ USD 100 this means you have running average of USD 366.67/unit. Now, the company realized that Inventory received at USD 500 which is actually not correct instead it must be USD 100.
Now, logically the transactions should be adjusted and running weighted average should be USD 100. I passed adjustment (Closing and Adjustment > Adjustment > Transactions > Select (Item, No other filter) > adjustment > item cost price > post) but I checked some of the transactions were not affected and on hand running weighted average didn't become USD 100. How should I adjust the inventory when I can't move out the whole inventory from warehouses? And, why transfer orders didn't populate in adjustments form for adjustment?
*This post is locked for comments
Using either the Adjustment -> Transactions or Adjustment -> Onhand, you will only accomplish adjusting the value of inventory receipts, either specific ones (via Transactions) or unspecific ones (via Onhand). If any inventory issues were posted at what would now be an incorrect average cost based on the new receipt values, you must use the Recalculation process to adjust the value of inventory issues to inventory receipts (according to your actual cost inventory model, i.e. FIFO, LIFO, etc.), after which the outstanding/unmatched receipts (which in total comprise your current on-hand value) should then reflect the correct average cost.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156