Topic: Inventory valuation report error for locations after stock transfer
Regarding the Inventory valuation report,
Sum of each location value is not equal with All location value, after location transfers.
Transferred item cost are calculated with new location cost, instead of old location cost.
I get 2 locations ( L1 and L2 ) and one product A.
There is 1 qty in L1 with cost $1 ( L1 total value is $1)
There are 2 qty in L2 with cost $2 ( L2 total value is $4)
Total cost value for All location is $5. ( it is correct before undergoing a transfer )
After doing a transfer of 1 qty from L2 to L1, the result showing as followed,
2 qty in L1 with cost $1 ( L1 total value is $2)
1 qty in L2 with cost $2 ( L2 total value is $2)
so, sum of each location value is $4, which is not correct.
If I select all location, the result is showing $5, which is correct.
So, We get problem to get inventory valuation by each location after stock transfer.