Batch Issue - Piling of list

[neilLasrado]

in forms where batch is used as a link field. the list of batch numbers that appear in the drop down are sorted based on time of creation ( LIFO ) . It must rather be based on expiry date. So the ones expiring
first are shown first and then the later batches.

Taken from Mehul B. Mehta from Mehta Herbs and Spices via Support Ticket Number #WN-SUP10808

[RealDesignGraphics]

I agree

[sbkolate]

With small modification in get_batch_no query we can sort batch with expiry

[RealDesignGraphics]

where is that screen shot from?

[sbkolate]

This is from Delivery Note
Above screen shot shows, Batch No. sorted based on expiry date. So the ones expiring
first are shown first and then the later batches.

Updated screen shot shows available batch qty at warehouse

Please see this:

https://discuss.frappe.io/t/available-batch-qty-at-warehouse-in-dn-si-and-batch-sorted-based-on-expiry-date/5021

[RealDesignGraphics]

I guess I mean from what screen would I see this? from the stock module? or from sales? I assume it is from the new version

[sbkolate]

Currently this is in developing mode.
If this merge with v4 you can see result like this is Delivery Note and Sales Invoice.

[rmehta]

@sbkolate pull request please !

[rmehta]

Lets do v5 only.

[sbkolate]

I have allready send pull request for v4.

I will also send pull request for v5.

[nabinhait]

@sbkolate Thanks for the PR, merged it. No need to send PR for v5, I will merge it in v5.

Can you please send a pull request for get_batch_no query to sort batch with expiry?

[cgpurbaugh]

Can this be closed?