Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Inventory Adjustments

Posted on by 575

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

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,786 on at
    RE: Inventory Adjustments

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans