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
> > >
> > >
> > >
> >
>
>
>