Hi Hemant, thx, but I think it won't work, correct me if I'm wrong, but as I look in the code, "date controlled" only look for LastUpdatePhysical in Onhand Inventory.
and I can't use automatic batch number bcoz already agreed, user will give the batch manually, also expiry date. The problem is like my example below, they can input batch number and expire date unmatch. rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, Hemant Kumthekar <[EMAIL PROTECTED]> wrote: > > Hi Ton, > > How about checking the flag on IMG Reservation "date controlled" also you would like to consider the allocation of batch numbers to be Automatic rather than manual as the number allocated will be in sequential order. > > Hemant K > > ----- Original Message ---- > From: axaeffect <[EMAIL PROTECTED]> > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Monday, May 21, 2007 10:04:38 PM > Subject: [Axapta-Knowledge-Village] Pick Inventory per Batch by ExpiryDate > > 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. > > > > > > > ______________________________________________________________________ ______________ > Be a PS3 game guru. > Get your game face on with the latest PS3 news and previews at Yahoo! Games. > http://videogames.yahoo.com/platform?platform=120121 > > [Non-text portions of this message have been removed] >