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 on invoice creation

By
Nic Prioleau
on 6/14/13, 7:29 AM 886 views

When creating an invoice, I get the following error:

OpenERP Server Error Client Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\http.py", line 203, in dispatch File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\controllers\main.py", line 1133, in call_button File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\controllers\main.py", line 1121, in _call_kw File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\session.py", line 43, in proxy File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\session.py", line 31, in proxy_method File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\session.py", line 104, in send

Server Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\web\session.py", line 90, in send File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\netsvc.py", line 293, in dispatch_rpc File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\osv.py", line 188, in execute_kw File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\osv.py", line 131, in wrapper File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\osv.py", line 197, in execute File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\osv.py", line 185, in execute_cr File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\sale\wizard\sale_make_invoice_advance.py", line 170, in create_invoices File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\sale\sale.py", line 435, in manual_invoice File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\wkf_service.py", line 119, in trg_validate File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\instance.py", line 43, in validate File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 60, in process File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 175, in _split_test File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 183, in _join_test File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 40, in create File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 52, in process File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\workitem.py", line 127, in _execute File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\wkf_expr.py", line 67, in execute File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\workflow\wkf_expr.py", line 57, in _eval_expr File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\tools\safe_eval.py", line 241, in safe_eval File "", line 1, in <module> File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\orm.py", line 374, in function_proxy File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\sale_stock\sale_stock.py", line 192, in action_invoice_create File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\sale\sale.py", line 536, in action_invoice_create File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\sale\sale.py", line 404, in _make_invoice File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server\openerp\addons\mail\mail_thread.py", line 242, in create File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\orm.py", line 4478, in create File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\orm.py", line 4627, in _store_set_values File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\fields.py", line 1131, in get File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\fields.py", line 1197, in _fnct_read File "C:\Program Files\OpenERP 7.0-20130415-111315\Server\server.\openerp\osv\orm.py", line 383, in __getitem__ KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 68)'"

Is anybody able to help me please?

0

Francesco OpenCode

--Francesco OpenCode--
3608
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 6/14/13, 8:21 AM
KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 68)'"

This line tell you that you are trying to get commercial_partner_id from res_partner table but this column doesn't exist.

But this must be a bug in the system?? I am simply pushing the "Create Invoice" button on a completed Sales Order and this error occurs. Which table does commercial_partner_id reside and can I give it a value somewhere?

Nic Prioleau
on 6/14/13, 11:19 AM

Is your openerp installation new? Have you developed/installed some extra module?

Francesco OpenCode
on 6/14/13, 11:25 AM

It's a completely fresh installation with no extra development or modules other than what is offered.

Nic Prioleau
on 6/14/13, 11:32 AM

Try to do an update of all the module with command line if possible.

Francesco OpenCode
on 6/14/13, 11:33 AM

Thanks. I've never done that before. Can you explain how to do it?

Nic Prioleau
on 6/14/13, 11:34 AM

Run openerp by command line and add the parameter --update=all

Francesco OpenCode
on 6/14/13, 12:25 PM

Hi - I am still struggling with this command line update. Since this is an evaluation, I am running the VMware virtual machine version of Openbravo. It comes pre-installed with everything on Ubuntu. There is a place to login into Ubuntu but I can not find anywhere that tells me which credentials I should use to login and I can therefore never perform any command line actions. Can you help me with this?

Nic Prioleau
on 6/19/13, 10:16 AM

Can anybody else suggest what I can do with this error. It is negatively influencing my decision to go with this product.

Nic Prioleau
on 6/20/13, 4:35 AM

Go in the Administration section, go in modules menu and update the invoice module manually

Francesco OpenCode
on 6/20/13, 6:31 AM

I have tried the update but I am on version 7.0.1.0 which is the latest, I have reinstalled everything, I have created new databases and started from scratch. All the times, cannot create an invoice. Same error each time. I guess that this is a bug as I can recreate it at any time.

Nic Prioleau
on 6/20/13, 6:59 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

0 follower(s)

Stats

Asked: 6/14/13, 7:29 AM
Seen: 886 times
Last updated: 3/16/15, 8:10 AM