I have configured average costing for all products. after using 10 days it's balance sheet current stock value and inventory valuation report value is not matched.
Below is Case-
ProdX on hand 10.0 and rate is 1.0 USD total cost is 10.0 USD
Sold 20.0 qty on hand is -10.0 and rate is 1 USD so total cost is -10.0 USD
Buy 8.0 qty with rate 2.0 USD . Now On hand -2.0 and Average price auto update as -3 and On hand value is 6.0 USD.
Now If I sell product, it's stock value get increased, is that ok?
Average cost and stock value calculation is
average cost = ((existing onhand * cost price)+(Incoming qty * cost price))/(existing onhand+Incoming qty)
Stock Value = onhand quantity * average cost
ProdX on hand 10.0 and rate is 1.0 USD total cost is 10.0 USD (onhand=10,cost=1,value=10(10*1))
Sold 20.0 qty on hand is -10.0 and rate is 1 USD so total cost is -10.0 USD (onhand = -10, cost=1, value=-10(-10*1))
Buy 8.0 qty with rate 2.0 USD . Now On hand -2.0 and Average price auto update as -3 and On hand value is 6.0 USD. (onhand=-2(-10+8), cost=-3((-10*1+8*2)/(-10/8)) , value=-2*-3)
This is right only (if it will show -6 then awesome because stock is -2)
issue is odoo calculation formula seems not ok. stock valuation should not be positive if we have negative on hand qty.