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.
Although we solved this problem by modifying the core code, we still believe that the moving average should be calculated at the parent warehouse level, I hope that this option can be added in the coming version, and I am willing to assist.
You need to do modification in the core python files
And you need to review the code after every release
I dont think it is easy to share the solution because it is littile bit complicated.
I hope frappe can add the option to calculate the moving average on parent warehouse level , that will be a great think epically that most of our clients prefer this option