Skip to main content

Notifications

Supply Chain Management forum
Under review by Community Managers

Under review

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

Inventory transfer journal has unbalanced values after inventory recalculation

Posted on by
So, we have a bit of a strange case.
 
We have an inventory transfer journal from warehouse A to B. In our setup warehouse is tracked financially, so it is a "financial" transfer as well. We are running FIFO inventory valuation model.
 
1. When the journal was initially posted, everything was fine - it posted 2 transactions of let's say -10 pieces of an item from warehouse A and +10 pieces of the same item to warehouse B. The financial amount of both transactions matched and the total financial impact was zero - as it should be.
2. Then we did an inventory recalculation and the issue transaction of the transfer got adjusted for whatever reason (probably adjusting to FIFO) - which also caused the same adjustment to the receipt transaction. The transfer journnal was still balanced and the financial impact was zero.
3. Then we did another inventory recalculation which touched this transaction, but this time something weird happened: the issue side of the transfer was adjusted by some amount and the receipt side was adjusted byt a totally different amount. So now we have a situation that the inventory changed value just by being transferrred (which should not happen in our inventory valuation model) and the ledger account connected with inventory transfer journals shows a balance (which it should't)
 
I would be grateful if anyone knows of possible causes of such behaviour. This seems to be a rare case - we are doing thousands of inventory transfer journals (and transfer orders) and this is the first time it happened.
 
We are on F&O 10.0.38.
 
Thanks!
Categories:

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans