Odoo Help


Error opening sales invoices (verkoop facturen)

Peter Zijlstra
on 7/11/14, 10:59 AM 1,334 views

Dear all,


Please assist in the following.

I use Openerp 7.0.2 and very satisfied with it although I run into trouble this time. When i open sales invoices (from the menu finance) I get an error and a window pops up with a line of 40 I guess with all kind of errors. As Openerp does not help when there is no paid support contract there is not much I can do. I thought it was because of an failed update.. (whenever I go to configuration or settings in the head menu.. and i click on update it look like the system is going in some sort of loop I can see the small red pop up in the upper middels of my screen saying it is loading but it does say that every 5 seconds but nothing happens anymore and I can clcik on the menu left but the window right is not showing anything anymore.. it stays for hours like that so it much be a crash).. Since I did that I have problems so I guess it has something to do with this.. But who is able to help me out?

I have a screendump but cannot post due to a lack of "karma"???

Looking forward to an answer.

Regards Peter


Here are the errors appearing in the popup window when I click on the sales invoices.

Client Traceback (most recent call last): File "/var/packages/OpenERP7.x/target/openerp/addons/web/http.py", line 195, in dispatch response["result"] = method(self, **self.params) File "/var/packages/OpenERP7.x/target/openerp/addons/web/controllers/main.py", line 1005, in search_read return self.do_search_read(req, model, fields, offset, limit, domain, sort) File "/var/packages/OpenERP7.x/target/openerp/addons/web/controllers/main.py", line 1040, in do_search_read records = Model.read(ids, fields or False, req.context) File "/var/packages/OpenERP7.x/target/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/var/packages/OpenERP7.x/target/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, *args) File "/var/packages/OpenERP7.x/target/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info) Server Traceback (most recent call last): File "/var/packages/OpenERP7.x/target/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/local/lib/python2.7/site-packages/openerp/netsvc.py", line 295, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/local/lib/python2.7/site-packages/openerp/service/web_services.py", line 614, in dispatch res = fn(db, uid, *params) File "/usr/local/lib/python2.7/site-packages/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/usr/local/lib/python2.7/site-packages/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, *args, **kwargs) File "/usr/local/lib/python2.7/site-packages/openerp/osv/osv.py", line 198, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/usr/local/lib/python2.7/site-packages/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/usr/local/lib/python2.7/site-packages/openerp/osv/orm.py", line 3604, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/local/lib/python2.7/site-packages/openerp/osv/orm.py", line 3724, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/usr/local/lib/python2.7/site-packages/openerp/osv/fields.py", line 1131, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/usr/local/lib/python2.7/site-packages/openerp/osv/fields.py", line 1197, in _fnct_read value = value[field] or False File "/usr/local/lib/python2.7/site-packages/openerp/osv/orm.py", line 383, in __getitem__ raise KeyError(error_msg) KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 80)'"


Please assist.





Ludo - Neobis

--Ludo - Neobis--
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--


Ludo - Neobis
On 7/14/14, 8:27 AM

The error tells us the report is trying to find the field named "commercial_partner_id" on a partner (likely customer) but it does not exist there. Looking through the Odoo code, I find this comment by someone who made the base modules:

"# FIXME: after 7.0, to replace by function field partner.commercial_partner_id"

The field itself should be named "Commerical Entity" on the partner form. First I would suggest filling in that field and retrying to print the report. If that fails, you could try to update the modules. Perhaps the field has been accidently deleted (or perhaps a custom module did that?) and by updating it should at least return to database.

The reason for the grey-screen that keeps loading is that the webclient will be waiting forever for a reply from the server but will not get anything. 

Peter Zijlstra
On 7/14/14, 8:02 AM


Problem also persist in sales invoices. I would highly appreciate some support.


About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/11/14, 10:59 AM
Seen: 1334 times
Last updated: 3/16/15, 8:10 AM