Merge pull request #16548 from nabinhait/stock-balance-item
fix: Fetch data based on item group filter in item dashboard stock balance report
diff --git a/erpnext/stock/dashboard/item_dashboard.py b/erpnext/stock/dashboard/item_dashboard.py
index d817e5f..6242fa7 100644
--- a/erpnext/stock/dashboard/item_dashboard.py
+++ b/erpnext/stock/dashboard/item_dashboard.py
@@ -13,7 +13,13 @@
if warehouse:
filters.append(['warehouse', '=', warehouse])
if item_group:
- filters.append(['item_group', '=', item_group])
+ lft, rgt = frappe.db.get_value("Item Group", item_group, ["lft", "rgt"])
+ items = frappe.db.sql_list("""
+ select i.name from `tabItem` i
+ where exists(select name from `tabItem Group`
+ where name=i.item_group and lft >=%s and rgt<=%s)
+ """, (lft, rgt))
+ filters.append(['item_code', 'in', items])
try:
# check if user has any restrictions based on user permissions on warehouse
if DatabaseQuery('Warehouse', user=frappe.session.user).build_match_conditions():