commit b7e740ff455183e8163aeaeddd7d43b58d6f726b
author Rushabh Mehta <rmehta@gmail.com> Sat May 06 12:44:03 2017 +0530
committer Nabin Hait <nabinhait@gmail.com> Sat May 06 12:44:03 2017 +0530
tree 612c071c83e00e09ba10b6c7c40a477462a0be87
parent 51cd2df763b458dbfc1e3f76448277988995c5a1

[minor] ignore permissions for bin on warehouse_query (#8713)

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 88600e8..81c9def 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -360,7 +360,8 @@
 	sub_query = """ select round(`tabBin`.actual_qty, 2) from `tabBin`
 		where `tabBin`.warehouse = `tabWarehouse`.name
 		{bin_conditions} """.format(
-		bin_conditions=get_filters_cond(doctype, filter_dict.get("Bin"), bin_conditions))
+		bin_conditions=get_filters_cond(doctype, filter_dict.get("Bin"), bin_conditions),
+			ignore_permissions=True)
 
 	response = frappe.db.sql("""select `tabWarehouse`.name,
 		CONCAT_WS(" : ", "Actual Qty", ifnull( ({sub_query}), 0) ) as actual_qty