c2c-oerpscenario team mailing list archive

["Fabien \(Open ERP\)" <fp@xxxxxxxxxxx>]

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.