Hi James, I just debug the code again, turns out someone blocked the transaction with return lot id (Class InventAdjTransSelect).
I just change it back to default code, and my credit note transaction appeared. Thanks for your help. Ton. --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" <djf1...@...> wrote: > > Hi Ton, > > A quick look in AX4.0 SP1 (sorry no Ax3.0 handy right now) shows that the > only 2 criteria set as default in the Query InventTransAdjust (maybe you can > check the query in your AX3.0, look in the ranges of teh data source) are: > 1) StatusReciept: Purchased > (criteria is set as Open rather than Locked so would seem a bit scary that > user might be able to actaully select an issue transaction ...no time to > test but do let us know if you test it and it really can be cahnged so > issues can be selected) > > 2) PackingSlipReturned: No > I am guessing maybe your credit note trasnaction has this as Yes hence why > it is not getting picked up > Why is this filtered out I guess because when you reverse a delivery note > the inventtrans gets status sold and purchased even though really there is > no financial and so fitlering packingslipupdate=no means they will make sure > to avoid allowing the user to adjust any of these transactions. The problem > is I think a valid sales credit note transaction (at least in AX3.0 I > believe seeing it) can also end up with thise field = Yes (and I am not sure > whether fitlering out such transactions is what the programmer had in mind) > > Let us know if this is the reason you cannot pick up the transaction. > > The only quick way I know would be either to write off the item and bring it > back in with the different cost in a journal OR adjust the original reciept > and let it flow through to the credit note (assuming easy to track back so > for sure forget it if you are using average plus that the original reciept > is still not closed) > > Good luck and do report back > James > > _____ > > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of > anton_tjiptadi > Sent: Friday, January 30, 2009 7:30 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Re: How to correct wrong cost amount in > Credit Note > > > > O ya, sorry, forgot to mention. It's Ax 3.0 :) > Thanks. > > --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com, "James Flavell" > <djf1994@> wrote: > > > > Is the inventory transaction already closed? > > > > What version of AX are you using? > > > > Thanks > > James > > > > > > > > _____ > > > > From: Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com > > [mailto:Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com] > On Behalf Of > > anton_tjiptadi > > Sent: Thursday, January 29, 2009 6:00 PM > > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com > > Subject: [Axapta-Knowledge-Village] Re: How to correct wrong cost > amount in > > Credit Note > > > > > > > > Hi James, > > > > It doesn't appear in the list even I already mention the voucher > > number or Lot Id in the selection. > > > > thanks, > > Ton > > > > --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% > 40yahoogroups.com> > > vill...@yahoogroups <mailto:Village% 40yahoogroups.com> .com, "James > Flavell" > > <djf1994@> wrote: > > > > > > Are you sure inventory transaction adjustment cannot change it? I > > thought > > > any reciept could be affect by this function? > > > Thanks > > > James > > > > > > > > > _____ > > > > > > From: Axapta-Knowledge- > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com > > > [mailto:Axapta-Knowledge- > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com] > > On Behalf Of > > > anton_tjiptadi > > > Sent: Thursday, January 29, 2009 5:16 PM > > > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% > 40yahoogroups.com> > > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com > > > Subject: [Axapta-Knowledge-Village] How to correct wrong cost > > amount in > > > Credit Note > > > > > > > > > > > > Dear all, > > > > > > I have Credit note (return SO) which has wrong value with its > cost > > > amount. > > > > > > How to adjust it since Inventory Adjustment doesn't apply to > Credit > > > note / Return sales order. > > > > > > Thanks in advance, > > > Ton > > > > > >