Skip to main content

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?

 

Be the first to reply!

Reply