RE: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate
Yes the date controlled wont help you need to untick that so it will do reservation based on batch number. The easiest is to make the dateexpiry be prefixed on to the start of the batch number, either as a manual process or do some modification that the user fills in a batch field (new) and the expiry date and it makes the actual batch id field out of these 2 All the best James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axaeffect Sent: 21 May 2007 23:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate 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] > Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
Re: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate
Hi, If the user is going to enter the batch number manually then you have only option is to modify your lookup for Batch numbers (on Hand tab) so that the inventory is displayed in sequence of Expiry date, also if your printing any Pick list then you can print the available batches in expiry date sequence (it is a modification). Hemant K - Original Message From: axaeffect <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, May 21, 2007 10:30:41 PM Subject: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate 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- [EMAIL PROTECTED] ups.com, Hemant Kumthekar 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- [EMAIL PROTECTED] ups.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] > Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate
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] >