commit b1cbe221b77430099229f7c9b558a986190ace9f
author Nabin Hait <nabinhait@gmail.com> Fri Feb 15 14:24:30 2019 +0530
committer GitHub <noreply@github.com> Fri Feb 15 14:24:30 2019 +0530
tree c5a936f9c50ff42a378e135af0722be7df84286e
parent 9d858760867a12208d1ad4ef67f987f20afc7712
parent a0c9c7501b7aa378cf1001b1bc1c41f61db8bbd9

Merge pull request #16677 from nabinhait/total-qty-patch-fix

fix: Consider parenttype while updating total qty in transactions

erpnext/patches/v11_0/update_total_qty_field.py

diff --git a/erpnext/patches/v11_0/update_total_qty_field.py b/erpnext/patches/v11_0/update_total_qty_field.py
index fcb76af..992454a 100644
--- a/erpnext/patches/v11_0/update_total_qty_field.py
+++ b/erpnext/patches/v11_0/update_total_qty_field.py
@@ -19,9 +19,10 @@
 			SELECT
 				parent, SUM(qty) as qty
 			FROM
-				`tab%s Item`
+				`tab{0} Item`
+			where parenttype = '{0}'
 			GROUP BY parent
-		''' % (doctype), as_dict = True)
+		'''.format(doctype), as_dict = True)
 
 		# Query to update total_qty might become too big, Update in batches
 		# batch_size is chosen arbitrarily, Don't try too hard to reason about it