commit cc6ca97dc53fed52ba3e3ec5b47569c752a18aa7
author Michelle Alva <50285544+michellealva@users.noreply.github.com> Fri Sep 18 15:50:29 2020 +0530
committer GitHub <noreply@github.com> Fri Sep 18 15:50:29 2020 +0530
tree 69341fd0dd3978370623ab39b8774dfc430fcb43
parent c29ee691d4e7c5f738f0ce837c968d73599d337a

fix: Item-wise Sales History Report Error (#23349)

Co-authored-by: Rucha Mahabal <ruchamahabal2@gmail.com>

erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py

diff --git a/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py b/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
index 0a70b97..c716aa9 100644
--- a/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
+++ b/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
@@ -188,7 +188,7 @@
 		conditions += "AND so.transaction_date <= '%s'" %filters.to_date
 
 	if filters.get("item_code"):
-		conditions += "AND so_item.item_code = '%s'" %frappe.db.escape(filters.item_code)
+		conditions += "AND so_item.item_code = %s" %frappe.db.escape(filters.item_code)
 
 	if filters.get("customer"):
 		conditions += "AND so.customer = %s" %frappe.db.escape(filters.customer)