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!