DSO Report Query

[neetu_singh]

Hi Everyone,

I need a help and its urgent. Actually, I have to design a DSO report and the calculation for this DSO is as below:

Today_Date - Invoice_Date + Limit_Days < 0, then its outstanding

this is working perfectly fine. but on current date, if i select previous month, it will not shows any outstanding.

So, i required on selection "Outstanding". Like ,now its august. so if i select "August" it will give me outstanding bt if i select "june" it will not give outstanding which i required.

If anyone have solution please reply ASAP.

Thanks in advance

[#2]

Hi,

If i understood your question, below code may help you.

Max(Selected Date) - Invoice_Date + Limit_Days < 0

-Sridhar

[orlando]

Hello

perhaps this helps:

=if(num(Invoice_Date)+Limit_Days<num(today()),'outstanding since ' & date(num(Invoice_Date)+Limit_Days) ,'not outstanding')

Regards

Orlando