Advanced Collections - EBS (MOSC)

MOSC Banner

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.

  1. Beginning Receivables
  2. Credit Sales
  3. Ending Total Receivables
  4. Ending Current Receivables
  5. N

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center