Receivables - EBS (MOSC)

MOSC Banner

customer balance per period

edited Dec 14, 2011 10:42AM in Receivables - EBS (MOSC) 2 comments
Hi,

Is there a table that storage customer balance per period instead of calculate it : I want to get balance of customer ABC for DEC-11, NOV-11, OCT-11...

Example : customer ABC

SEP-11 : invoice (10000 USD)

OCT-11 : Adjustment (-2000 USD)

NOV-11 : Credit Memo (-2500 USD)

DEC-11 : Receipt (-5000)

I ask if there is a table that show directly  and without calculation (for performance needs) balance of this customer ABC 10000 for SEP, 8000 for OCT, 5500 for NOV and 500 for DEC

Regards

Mehdi Trabelsi

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