Thank you Muzzy.
Let me explain what I am asking for?
I have one item “A”, and two warehouses (1 ,2).
if I create 2 material receipts as following
Item A Warehouse 1 QTY 2 Rate 1.5
Item A Warehouse 2 QTY 2 Rate 2
if check the valuation rate in Stock Balance report, I see that the valuation rate is 1.5 for warehouse 1 and 2 for warehouse 2
I am expecting the right rate should be :
(1.52) + (22) / 4 = 1.75
Thank you for your advice.
Actually, it’s possible. Many standard ERPs allow you to choose the valuation area for stock at configuration time. Company level or warehouse level. Some even track two at the same time and allow you so specify a custom valuation level.
Unfortunately, it is only on warehouse level.
I think Moving average should be on company level by default. And the exceptional is on warehouse level.
I think this is a big problem and should be solved soon
At setup, you should be able to choose a “organisational level for valuation”. Options should at least be Company and Warehouse with possibility to even value at the level of a custom dimension. Different types of businesses tend towards valuation at different organisational levels. Manufacturers usually at warehouse level. Retailers usually at company level. Not always clear-cut.