Aging analysis per month

[bumin]

Hi together,

I want to create an aging analysis

(

• open items,
• <30 days due,
• between 30 and 60 mdays due
• more than 60 days

)

  for the last rolling 12 months based on a reporting day.

I have created the aging expressions, but I couldn't define the 12 rolling months.

Has anyone did something like this before?

thanks and regards

Bumin

[bumin]

Kiran,

I want to see only the 12 last months

The report should show the aging as

per last month

per last month -1

per last month -2

...

So each bucket has to show all documents with their aging regarding the period's monthend

regards

Bumin

[#3]

Bumin,

What I would recommened is in load script create a field called document_ageing which should return Open, <30,<60 ,30-60 etc.

Then you can create this chart with document_ageing, calendar_month and count({<MonthID<={"$(=VL12Months)"}>}document_number). This would be very light and easy to use solution.

Kiran.