commit 8263bf9a9a716f7651386633fd6f26686f2008bd
author Deepesh Garg <deepeshgarg6@gmail.com> Tue Dec 27 14:59:35 2022 +0530
committer GitHub <noreply@github.com> Tue Dec 27 14:59:35 2022 +0530
tree 49de97de429d1cddda83f7681c9a0301b56fc5e6
parent 4e2291f52d5b7c23cdca26c2eaad6d926131339b

fix: Random behaviour while picking items using picklist (#33449)

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 aff5e05..8704b67 100644
--- a/erpnext/stock/doctype/pick_list/pick_list.py
+++ b/erpnext/stock/doctype/pick_list/pick_list.py
@@ -441,7 +441,7 @@
 			sle.`batch_no`,
 			sle.`item_code`
 		HAVING `qty` > 0
-		ORDER BY IFNULL(batch.`expiry_date`, '2200-01-01'), batch.`creation`
+		ORDER BY IFNULL(batch.`expiry_date`, '2200-01-01'), batch.`creation`, sle.`batch_no`, sle.`warehouse`
 	""".format(
 			warehouse_condition=warehouse_condition
 		),