commit 12ad2aa2e5f5f173c9f52c07fb95e00b069dd403
author Deepesh Garg <deepeshgarg6@gmail.com> Tue Mar 28 15:33:59 2023 +0530
committer GitHub <noreply@github.com> Tue Mar 28 15:33:59 2023 +0530
tree da60d79827afdbfc48e4686346c2c7ea1f25b253
parent f7780cdb58d6678dc4b9ac45a6ab7f0cbd43a3e7

fix: Percentage billing in Sales Order (#34606)

erpnext/controllers/status_updater.py

diff --git a/erpnext/controllers/status_updater.py b/erpnext/controllers/status_updater.py
index dd2a670..58cab14 100644
--- a/erpnext/controllers/status_updater.py
+++ b/erpnext/controllers/status_updater.py
@@ -464,7 +464,7 @@
 					ifnull((select
 						ifnull(sum(case when abs(%(target_ref_field)s) > abs(%(target_field)s) then abs(%(target_field)s) else abs(%(target_ref_field)s) end), 0)
 						/ sum(abs(%(target_ref_field)s)) * 100
-					from `tab%(target_dt)s` where parent='%(name)s' having sum(abs(%(target_ref_field)s)) > 0), 0), 6)
+					from `tab%(target_dt)s` where parent='%(name)s' and parenttype='%(target_parent_dt)s' having sum(abs(%(target_ref_field)s)) > 0), 0), 6)
 					%(update_modified)s
 				where name='%(name)s'"""
 				% args