Help Required For Calculating Collection Effectiveness Index in Collection Form
HI All,
We found the below formula for Collection Effectiveness Index (CEI) from oracle doc
----------------------------------------------------------------------------
Formula: [Beginning Receivables + (Credit Sales / N) - Ending Total Receivables] / [Beginning Receivables + (Credit Sales / N) - Ending Current Receivables] x 100.
----------------------------------------------------------------------------
Could you please confirm if we are looking at the correct formula.
If yes then could you please let us know how we can fetch the value of each component in the formula. Could you point us to the fields present in the front end which contains the value of the following.
- Beginning Receivables
- Credit Sales
- Ending Total Receivables
- Ending Current Receivables
- N