Hi Axl, The standard aging report works as follow : - Loop through custtable - Find "open" transaction for this custtable (calling to CustVendBalanceList* classes) - allocate to aging columns
Then you might need to change as follow - Loop through all department - Loop through custtable - Find "open" transaction for this custtable, modify the CustVendBalanceList* classes to be filtered by department. - allocate to aging columns. Maybe this is not done in standard because there is a lot of variation, e.g. group the transaction by currency, print transaction by sales rep (order account) etc. Hope that helps, Agus On Thu, Apr 8, 2010 at 3:08 PM, axaeffect <axaeff...@yahoo.com.sg> wrote: > > > Hi agus, > > Can u describe a bit about the modification ? Actualy this kind of report > will be ask million times, I wonder why till now the standard Aging can not > provide it. :) > > Thanks, > Axl > > > --- In > Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > Agus Riyadi <agusa...@...> wrote: > > > > Hi, > > > > We met this similar kind of requirement and the only solution that we > found > > was to modify the Aging report. > > > > Best Regards, > > > > Agus > > > > On Wed, Apr 7, 2010 at 11:00 AM, axaeffect <axaeff...@...> wrote: > > > > > > > > > > > Hi all, > > > > > > In report customer aging (A/R -> reports -> Status -> Aging report), is > > > there a way to group it per dimension. > > > > > > For example if I have activated 1st dimension (Department), in that > report > > > I want to group it per department, not just sort by customer account, > > > because there is a case my customer transaction is in many department. > > > > > > Thanks in advance, > > > axl > > > > > > > > > > > > > >