c2c-oerpscenario team mailing list archive

["Mayur Maheshwari\(OpenERP\)" <878136@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

install a account
go to Accounting/Periodical Processing/End of Period/Generate Opening Entries and open a wizard and fill all field and click a create it's give a ProgrammingError

i put a traceback heare
==========================
Traceback (most recent call last):
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/mma/home/workplace/rdtools/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/mma/home/workplace/rdtools/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/mma/home/workplace/rdtools/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 ()

revision Number
client- 1979
addons -5400
server - 3769

** 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/878136

Title:
  Generate fiscalyear Opening entries wizrd can't create  a Opening
  entries on click on create button

Status in OpenERP Addons (modules):
  New

Bug description:
  install a account
  go to Accounting/Periodical Processing/End of Period/Generate Opening Entries and open a wizard and fill all field and click a create it's give a ProgrammingError

  i put a traceback heare
  ==========================
  Traceback (most recent call last):
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/mma/home/workplace/rdtools/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/mma/home/workplace/rdtools/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/mma/home/workplace/rdtools/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 ()

  revision Number
  client- 1979
  addons -5400
  server - 3769

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