Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Error when try to convert order in invoice

By
dark
on 4/15/15, 10:55 AM 568 views

I have a problem when i try to convert order in invoice just after choice that i want to invoice (all/percent/ect ...) in a custom field "mode_reglement" 


I have no problem in my development environment but in production : 
The trace : 

Odoo Server Error

Traceback (most recent call last):

File "/var/www/odoo/openerp/http.py", line 530, in handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/var/www/odoo/openerp/http.py", line 567, in dispatch

result = self._call_function(**self.params)

File "/var/www/odoo/openerp/http.py", line 303, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/var/www/odoo/openerp/service/model.py", line 113, in wrapper

return f(dbname, *args, **kwargs)

File "/var/www/odoo/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/var/www/odoo/openerp/http.py", line 796, in call

return self.method(*args, **kw)

File "/var/www/odoo/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/var/www/odoo/openerp/addons/web/controllers/main.py", line 953, in call_button

action = self._call_kw(model, method, args, {})

File "/var/www/odoo/openerp/addons/web/controllers/main.py", line 941, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/addons/sale/wizard/sale_make_invoice_advance.py", line 175, in create_invoices

res = sale_obj.manual_invoice(cr, uid, sale_ids, context)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/addons/sale/sale.py", line 455, in manual_invoice

self.signal_workflow(cr, uid, ids, 'manual_invoice')

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/models.py", line 3527, in signal_workflow

result[res_id] = workflow.trg_validate(uid, self._name, res_id, signal, cr)

File "/var/www/odoo/openerp/workflow/_init__.py", line 85, in trg_validate

return WorkflowService.new(cr, uid, res_type, res_id).validate(signal)

File "/var/www/odoo/openerp/workflow/service.py", line 91, in validate

res2 = wi.validate(signal)

File "/var/www/odoo/openerp/workflow/instance.py", line 75, in validate

wi.process(signal=signal, force_running=force_running, stack=stack)

File "/var/www/odoo/openerp/workflow/workitem.py", line 120, in process

ok = self._split_test(activity['split_mode'], signal, stack)

File "/var/www/odoo/openerp/workflow/workitem.py", line 248, in _split_test

self._join_test(t0, t1, stack)

File "/var/www/odoo/openerp/workflow/workitem.py", line 257, in _join_test

WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack)

File "/var/www/odoo/openerp/workflow/workitem.py", line 95, in create

workflow_item.process(stack=stack)

File "/var/www/odoo/openerp/workflow/workitem.py", line 116, in process

if not self._execute(activity, stack):

File "/var/www/odoo/openerp/workflow/workitem.py", line 187, in _execute

id_new = self.wkf_expr_execute(activity)

File "/var/www/odoo/openerp/workflow/workitem.py", line 313, in wkf_expr_execute

return self.wkf_expr_eval_expr(activity['action'])

File "/var/www/odoo/openerp/workflow/workitem.py", line 291, in wkf_expr_eval_expr

result = eval(line, env, nocopy=True)

File "/var/www/odoo/openerp/tools/safe_eval.py", line 314, in safe_eval

return eval(c, globals_dict, locals_dict)

File "", line 1, in <module>

File "/var/www/odoo/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/api.py", line 546, in new_api

result = method(self._model, cr, uid, self.ids, *args, **kwargs)

File "/var/www/odoo/openerp/addons/sale_stock/sale_stock.py", line 143, in action_invoice_create

res = super(sale_order,self).action_invoice_create(cr, uid, ids, grouped=grouped, states=states, date_invoice = date_invoice, context=context)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/addons/sale/sale.py", line 559, in action_invoice_create

res = self._make_invoice(cr, uid, order, il, context=context)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/addons/sale/sale.py", line 432, in _make_invoice

inv_id = inv_obj.create(cr, uid, inv, context=context)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/addons/mail/mail_thread.py", line 377, in create

thread_id = super(mail_thread, self).create(cr, uid, values, context=context)

File "/var/www/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/api.py", line 336, in old_api

result = method(recs, *args, **kwargs)

File "/var/www/odoo/openerp/models.py", line 4043, in create

record = self.browse(self._create(old_vals))

File "/var/www/odoo/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/var/www/odoo/openerp/api.py", line 462, in new_api

result = method(self._model, cr, uid, *args, **kwargs)

File "/var/www/odoo/openerp/models.py", line 4181, in _create

tuple([u2 for u in updates if len(u) > 2])

File "/var/www/odoo/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/var/www/odoo/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ValueError: "ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne \xab mode_reglement \xbb

" while evaluating

u'action_invoice_create()'


A similar problem appear when i want to do a credit side in a manual invoice (while mode_reglement field are not empty and not null):  

The operation cannot be completed, probably due to the following:

- deletion: you may be trying to delete a record while other records still reference it

- creation/update: a mandatory field is not correctly set

[object with reference: mode_reglement - mode.reglement]


My code : 

class mode_reglement(osv.osv):

_name = 'cap.mode_reglement'

_columns = {

'name' : fields.char('Nom',required=True),

}

class account_invoice(osv.osv):

_inherit = 'account.invoice'

_columns = {

'mode_reglement':fields.many2one('cap.mode_reglement','Mode de reglement',auto_join=True,required=True),

}

Did you add the 'required=True' condition to the fields at a later stage? This normally occurs because some records have been saved with an empty 'name' or 'mode_reglement' field. Then when you try to impose a constraint on it, it throws this error. So filling up the empty columns before adding the constraint will work. Hope this helps.

Shawn Varghese
on 4/16/15, 1:07 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 4/15/15, 10:55 AM
Seen: 568 times
Last updated: 4/16/15, 1:07 AM