DSO Calculation in FD33

[Former Member]

Hi Guys,

Can you Please guide me on step by step for the DSO calculation in the transaction code : FD33?

But I tried to use the formula for DSO calculation as per below:

DSO= ( Total Receivables / Sum of Clearing amount ) * 365 = XXX DAYS

Can anyone let me know the exact calculation for DSO

Thanks

Murali

[jpfriends079]

You can refer one of previously discussed SDN thread of similar sort by me in past:

-

Regards

JP

[Former Member]

Hi,

Thanks you very much for given replay.

In my case DSO calculation show in as below:

Calculation Basis: Current Balance 003 Months all children

Cust.no--CoCde- Curr.- Days

---

Balance

---

Sales/day---DSO

6205485--

---

INR - -

---

2,089,710.34-----23,376.41--0089

6205485--6201u2014INR-0115--

---

1,562,610.34--- 18,792.93-0083

6205485-6202-INR- 0115

---

527,100.00 -

---

4,583.48--0115

In the above case how we will get DSO and day sales value ( 20,010.99 )

Thanks

Murali

[Former Member]

Hi,

In my case DSO calculation show in as below:

Calculation Basis: Current Balance 003 Months all children

Cust.no--CoCde- Curr.- Days

---

-Balance

---

Sales/day---DSO

6205485--

---

INR

---

2,089,710.34---23,376.41-0089

6205485--6201u2014INR-0115--

---

1,562,610.34---- 18,792.93---0083

6205485-6202 -INR- 0115

---

527,100.00 -

---

4,583.48--0115

In the above case how we will get DSO ratio=83 and day sales value (18,792.93 )

Thanks

Murali

[former_member184701]

The DSO days are calculated by setting the balances against the sales. The DSO days are calculated using the following formula:

DSO =balance/sales per period x 30

regards,