commit 67cfa81de2693b6dab00bb737143e96bb771eb6a
author rohitwaghchaure <rohitw1991@gmail.com> Mon Mar 05 11:00:42 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Mon Mar 05 11:00:42 2018 +0530
tree 42421c3b8cbc00edd703b93d00071f29f5353571
parent a9427226190f5edc6f20d6ab9009c1507bae2c2b

[Fix] Stock Ageing report does not work with group warehouse (#13151)

erpnext/stock/report/stock_ageing/stock_ageing.py

diff --git a/erpnext/stock/report/stock_ageing/stock_ageing.py b/erpnext/stock/report/stock_ageing/stock_ageing.py
index 86e1029..e93957d 100644
--- a/erpnext/stock/report/stock_ageing/stock_ageing.py
+++ b/erpnext/stock/report/stock_ageing/stock_ageing.py
@@ -96,6 +96,8 @@
 def get_sle_conditions(filters):
 	conditions = []
 	if filters.get("warehouse"):
-		conditions.append("warehouse=%(warehouse)s")
+		lft, rgt = frappe.db.get_value('Warehouse', filters.get("warehouse"), ['lft', 'rgt'])
+		conditions.append("""warehouse in (select wh.name from `tabWarehouse` wh
+			where wh.lft >= {0} and rgt <= {1})""".format(lft, rgt))
 
 	return "and {}".format(" and ".join(conditions)) if conditions else ""