commit eaff54134916412456e73b081de21b68400b8b81
author Anurag Mishra <32095923+Anurag810@users.noreply.github.com> Tue Oct 22 11:46:17 2019 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue Oct 22 11:46:17 2019 +0530
tree 91fc387dbe2d2df8c8ed19ecc4a4a5348acc6f05
parent ed8e3b37860a7e4a06b87784865a5fe49179e51c

fix: query (#19376)

erpnext/stock/report/total_stock_summary/total_stock_summary.py

diff --git a/erpnext/stock/report/total_stock_summary/total_stock_summary.py b/erpnext/stock/report/total_stock_summary/total_stock_summary.py
index 41e2f86..ed52393 100644
--- a/erpnext/stock/report/total_stock_summary/total_stock_summary.py
+++ b/erpnext/stock/report/total_stock_summary/total_stock_summary.py
@@ -30,7 +30,7 @@
 
 	if filters.get("group_by") == "Warehouse":
 		if filters.get("company"):
-			conditions += " AND warehouse.company = '%s'" % frappe.db.escape(filters.get("company"), percent=False)
+			conditions += " AND warehouse.company = %s" % frappe.db.escape(filters.get("company"), percent=False)
 
 		conditions += " GROUP BY ledger.warehouse, item.item_code"
 		columns += "'' as company, ledger.warehouse"