Buongiono ragazzi, stamattina mi e' sorto un problema che non riesco a capire come risolvere.. volevo pagare dele fatture ma mi appare qsto errore:
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 247, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 76, in __call__
return getattr(self, method)(*params)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 633, in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 613, in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/wizard/__init__.py", line 178, in execute
res = self.execute_cr(cr, uid, data, state, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/wizard/__init__.py", line 154, in execute_cr
return self.execute_cr(cr, uid, data, next_state, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/wizard/__init__.py", line 73, in execute_cr
action_res = action(self, cr, uid, data, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/wizard/wizard_pay_invoice.py", line 88, in _pay_and_reconcile
period_id, writeoff_journal_id, context, data)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/invoice.py", line 976, in pay_and_reconcile
move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1026, in create
result = super(account_move, self).create(cr, uid, vals, c)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 2878, in create
result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/fields.py", line 445, in set
id_new = obj.create(cr, user, act[2], context=context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 983, in create
tmp = self.pool.get('account.move').validate(cr, uid, [vals], context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1190, in validate
self._centralise(cr, uid, move, 'debit', context=context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1099, in _centralise
}, context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 983, in create
tmp = self.pool.get('account.move').validate(cr, uid, [vals], context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1190, in validate
self._centralise(cr, uid, move, 'debit', context=context)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1113, in _centralise
(mode, move.id, line_id2))
File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 77, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 122, in execute
res = self._obj.execute(query, params)
ProgrammingError: function sum(unknown) is not unique
LINE 1: SELECT SUM(E'debit') FROM account_move_line WHERE move_id=18...
^
HINT: Could not choose a best candidate function. You might need to add explicit type casts.
mi potreste spiegare che errore e' e come posso correggerlo??
grazie mille
Lucia