Skip to Content
0
Former Member
May 08, 2008 at 05:00 PM

FI-AR Aging Report

670 Views

Hi Friends,

I am working on FI-AR Aging report on 0FIAR_C03 Cube. My BI objects for calculations are:

0DEB_CRE_DC (KeyFigure)

0NETDUEDATE (Char)

When user execute the query, he has to key-in few variables:

Type-In date (default is today’s date)

Aging Basket (user configurable 0-30 days, 31-60 days, etc.)

Calculation needed:

Current Due Amount = 0DEB_CRE_DC, whenType-In date is greater or equal to Net Due Date

Past Due Amount = 0DEB_CRE_DC, when Type-In date is less than Net Due Date

Current and Past Due Amount should be displayed on Aging colums (0-30days, 31-60 days, etc)

If anyone has done similar queries please help.

Thank you and regards,

~S