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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
> 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,
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
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
+1 for including in trunk.
We'll take anything we can get for speeding up those reports!
Thanks, Joel
My vote is the same like Joel:
[+1] for including in trunk
Kind regards,
Trifon
I have used Victor suggestion, and it is working quite fine.
+1 vote for including this in the trunk.
Regards
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
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
> 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
Thanks Carlos
Sam24368
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
> 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