Odoo Help


delete sales order in "done" status

sneha antony
on 6/12/14, 3:18 AM 5,211 views

As partb of truncating my openerp database,I deleted all my delivery orders,incoming shipments and now the pending items is the sales order which is in DONE status.How can I delete a sales order in this status.When I try to delete I get an error msg like

Invalid Action!

In order to delete a confirmed sales order, you must cancel it.
To do so, you must first cancel related picking for delivery orders.

but I dont have related picking for the delivery orders and also any delivery orders pending in my database.


Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 6/12/14, 3:46 AM

Sales orders in done state cannot be deleted in the regular OpenERP way. Truncating a database is generally a bad idea. Some complications can occur because of lost connections and you will have no idea where it might crash.

It is nearly always better to just start over with a clean database. Perhaps make some backups during the testing so you can always restore to a step in the process. 


If you really still insist on truncating the database, then perhaps look up the sale_order or sale_order_line table and set all the relations to the pickings to false. 

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: 6/12/14, 3:18 AM
Seen: 5211 times
Last updated: 3/16/15, 8:10 AM