fixed in trunk.
** Changed in: openobject-addons
Status: New => Fix Released
--
[account_financial_report] Cumulative General Ledger and Full Account Balance
Bugs
https://bugs.launchpad.net/bugs/569216
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
Status in OpenObject Addons Modules: Fix Released
Bug description:
Hello, All Community,
CUMULATIVE GENERAL LEDGER
My Accounting Advisor has acknowledged me something regarding the way right now
Cumulative General Ledger is being gotten, with the latest revision of the
module account_financial_report, for periods other than opening/closing, the
Cumulative General Ledger seems to behave OK, the balance of the entries prior
to the period being asked gives the expected amounts for that period, expected
Initial Balance, expected Sum of Debits, expected Sum of Credits and finally
expected Balance.
The concerns rise with the first period where there are the opening entries.
When the Cumulative General Ledger is asked for the first period there is not
Initial Balance but the opening entries within the Cumulative General Ledger
and my advisor had said to me this is not the right behavior because debits
and/or credits of the opening entries (entries in a journal of type =
'situation') are not part of the Sum of the Debits and Credits of the first
period and the expect should be:
Initial Balance = Opening Balance, Where:
Opening Balance = [Sum of Debits of entries in a journal of type = 'situation']
- [Sum of Credits of entries in a journal of type = 'situation'](for the first
period marked as opening/closing period)
The Body of the Cumulative General Ledger are all those entries within the
period that are _not_ in a journal of type = 'situation'
Sum of Debits = [Sum of Debits of entries in a journal of type <>
'situation'](for entries in the period being asked)
Sum of Credits = [Sum of Credits of entries in a journal of type <>
'situation'](for entries in the period being asked)
Balance = [Initial Balance] + [Sum of Debits] - [Sum of Credits]
Considering all the entries withing the same fiscal-year,
A more generic solution for the Initial Balance so that the same equation be
useful for any period could be some like this:
Initial Balance = [Opening Balance] + [Previous Balance], Where:
Opening Balance = [Sum of Debits of entries in a journal of type = 'situation']
- [Sum of Credits of entries in a journal of type = 'situation'](for the first
period marked as opening/closing period)
Previous Balance = [Sum of Debits of entries in a journal of type <>
'situation'] - [Sum of Credits of entries in a journal of type <>
'situation'](for all entries before the period being asked)
FULL ACCOUNT BALANCE
As my advisor has acknowledged me the Cumulative General Ledger is the basis
for the FULL ACCOUNT BALANCE, so taking into account this assertion, then the
FULL ACCOUNT BALANCE for any period should be complaint with previous equations
stated for the Cumulated General Ledger, AFAIK, all the Trial Balances or
Account Balances that I have reviewed take into account only the Opening
Balance written by the account_voucher (please make correction about if this
the module which does that) on opening balance field in the account
(account_account module)(*) for writing the _Initial Balance_ on Trail Balance
or Account Balance, meaning that they are not cumulative and/or show wrong
information:
if a Cumulative General Ledger asked for an account:
Chart of Accounts
Code Description
1 Assets
11 National Banks
111 National Bank A
112 National Bank B
General Ledger for 2nd Period (2010-02-01 to 2010-02-28)
Yields the Following Values
Code Description
111 National Bank A
[Opening Balance]= 1000
[Previous Balance]= 2000
[Initial Balance]=[Opening Balance]+[Previous Balance]=3000
[Sum of Debits]= 600
[Sum of Credits]=400
[Balance]=[Initial Balance]+[Sum of Debits]-[Sum of Credits]= 3200
Code Description [Init_Bal] [Sum_Debs] [Sum_Creds]
[Balance]
111 National Bank A 3000 600 400
3200
112 National Bank B
[Opening Balance]= 500
[Previous Balance]= 100
[Initial Balance]=[Opening Balance]+[Previous Balance]=600
[Sum of Debits]=400
[Sum of Credits]=700
[Balance]=[Initial Balance]+[Sum of Debits]-[Sum of Credits]= 300
Code Description [Init_Bal] [Sum_Debs] [Sum_Creds]
[Balance]
112 National Bank B 600 400 700
300
Currently the FULL ACCOUNT BALANCE being gotten is something like this:
Trial Balance for 2nd Period (2010-02-01 to 2010-02-28)
Code Description [Open_Bal] [Sum_Debs] [Sum_Creds]
[Balance]
1 Assets 1500 1000 1100
1400
11 National Banks 1500 1000 1100
1400
111 National Bank A 1000 600 400
1200
112 National Bank B 500 400
700 200
which is not cumulative and is wrong because it does not take into account the
[Previous Balance]
IMHO this should be something like this,
Trial Balance for 2nd Period (2010-02-01 to 2010-02-28)
Code Description [Init_Bal] [Sum_Debs] [Sum_Creds]
[Balance]
1 Assets 3600 1000 1100
3500
11 National Banks 3600 1000 1100
3500
111 National Bank A 3000 600 400
3200
112 National Bank B 600 400 700
300
Which is complaint with paradigm of the cumulative natural of the Cumulative
General Ledger.
FULL ACCOUNT BALANCE REPORT (rml)
Regarding FULL ACCOUNT BALANCE REPORT, right now, in Spanish Translation, The
Period Being asked is translated: "Período", OK, though it would be wonderful
to add the date/period being put in the header, but the Current Period shown to
be compared is translated: "Ejercicio Fiscal", which leads to think that it is
the whole fiscalyear, and should be named "Periodo Actual" concatenated with
the date/period being put in the header, I have not tested this in English
Language.
Thank you very much in advance for your help.
(*) bug 560150, about this bug I think the opening balance field should be
calculated taking into account the entries generated by hand in the journal of
type = 'situation' _à la_ way it is calculated the closing balance field.
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
