Hello,
In Posting Control settings there is a possibility to use Control type C83 - Location Group for M1 Posting Type. This means when I move Part from Location Group 1 to Location Group 2 Warehouse accounts (M1) could be different.
Currently FIFO method doesn’t support FIFO pile usage for movements transactions. Instead it uses average cost.
As a result we get incorrect balances on Account (M1).
Example:
Receive 2 pcs | Cost 50 | Location 1 | Account 1620
Receive 2 pcs | Cost 58 | Location 1 | Account 1620
Move - 1 pcs | Cost 54 | Location 1 | Account 1620
Move +1 pcs | Cost 54 | Location 2 | Account 1625
Issue -1 pcs | Cost 50 | Location 2 | Account 1625
Account 1625 has balance 4, but real quantity on the Location 2 is 0.
Attached you can find screenshots for settings and transactions.
Resume: we can’t use FIFO method in connection with C83 - Location group posting control at the moment. BUT: our customer works exactly in described way and it needs FIFO in moves transactions very much.
Request: Could FIFO method be applied to moves transactions in order to solve the problem with cost differences on M1 accounts?