openerp-expert-accounting team mailing list archive

[Humberto Arocha <humbertoarocha@xxxxxxxxx>]

Oh Thanks for the thorough explanation, excellent, I am aware of this issue
in openerp,
I have read somewhere about those breakthroughs of Ferdinand though I have
no taken
a deep and insightful review of the matter,

I think that in order to keep each party happy regarding using one approach
or another
it could be useful to make the module aware of those changes that way it
could be transparent for each party, it will involve some programming time
and before doing that
make agreements about how it should be tackled, even before reaching that
point, there
should be agreements regarding the module as you commented before in order
to try to
submit ifrs_report into OCA branches.

I believe that it is the way where you are heading, Am I right?

Please keep me posted with your comments

Best Regards.


2014-03-08 1:01 GMT-04:30 Eric Caudal <eric.caudal@xxxxxxxxxxxxxx>:

>  By default OpenERP calculates accounting reports recalculating
> systematically up-to-date balance since the beginning of the fiscal.
> This means that every time you print a report you need to recalculate all
> BB for every month which are supposed to be closed and fixed which is not
> efficient and besides leads to overheads in report printing (all the more
> when you easily ends with hundreds of thousands or millions of accounting
> moves.
> Solution proposed by Ferdinand relies on calculating once for all the sums
> at the end of each month and using these sums for reporting instead of
> recalculating everything.
> This is (was) actually the same problems for the stock moves and stock
> level: I am not sure it has improved with the new WMS structure (I would
> say so)
>
>
>  Eric Caudal*CEO*
> --*Elico Corporation, Shanghai branch
> OpenERP Premium Certified Training Partner *
> Cell: + 86 186 2136 1670
> Office: + 86 21 6211 8017/27/37
> Skype: elico.corperic.caudal@elico-corp.comhttp://www.elico-corp.com
>
> [image: Elico Corp]
> On 03/07/2014 07:12 PM, Ferdinand Gassauer wrote:
>
> On 2014-03-07 14:04, Eric Caudal wrote:
>
> my answer  is a bit off topic, nevertheless I believe OpenERP should stop
> gathering financial data/reports form account_move_lines.
> have a look into
>
> http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/chricar_account_period_sum/
> this module "guarantees" constant response time, regardless of the number
> of account_move_lines.
>
> the 12month data are available in the module - the opening balance is
> separated from January (first month) data.
> the module allows to drill down
> account-year-period-move-lines. and compares selected with last year.
>
> BTW - do you know these modules
>
> https://code.launchpad.net/~account-report-core-editor/account-financial-report/7.0
> IMO a lot of common code could be reused. (data selection)
>
> If a KPI module (as well as other financial reports) is created I strongly
> suggest to base it on monthly data aggregates - especially for companies
> with millions of move lines.
>
>
> Hi Dear community member,
> A couple of questions for the week-end...
> I am wondering about if there a module to generate a 12-month BS/PL in
> 7.0, which is a standard in the accounting world.
>
> Second million-dollar question: is there a user friendly way in 7 to get
> financial KPI such as:
> 1)      Return on equity ratio
> 2)      Return on common stock holders equity ratio
> 3)      Explanation of positive and negative leverage
> 4)      Capital gearing ratio
> 5)      Fixed asset to equity ratio
> 6)      Current assets to equity ratio
> 7)      Debt to equity ratio
>
> If we develop a solution, I would be happy to hear about best practices
> concerning setup and/or usability.
>
> Have a nice week-end!
>
> --
>
> Eric Caudal*CEO*
> --*Elico Corporation, Shanghai branch
> OpenERP Premium Certified Training Partner *
> Cell: + 86 186 2136 1670
> Office: + 86 21 6211 8017/27/37
> Skype: elico.corperic.caudal@elico-corp.comhttp://www.elico-corp.com
>
> [image: Elico Corp]
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-expert-accounting
> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> --
> Ferdinand
>
>
>