Title: Eric CAUDAL
|
On 2014-03-08 09:31, Eric Caudal wrote:
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
the monthly sums are updated on the fly when the move state changes
to "posted". (non locking technique).
A big advantage is that at years end, the opening balance of all
accounts is ALWAYS in sync with the years end.
A modern accounting should not rely of computation of opening
balance on "closing". This creates a very high degree of uncertainty
during the first few weeks/month of a new year, because the user
will not necessarily know if the opening balance includes all
previous years moves or not. especially in a multi user environment.
Typically the user who is interested in KPI should not be bothered
with manual preparations to get correct values.
According to our experience in companies with many people working n
accounting, every department has it's own "schedule"
- * bank - 1-3 days time lag
- * debitor - 1-5 days time lag
* creditor - 1-25 days time lage - until the latest supplier
invoices arrive.
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.corp
[email protected]
http://www.elico-corp.com
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
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.corp
[email protected]
http://www.elico-corp.com
_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-accounting
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-expert-accounting
More help : https://help.launchpad.net/ListHelp
--
Ferdinand
_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-accounting
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-expert-accounting
More help : https://help.launchpad.net/ListHelp
--
Ferdinand
|
_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-accounting
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-expert-accounting
More help : https://help.launchpad.net/ListHelp
