Merge lp:~openerp-dev/openobject-addons/6.0-opw-578072-han into lp:openobject-addons/6.0

[Hardik Ansodariya (OpenERP)]

Fixed the issue of fiscal year.

SQL request get all period before date_stop to select entry lines which
are used to calculate initial foreign currency amount.

So opening entries of new year will be wrong.

e.g if there are 2010,2011,2012 fiscal year.

If we want to close 2011 year and generate a entries for 2012 but it will brings both the year 2010,2011 so opening entries of 2012 will not math with closing year 2011.

With reference of Maintenance case: 578072

Thanks

[Naresh(OpenERP) (nch-openerp)]

review: Approve

Unmerged revisions

5340. By Hardik Ansodariya (OpenERP) on 2012-09-28

[FIX] account: Fixed the issue of close fiscal year (Maintenance case: 578072)

=== modified file 'account/wizard/account_fiscalyear_close.py'
--- account/wizard/account_fiscalyear_close.py	2012-04-27 06:57:05 +0000
+++ account/wizard/account_fiscalyear_close.py	2012-09-28 11:57:37 +0000
@@ -93,11 +93,8 @@
             obj_acc_move_line.unlink(cr, uid, move_line_ids, context=context)
             obj_acc_move.unlink(cr, uid, move_ids, context=context)
 
-        cr.execute("SELECT id FROM account_fiscalyear WHERE date_stop < %s", (str(new_fyear.date_start),))
-        result = cr.dictfetchall()
-        fy_ids = ','.join([str(x['id']) for x in result])
         query_line = obj_acc_move_line._query_get(cr, uid,
-                obj='account_move_line', context={'fiscalyear': fy_ids})
+                obj='account_move_line', context={'fiscalyear': old_fyear.id})
         #create the opening move
         vals = {
             'name': '/',