fix: sum stock_value and group by warehouse
diff --git a/erpnext/stock/dashboard_chart_source/warehouse_wise_stock_value/warehouse_wise_stock_value.py b/erpnext/stock/dashboard_chart_source/warehouse_wise_stock_value/warehouse_wise_stock_value.py
index 5bb6446..d488150 100644
--- a/erpnext/stock/dashboard_chart_source/warehouse_wise_stock_value/warehouse_wise_stock_value.py
+++ b/erpnext/stock/dashboard_chart_source/warehouse_wise_stock_value/warehouse_wise_stock_value.py
@@ -33,8 +33,9 @@
warehouses = frappe.get_list(
"Bin",
- fields=["warehouse", "stock_value"],
+ fields=["warehouse", "sum(stock_value) stock_value"],
filters={"warehouse": ["IN", warehouses], "stock_value": [">", 0]},
+ group_by="warehouse",
order_by="stock_value DESC",
limit_page_length=10,
)