commit 872a23c77d6fed002be10bbcc476e75ad7ba63e2
author mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> Mon Jul 10 20:34:54 2023 +0530
committer GitHub <noreply@github.com> Mon Jul 10 20:34:54 2023 +0530
tree 59a1113df6a8e4bc5186ef7ac28423cd3ba33c7c
parent 361a35708852d2b8dda2a8dfcb33119ff743b94d

fix: also check on_hold (#35910)

fix: also check on_hold (#35910)

(cherry picked from commit 5aa02b8571efdc1710a9b3069a18a80ed17856a2)

Co-authored-by: RJPvT <48353029+RJPvT@users.noreply.github.com>

erpnext/accounts/utils.py

diff --git a/erpnext/accounts/utils.py b/erpnext/accounts/utils.py
index 31473db..8b44b22 100644
--- a/erpnext/accounts/utils.py
+++ b/erpnext/accounts/utils.py
@@ -850,7 +850,7 @@
 
 	if party_type == "Supplier":
 		held_invoices = frappe.db.sql(
-			"select name from `tabPurchase Invoice` where release_date IS NOT NULL and release_date > CURDATE()",
+			"select name from `tabPurchase Invoice` where on_hold = 1 and release_date IS NOT NULL and release_date > CURDATE()",
 			as_dict=1,
 		)
 		held_invoices = set(d["name"] for d in held_invoices)