Re: [Axapta-Knowledge-Village] Re: Customer aging by dimension

2010-04-08 Thread Agus Riyadi
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  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,
> Agus Riyadi  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  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
> > >
> > >
> > >
> >
>
>  
>


[Axapta-Knowledge-Village] Re: Customer aging by dimension

2010-04-08 Thread axaeffect
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, Agus Riyadi  
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  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
> >
> >  
> >
>