hi all, I want to pick Onhand Inventory, and the batch that should be picked usually in alpabhet order (batchid). How if I want to sort by Expiry Date ?
For Example, I have Onhand Inventory like this : Item A - Batch X - ExpDate : 20/5/2007 Item A - Batch Y - ExpDate : 18/5/2007 Item A - Batch Z - ExpDate : 21/5/2007 Right now, when we pick the item, it will pick batch X, how if I want to pick batch Y, coz the expdate is earlier. thx in advance, Ton.