Autoselect the closest expiration lot/serial

[TimSchofield]

In answer to (1) the stockserialmoves table holds a reference to the stockmoves table (the stockmoveno field) and the debtorno/branchcode can be found there, as well as the transaction type and transaction number. There is a "Serial item research tool" option which gives this information.

Hope that helps,
Tim