customer balance per period
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