commit e2dc102bc609028cd2d4214b7b89f6d7946a9a80
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Wed Apr 14 11:21:11 2021 +0530
committer GitHub <noreply@github.com> Wed Apr 14 11:21:11 2021 +0530
tree febf10ba1f67f41930e27f701f5b0b0d2540b2b1
parent b67058869a737614a8126b21fcba1b3b399d72c3

fix: Zero amount completed delivery notes being shown in Sales Invocie get items (#25317)

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 81f0ad3..c0c1315 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -325,7 +325,7 @@
 			and status not in ("Stopped", "Closed") %(fcond)s
 			and (
 				(`tabDelivery Note`.is_return = 0 and `tabDelivery Note`.per_billed < 100)
-				or `tabDelivery Note`.grand_total = 0
+				or (`tabDelivery Note`.grand_total = 0 and `tabDelivery Note`.per_billed < 100)
 				or (
 					`tabDelivery Note`.is_return = 1
 					and return_against in (select name from `tabDelivery Note` where per_billed < 100)