c2c-oerpscenario team mailing list archive

["Vinay Rana \(openerp\)" <783123@xxxxxxxxxxxxxxxxxx>]

Hello,

By taking reference from comment #4, I am confirming this issue.The
query needs some improvement against the future fiscal year selection.

Thanks.

** Summary changed:

- account chart - start and end period reversed
+ account chart Fiscal Year Onchange - start and end period is not working for future fiscal year.

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: Incomplete => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

-- 
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/783123

Title:
  account chart Fiscal Year Onchange - start and end period is not
  working for future fiscal year.

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  after selectiong the fiscal year the start/end periods show up in the
  wrong fields

  obviously the UNION statement in
  account/wizard/account_chart.py
  does not guarantee a correct result, even the period id's are ascending
  IMHO these statements must be separated 

              cr.execute('''
                  SELECT * FROM (SELECT p.id
                                 FROM account_period p
                                 LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id)
                                 WHERE f.id = %s
                                 ORDER BY p.date_start ASC
                                 LIMIT 1) AS period_start
                  UNION
                  SELECT * FROM (SELECT p.id
                                 FROM account_period p
                                 LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id)
                                 WHERE f.id = %s
                                 AND p.date_start < NOW()
                                 ORDER BY p.date_stop DESC
                                 LIMIT 1) AS period_stop''', (fiscalyear_id, fiscalyear_id))