Hello,
comment #4 => When user select future fiscal year we will keep Start and end
periods to empty.
comment #3 => We have already fixed this problem in revision number 4702.
So I am closing the bug for now.
Thanks all for your contribution.
Regards.
mra
** Changed in: openobject-addons
Status: Fix Committed => Invalid
--
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):
Invalid
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))
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
