commit bd33bdf21069a3c916f3675364869dac422ab164
author rohitwaghchaure <rohitw1991@gmail.com> Thu Jul 29 19:51:53 2021 +0530
committer GitHub <noreply@github.com> Thu Jul 29 19:51:53 2021 +0530
tree cfb8e884795ede768dd8c55d1fd5705cfc8c6186
parent b7bbefee1571c6ad25dbaa353998706c69597306
parent 19a6d809272ab4efeb6ef57d45d47b71f6d8fec6

Merge pull request #26717 from deepeshgarg007/pricing_rule_item_group

fix: Parent condition in pricing rules

erpnext/accounts/doctype/pricing_rule/utils.py

diff --git a/erpnext/accounts/doctype/pricing_rule/utils.py b/erpnext/accounts/doctype/pricing_rule/utils.py
index b54d0e7..94abf3b 100644
--- a/erpnext/accounts/doctype/pricing_rule/utils.py
+++ b/erpnext/accounts/doctype/pricing_rule/utils.py
@@ -168,7 +168,7 @@
 			frappe.throw(_("Invalid {0}").format(args.get(field)))
 
 		parent_groups = frappe.db.sql_list("""select name from `tab%s`
-			where lft>=%s and rgt<=%s""" % (parenttype, '%s', '%s'), (lft, rgt))
+			where lft<=%s and rgt>=%s""" % (parenttype, '%s', '%s'), (lft, rgt))
 
 		if parenttype in ["Customer Group", "Item Group", "Territory"]:
 			parent_field = "parent_{0}".format(frappe.scrub(parenttype))