c2c-oerpscenario team mailing list archive

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

Public bug reported:

install account
Now make a invoice for customer and validate it now open a journal items and make that invoice to reconcile with write off so when you try to reconcile with the write off analytic account so it's give a traceback 

I put a traceback here
---------------------------
LINE 1: ..._id","blocked",create_uid,create_date) values (22,(15, E'You...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
, in query insert into "account_move_line" (id,"analytic_account_id","company_id","account_id","centralisation","journal_id","name","currency_id","credit","state","period_id","debit","date","date_created","amount_currency","partner_id","move_id","blocked",create_uid,create_date) values (22,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,now())
[2011-11-03 06:51:30,368][?] ERROR:web-services:Uncaught exception
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_reconcile.py", line 171, in trans_rec_reconcile
    period_id, journal_id, context=context)
  File "/home/mma/home/workplace/rdtools/addons/trunk/account/account_move_line.py", line 898, in reconcile
    'line_id': writeoff_lines
  File "/home/mma/home/workplace/rdtools/addons/trunk/account/account.py", line 1361, in create
    result = super(account_move, self).create(cr, uid, vals, c)
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/orm.py", line 4067, in create
    result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/fields.py", line 482, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/home/mma/home/workplace/rdtools/addons/trunk/account/account_move_line.py", line 1309, in create
    result = super(account_move_line, self).create(cr, uid, vals, context=context)
  File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/orm.py", line 4031, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  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: column "analytic_account_id" is of type integer but expression is of type record
LINE 1: ..._id","blocked",create_uid,create_date) values (22,(15, E'You...
                                                             ^
HINT:  You will need to rewrite or cast the expression.

Revision
---------
addons - 5488
server - 3778
client - 1988

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

Title:
  can't write off invoice with analytic account in reconcile entries
  wizard

Status in OpenERP Addons (modules):
  New

Bug description:
  install account
  Now make a invoice for customer and validate it now open a journal items and make that invoice to reconcile with write off so when you try to reconcile with the write off analytic account so it's give a traceback 

  I put a traceback here
  ---------------------------
  LINE 1: ..._id","blocked",create_uid,create_date) values (22,(15, E'You...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
  , in query insert into "account_move_line" (id,"analytic_account_id","company_id","account_id","centralisation","journal_id","name","currency_id","credit","state","period_id","debit","date","date_created","amount_currency","partner_id","move_id","blocked",create_uid,create_date) values (22,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,now())
  [2011-11-03 06:51:30,368][?] ERROR:web-services:Uncaught exception
  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_reconcile.py", line 171, in trans_rec_reconcile
      period_id, journal_id, context=context)
    File "/home/mma/home/workplace/rdtools/addons/trunk/account/account_move_line.py", line 898, in reconcile
      'line_id': writeoff_lines
    File "/home/mma/home/workplace/rdtools/addons/trunk/account/account.py", line 1361, in create
      result = super(account_move, self).create(cr, uid, vals, c)
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/orm.py", line 4067, in create
      result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/fields.py", line 482, in set
      id_new = obj.create(cr, user, act[2], context=context)
    File "/home/mma/home/workplace/rdtools/addons/trunk/account/account_move_line.py", line 1309, in create
      result = super(account_move_line, self).create(cr, uid, vals, context=context)
    File "/home/mma/home/workplace/rdtools/server/trunk/openerp/osv/orm.py", line 4031, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    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: column "analytic_account_id" is of type integer but expression is of type record
  LINE 1: ..._id","blocked",create_uid,create_date) values (22,(15, E'You...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.

  Revision
  ---------
  addons - 5488
  server - 3778
  client - 1988

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