Thanks Eddie I have not had time to study any of the new features in AX2009 :( The new standard costing does not allow closing to be done is it? The fix as far as I understand for this report is to comment out the line in the InventDimAge.calcALL() method: inventDimParm.ClosedFlag = NoYes::Yes;
This way the report picks up all inventsum so going to be slower if you have a lot of different inventdim but at least accurate ;) Thanks James _____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 05 January 2009 18:54 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Inventory Aging by dimension bug!? Hi James Good work. Thanks for sharing as we also have some clients using this. Just for your information, I have done some tests in Ax2009 with this report, especially running the new standard costing model, concluding that this report does not cater for the new model as it is based on an inventory close! Regards Eddie --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com, "James Flavell" <djf1...@...> wrote: > > Dear friends, > > Based on what my programmer has checked and also discussed with some friends > this is indeed a bug in AX4.0 and is also still there in AX2009!!! > > Supposedly when it was reported to MS they basically replied that they would > not be fixing it and so it is up to the partner/customer to fix!!!! :o > I have yet to submit a support requst to MS so dont know this is the > official reply they will give > > Happy AXing in the new year > > Thanks > James > > > > _____ > > From: James Flavell [mailto:djf1...@...] > Sent: 05 January 2009 14:20 > To: 'Axapta-Knowledge- <mailto:%27Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com' > Subject: Invenotry Aging by dimension bug!? > > > Hi everyone > Happy New Year to you all!!! > > A great way to start the new year for me...with a bug ;) > > I have just investigated a customer's inventory aging report by dimension > not being the same as the inventory value by dimension and found it seems > the aging report just ingroes all inventsum that have Closed=YES!!!!! > > Such logic is of course wrong as it does not factor in when was the > inventsum closed > > Example: > 1) Purchased 1/1/2009 > 2) Sold 2/1/2009 > 3) Closing run 3/1/2009 > 4) Aging run on 4th with As at date 1/1/2009 - > result report is empty > > The aging report (InvnetDimAge) is only in the SYS layer > This is in a AX4.0 SP2 so was a little shocked to find noone in MS had found > this by the second service pack. > > Has anyone else come across this problem? > I will be looking to see if the latest DIS layer for AX4.0 SP2 has a fix but > if anyone has it setup and running and can compare report InventDimAge to > SYS that would be real helpful. > > Thanks > James >
