Menu

FinBalance

sam
2007-05-09
2013-03-07
  • sam

    sam - 2007-05-09

    Hi,

    Every time we do updatebalance, probably when running a Financial Report, the updateBalance().FinBalance  does the following :

    It calculates the Balance, Total Credit, Total Debit for each day, for each account, for all the entries in Fact_Acct and enters it in Fact_Acct_Balance.

    ie., in a system implemented 4 years before, the updateBalance is going to do it for each day of the all previous years / periods as well.

    Is this an efficient way, if our above description is right ?

    won't it be better to maintain the previous year / period account balances in a separate table, so that updateBalance can start with the balances of say last year /period and can calculate the  balances of each account  for each day in this year /period only ?

    Best Regards

    Sam24368  

      

     
    • Carlos Ruiz

      Carlos Ruiz - 2007-05-09

      Hi Sam, this proposal from Victor:
      [ 1642765 ] problem with Facc_act_balance slow financial report
      http://sourceforge.net/tracker/index.php?func=detail&aid=1642765&group_id=176962&atid=879332

      Is tested and approved to be included in trunk - but still not included.

      I think it solves your problem, still not the most efficient, but better than current approach.

      Regards,

      Carlos Ruiz

       
      • Joel Stangeland

        Joel Stangeland - 2007-05-09

        +1 for including in trunk.

        We'll take anything we can get for speeding up those reports!

        Thanks, Joel

         
        • Trifon (An ADempiere founder)

          My vote is the same like Joel:

          [+1] for including in trunk

          Kind regards,
          Trifon

           
          • moyses

            moyses - 2007-05-09

            I have used Victor suggestion, and it is working quite fine.

            +1 vote for including this in the trunk.

            Regards

             
            • Carlos Ruiz

              Carlos Ruiz - 2007-05-09

              So, the decision is taken, good!!

              I tested and put my results since april 3th (more than one month ago and nobody took care of implementing!)

              Are there any VOLUNTEER to include it into trunk?

              Some additional development is needed with this inclusion:
              <-- snippet -->
              If Fact_Acct_Balance is view:
              * The process "Update Accounting Balances" could be dropped from menu.
              * The parameter "Update Balances" for "Financial Reports" and "Statement of Accounts" can be dropped
              * The method FinBalance.updateBalance can be marked as deprecated and changed to just -> return "";
              <-- end of snippet -->

              Regards,

              Carlos Ruiz

               
              • Michael Judd

                Michael Judd - 2007-05-10

                Guys - I'd be happy to look at this - in fact I've said I am happy to be involved in anything touching accounting!  But I haven't noticed where this is - if you let me know then I'll have a look at it.

                Mike

                 
                • Carlos Ruiz

                  Carlos Ruiz - 2007-05-11

                  > Guys - I'd be happy to look at this - in fact I've said I am
                  > happy to be involved in anything touching accounting! But I
                  > haven't noticed where this is - if you let me know then I'll
                  > have a look at it.

                  Hi Michael, the needed info is at this tracker

                  [ 1642765 ] problem with Facc_act_balance slow financial report
                  http://sourceforge.net/tracker/index.php?func=detail&aid=1642765&group_id=176962&atid=879332

                  Regards,

                  Carlos Ruiz

                   
    • sam

      sam - 2007-05-09

      Thanks Carlos

      Sam24368

       
    • Ramiro Vergara

      Ramiro Vergara - 2007-05-09

      Carlos,

      I still have this process we developed here in Chile that generates monthly balances. Did i send it to you for your review?

      Regards

      Ramiro

       
      • Carlos Ruiz

        Carlos Ruiz - 2007-05-09

        > I still have this process we developed here in Chile that generates monthly
        > balances. Did i send it to you for your review?

        Hi Ramiro, please upload it to contributions section.  Even better with a little explanation of how it works.

        Regards,

        Carlos Ruiz

         

Log in to post a comment.