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

delete sales order in "done" status

By
sneha antony
on 6/12/14, 3:18 AM 3,351 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.

0

Ludo - Neobis

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

Developer

Ludo - Neobis
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. 

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

1 follower(s)

Stats

Asked: 6/12/14, 3:18 AM
Seen: 3351 times
Last updated: 3/16/15, 8:10 AM