c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <785659@xxxxxxxxxxxxxxxxxx>]

in your video the line "initial balance" is always zero (see below)

Please do not select  "filter date" - IMHO should not be necessary to
see all  moves of the current/selected year.

self.init_query is called  796 times ( 384 accounts) - performance ???

and it is clearly visible that it restricts the the fiscal  year to the
selected one, hence it is not possible to display the "initial balance"
of unclosed years.

at least in Austria it's mandatory to display the initial balance for each account (regardless if the previous year is closed or not)  but I doubt that this is possible with the current code. 
to be able to do this with closed fiscal years it is necessary to have  special period(s) or  special journal(s) to filter account move lines from the current year which represent the opening balance.

l.state <> 'draft' AND l.period_id IN (SELECT id FROM account_period
WHERE fiscalyear_id IN (9))   AND l.journal_id IN
(11,3,15,5,16,13,2,18,17,1,10,14,4,9,20,19) AND l.account_id IN
(6,136,139,7,8,146,9,10,147,148,149,150,151,152,153,374,11,12,13,154,14,155,156,157,158,159,160,161,162,164,15,165,16,166,167,168,17,169,170,171,172,173,174,175,176,177,178,181,182,183,23,18,19,236,179,180,20,24,184,187,186,25,26,188,189,190,423,191,192,445,193,194,195,196,197,198,199,200,201,230,140,202,28,29,30,31,32,33,34,35,36,37,38,39,40,41,203,42,204,43,205,44,206,50,51,52,225,226,227,53,228,229,45,46,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,48,49,420,425,222,223,224,416,403,54,55,231,232,233,234,424,235,401,402,237,238,239,240,241,242,137,123,145,124,263,125,126,265,127,407,266,267,269,270,271,272,452,453,134,273,705,422,135,274,128,129,442,268,131,132,133,243,262,244,142,59,245,60,405,419,246,247,248,249,62,63,250,251,252,253,254,255,61,64,406,65,404,66,67,440,68,439,449,69,438,447,70,441,71,436,450,72,437,446,409,256,257,258,259,421,260,261,138,143,73,74,75,76,408,276,454,381,77,78,79,277,278,279,80,280,281,282,283,284,82,285,286,287,288,289,428,290,87,295,296,291,292,293,294,297,88,89,90,91,386,298,299,300,301,302,303,304,305,380,96,306,97,98,307,99,101,100,308,102,309,103,310,311,434,312,448,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,113,114,329,331,330,118,4,451,433,332,333,334,335,336,337,338,339,340,342,343,344,346,119,347,348,349,435,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,367,368,369,370,371,372,426,373,365,366,427)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/785659

Title:
  general ledger - initial balance wrong data

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  specifying 
  * include initial balances 
  calculates the balance of the SELECTED time range and puts it as initial and adds it to the total balance which then shows the double balance of the selected timeframe, which is clearly wrong and nonsense.

  IMHO 
  * include initial balances has or  should have the only purpose to include the balance of the past unclosed year(s) as initial balance if AND only if the previous fiscal years are not closed and no moves with the initial balance are created yet.