Error al procesar una retención del IVA

[Rafael Dominguez]

Al intentar procesar una retención del IVA en contabilidad->Withholding->Withholding Vat->Withholding Vat Customer y al introducir el partner, aparece el siguiente mensaje de error:

ERROR:db.cursor:Programming error: column res_partner.special does not exist
LINE 1: ...ve = E'True') AND (res_partner.ref = E'ide') AND (res_partne...
                                                             ^
, in query SELECT "res_partner".id FROM "res_partner" WHERE (res_partner.active = %s) AND (res_partner.ref = %s) AND (res_partner.special = 'True') AND (res_partner.customer = %s) ORDER BY name limit 100
ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/ralph/Proyectos/openerp/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/ralph/Proyectos/openerp/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/ralph/Proyectos/openerp/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/ralph/Proyectos/openerp/server/bin/addons/base/res/partner/partner.py", line 196, in name_search
    ids = self.search(cr, uid, [('ref', '=', name)] + args, limit=limit, context=context)
  File "/home/ralph/Proyectos/openerp/server/bin/osv/orm.py", line 1743, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/ralph/Proyectos/openerp/server/bin/osv/orm.py", line 4025, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/ralph/Proyectos/openerp/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/ralph/Proyectos/openerp/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column res_partner.special does not exist
LINE 1: ...ve = E'True') AND (res_partner.ref = E'ide') AND (res_partne...

[Rafael Dominguez (venccsralph)]

La solución para el bug anteriormente descrito es:

=== modified file 'l10n_ve_withholding_iva/wh_iva_view.xml'
--- l10n_ve_withholding_iva/wh_iva_view.xml 2011-05-12 01:12:48 +0000
+++ l10n_ve_withholding_iva/wh_iva_view.xml 2011-06-11 18:27:53 +0000
@@ -148,7 +148,7 @@
                         <field name="journal_id" select="2" domain="[('type','=','iva_sale')]"/>
                         <field name="type" select="2"/>
                         <field name="code" select="1"/>
- <field name="partner_id" on_change="onchange_partner_id(type,partner_id)" select="1" domain="[('special','=',True), ('customer','=',True)]"/>
+ <field name="partner_id" on_change="onchange_partner_id(type,partner_id)" select="1" domain="[('customer','=',True)]"/>
                         <field name="currency_id" />
                         <field name="date_ret" />
                         <field domain="[('type','&lt;&gt;','view'), ('company_id', '=', company_id)]" name="account_id"/>

[Javier Duran (javieredm)]

Recuerda postear el ambiente de trabajo(server, addons, cliente gtk, web client, etc y los mas importante la localización) para poder reproducir las condiciones que originarón el bug.

Saludos,

[Javier Duran (javieredm)]

Corregido en el trunk de la localización:

revno: 365
revision-id: javier@squezee-vir-20110616203845-j83amaefg4vqidha

[hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha)]

Por favor cambiar el estado de este bug, si ya fue corregido,

Saludos

[hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha)]

Este bug no se presenta en OVL70,

Se pasa a Fix Released

Saludos.