c2c-oerpscenario team mailing list archive

["Hardik Ansodariya \(OpenERP\)" <868224@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Accounting > periodic processing > end of period > generate opening
entries

#At the time of Generating open entries following Traceback found

Traceback (most recent call last):
  File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/han/rdtool/addons/trunk/account/wizard/account_fiscalyear_close.py", line 157, in data_save
    WHERE a.period_id IN ('''+fy2_period_set+''')))''', (new_journal.id, period.id, move_id, tuple(account_ids),))
  File "/home/han/rdtool/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/han/rdtool/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near ")"
LINE 17:                        AND b.period_id IN ()
                                                    ^

** Affects: openobject-addons
     Importance: Undecided
         Status: New

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

Title:
  generate open entries is not seems to working

Status in OpenERP Addons (modules):
  New

Bug description:
  Accounting > periodic processing > end of period > generate opening
  entries

  #At the time of Generating open entries following Traceback found

  Traceback (most recent call last):
    File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/han/rdtool/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/han/rdtool/addons/trunk/account/wizard/account_fiscalyear_close.py", line 157, in data_save
      WHERE a.period_id IN ('''+fy2_period_set+''')))''', (new_journal.id, period.id, move_id, tuple(account_ids),))
    File "/home/han/rdtool/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/han/rdtool/server/trunk/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: syntax error at or near ")"
  LINE 17:                        AND b.period_id IN ()
                                                      ^

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