Calculation of Average collection period through Drill Down Reporting

[former_member205946]

Dear Gurus,

I created key performance indicator for our company (key Accounting Ratios) through t code FSI3 , FSI4 & FSI5. Through drill down reporting i created all the KPIS sucessfully. but i need assistance to create Average collection period for the company

Standard Accounting formula is

Receivables*365/Annual credit sales

i can easily map the figures of receivables and credit sales for any specific period through "FS ITem " but how can i automatically get number of days in drill down reporting. If i hard code 365 days in the formual, my result will not depict actual result as if i executing this report after first month of the year, number of days in multiplication should be 31

very quick response is expected as i always received from SDN

thnx

Sajida

[Former Member]

Hi Atif,

Awesome Document. Gr8 Job. Thanks for sharing such informative knowledge.

[former_member205946]

waiting for reply

[former_member205946]

waitng for solution

[former_member205946]

Dear Gurus,

please help me out that how number days can be calculate automatically by considering system date for Average Collection Period calculation

[former_member205946]

dear Gurus,

i am waiting for the solution. any body to help me??

[former_member205946]

please help