4 Replies Latest reply: Sep 28, 2010 12:57 PM by Cesar Estrada RSS

    Inital Balance

      Hi People:

      I need calculate initial balance for accounts, with this structure.

       

      The Data is:
      YearMonthDateAccountDebitCredit
      2010401/04/2010E100500
      2010409/04/2010E100300
      2010508/05/2010E100400
      2010516/05/2010E101120
      2010711/07/2010E20080
      2010719/07/2010E10030
      2010825/08/2010E200140
      And need show ..
      YearMonthAccountbeginning balanceDebitCreditbook balance
      20104E1000500300200
      20105E1002005200720
      20107E100720030690
      TotalE10001020330690
      20105E10101200120
      TotalE10101200120
      20107E200080080
      20108E200801400220
      TotalE20002200220
      Grand Total01360330-1690


      Is possible? any idea?

      Thanks! regards

      César Estrada