commit 81f916b7d38ea9d78a398ccd2e70a0651973d594
author Ankush Menat <ankush@frappe.io> Fri Jun 16 15:26:01 2023 +0530
committer GitHub <noreply@github.com> Fri Jun 16 15:26:01 2023 +0530
tree b2155f1648d9c489def33183a8ca207f9eb3d61a
parent 07d748c290453696590c723c58ba90736fe4423d

perf: Ignore cancelled pick lists while fetching picked items (#35737)

erpnext/stock/doctype/pick_list/pick_list.py

diff --git a/erpnext/stock/doctype/pick_list/pick_list.py b/erpnext/stock/doctype/pick_list/pick_list.py
index 4970bf7..2ed9209 100644
--- a/erpnext/stock/doctype/pick_list/pick_list.py
+++ b/erpnext/stock/doctype/pick_list/pick_list.py
@@ -384,6 +384,7 @@
 					(pi_item.item_code.isin([x.item_code for x in items]))
 					& ((pi_item.picked_qty > 0) | (pi_item.stock_qty > 0))
 					& (pi.status != "Completed")
+					& (pi.status != "Cancelled")
 					& (pi_item.docstatus != 2)
 				)
 				.groupby(