c2c-oerpscenario team mailing list archive

["Bharat Devnani \(Open ERP\)" <870099@xxxxxxxxxxxxxxxxxx>]

Hello Stéphane Bidoul,

Thanks for your time, I have checked your mentioned problem. But
according to the latest changes made in trunk, user has to select Start
Period and End Period manually due to the line pointed below which is in
account_report_common.py.

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
                               AND p.special = false                                                       <------------------------ 
                               ORDER BY p.date_start ASC, p.special 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()
                               AND p.special = false                                                        <------------------------ 
                               ORDER BY p.date_stop DESC
                               LIMIT 1) AS period_stop''', (fiscalyear_id, fiscalyear_id))

So, there are no chances that the start and end period are inverted
through onchange, until p.special = false becomes true.

Hope this will help you.

Thanks & Regards,
Devnani Bharat R.

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

Title:
  accounting report filter: period start and end are sometimes swapped

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  In the accounting reports wizard, when the Period filter is selected,
  *sometimes* the start and end period are inverted.

  This bug is due to the UNION statement in the query, which attempts to
  eliminate duplicates and does not preserve order (see
  http://www.postgresql.org/docs/8.4/interactive/queries-union.html).

  Using UNION ALL instead solves the problem.

  Patch attached.

  Best regards,

  -sbi

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/870099/+subscriptions