fix: requested filters changes
diff --git a/erpnext/stock/report/stock_balance/stock_balance.py b/erpnext/stock/report/stock_balance/stock_balance.py
index 0c71f91..8b6590d 100644
--- a/erpnext/stock/report/stock_balance/stock_balance.py
+++ b/erpnext/stock/report/stock_balance/stock_balance.py
@@ -113,6 +113,10 @@
where wh.lft >= %s and wh.rgt <= %s and sle.warehouse = wh.name)"%(warehouse_details.lft,
warehouse_details.rgt)
+ if filters.get("warehouse_type") and not filters.get("warehouse"):
+ conditions += " and exists (select name from `tabWarehouse` wh \
+ where wh.warehouse_type = '%s' and sle.warehouse = wh.name)"%(filters.get("warehouse_type"))
+
return conditions
def get_stock_ledger_entries(filters, items):