openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Expired => Invalid

-- 
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):
  Invalid

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