Bucket in the customer ageing report

(0) Share

Report

Posted on by imran ul haq

3,992

Hi All

Here i have one question, in my ageing report the buckets are based on the month. But the user want the report based on the days, like the bucket of 0-30, 31-60, 61-90, 91-120 days and the calculation will be based on the days. My aging is coming like:

8081.11.jpg

for example,if invoice due date is 16- Jan -2016 and we generate the ageing as of 15- Jan-2016 so it will appear in 30 column as per AX ageing and it should be in Not Due column.

how can i fix this issue, please advise

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bucket in the customer ageing report

Hello Imran,

Please have a look at the examples provided on the following sites

technet.microsoft.com/.../aa634713.aspx

prashantcs2009.wordpress.com/.../aging-period-definitions-ax-2012

Note that the collections list page includes by default a separate column with the open amount as of today. Maybe this is something you can use alternatively?!

Also note that the aging buckets are quite limited in regards to the number of columns that are allowed to be created (max six). If you require more you need to create several aging period definitions and run your reports several times as adjusting the aging buckets is quite complex.

Hope this information helps

Ludwig

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

RE: Bucket in the customer ageing report

Try this. Instead of using Aging periods, use a straight 30 day interval with direction Backward, using 1/15 as the Balance as of date.

The columns then align as follows.

Was this reply helpful? Yes No