openerp-india team mailing list archive

[maulik vadhar <961981@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello,
For generating Cash Register from List Of registers in POS backend menu in server 6.1-1,
I am getting error when i save record after adding closing balance in the CAsh Box,
Error is as below

Server Traceback (most recent call last):
  File "/home/maulik/openerp-6.1-1/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/maulik/openerp-6.1-1/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/maulik/openerp-6.1-1/openerp/service/web_services.py", line 572, in dispatch
    res = fn(db, uid, *params)
  File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/maulik/openerp-6.1-1/openerp/addons/account/account_cash_statement.py", line 236, in write
    super(account_cash_statement, self).write(cr, uid, ids, vals, context=context)
  File "/home/maulik/openerp-6.1-1/openerp/addons/account/account_bank_statement.py", line 46, in write
    account_bank_statement_line_obj.write(cr, uid, [line.id], {'sequence': seq}, context=context)
  File "/home/maulik/openerp-6.1-1/openerp/osv/orm.py", line 4012, in write
    self.pool.get(object)._store_set_values(cr, user, todo, fields_to_recompute, context)
  File "/home/maulik/openerp-6.1-1/openerp/osv/orm.py", line 4361, in _store_set_values
    '"'+f+'"='+self._columns[f]._symbol_set[0] + ' where id = %s', (self._columns[f]._symbol_set[1](value), id))
  File "/home/maulik/openerp-6.1-1/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/maulik/openerp-6.1-1/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "Cash Journal - (test)"
LINE 1: ...te "account_bank_statement_line" set "journal_id"=E'Cash Jou...

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


** Tags: 6.1-1 error in pos

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/961981

Title:
  POS closing balance error

Status in OpenERP Addons (modules):
  New

Bug description:
  Hello,
  For generating Cash Register from List Of registers in POS backend menu in server 6.1-1,
  I am getting error when i save record after adding closing balance in the CAsh Box,
  Error is as below

  Server Traceback (most recent call last):
    File "/home/maulik/openerp-6.1-1/openerp/addons/web/common/http.py", line 592, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/maulik/openerp-6.1-1/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/maulik/openerp-6.1-1/openerp/service/web_services.py", line 572, in dispatch
      res = fn(db, uid, *params)
    File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/maulik/openerp-6.1-1/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/maulik/openerp-6.1-1/openerp/addons/account/account_cash_statement.py", line 236, in write
      super(account_cash_statement, self).write(cr, uid, ids, vals, context=context)
    File "/home/maulik/openerp-6.1-1/openerp/addons/account/account_bank_statement.py", line 46, in write
      account_bank_statement_line_obj.write(cr, uid, [line.id], {'sequence': seq}, context=context)
    File "/home/maulik/openerp-6.1-1/openerp/osv/orm.py", line 4012, in write
      self.pool.get(object)._store_set_values(cr, user, todo, fields_to_recompute, context)
    File "/home/maulik/openerp-6.1-1/openerp/osv/orm.py", line 4361, in _store_set_values
      '"'+f+'"='+self._columns[f]._symbol_set[0] + ' where id = %s', (self._columns[f]._symbol_set[1](value), id))
    File "/home/maulik/openerp-6.1-1/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/home/maulik/openerp-6.1-1/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "Cash Journal - (test)"
  LINE 1: ...te "account_bank_statement_line" set "journal_id"=E'Cash Jou...

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