Odoo Help


Cant create invoice from an order Odoo 9

Julien Almarcha
on 7/29/16, 4:03 AM 680 views

When I try to create invoice from an order, an error pop up  :


L'opération n'a pas pu être complétée, probablement à la suite d'une :

- suppression : vous essayez de supprimer un enregistrement auquel d'autres enregistrements font référence

- création/modification : un champ requis n'est pas correctement rempli

[objet référencé : Product - product.product]


And this appears in log :

openerp.sql_db: bad query: INSERT INTO "sale_advance_payment_inv" ("id", "count", "product_id", "advance_payment_method", "amount", "deposit_account_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('sale_advance_payment_inv_id_seq'), 1, 11, 'delivered', '0.00', NULL, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

There's no product with id 11 in DB but there's no reference to this ID i order too... Where does it come from ?


Julien Almarcha
On 8/4/16, 6:21 AM

Yes, it was deleted. I wasn't able to find the reference to that object. I ended by recreate a fake product with that id. Dirty, but working...

Vo Tri
On 8/4/16, 6:04 AM


I think product was delete or you not access right see product or product different company.

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/29/16, 4:03 AM
Seen: 680 times
Last updated: 8/4/16, 6:21 AM