commit 21ea6cdb91a4887702e081bfefa475fa6b723302
author Zarrar <zarrar65@gmail.com> Tue Dec 12 18:54:17 2017 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue Dec 12 18:54:17 2017 +0530
tree 63a070c0fc149d931614f964be1126ef4f0c25dc
parent bb7fab52d1fbb47fc06f88d9efc6d4d9e1617f53

batch.expiry should be sorted in ascending order too (#11960)

erpnext/stock/doctype/batch/batch.py

diff --git a/erpnext/stock/doctype/batch/batch.py b/erpnext/stock/doctype/batch/batch.py
index 6dac647..760643c 100644
--- a/erpnext/stock/doctype/batch/batch.py
+++ b/erpnext/stock/doctype/batch/batch.py
@@ -151,7 +151,7 @@
 		'where `tabStock Ledger Entry`.item_code = %s and  `tabStock Ledger Entry`.warehouse = %s '
 		'and (`tabBatch`.expiry_date >= CURDATE() or `tabBatch`.expiry_date IS NULL)'
 		'group by batch_id '
-		'order by `tabBatch`.expiry_date DESC, `tabBatch`.creation ASC',
+		'order by `tabBatch`.expiry_date ASC, `tabBatch`.creation ASC',
 		(item_code, warehouse),
 		as_dict=True
 	)