Skip to Content
This question has been flagged
databasecanceldeletedeliveryordersalesorder
1 Reply
12316 Views
Avatar
sneha antony

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.

Avatar
Discard
Avatar
Ludo - 21South
Best Answer

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. 

Avatar
Discard
Related Posts Replies Views Activity
How to cancel and delete delivery orders?
cancel delete deliveryorder
Avatar
Avatar
Avatar
2
May 24
16773
Delivery Order does not mirror Sales Order
deliveryorder salesorder
Avatar
0
Nov 18
3524
how do you delete a database?
database delete
Avatar
Avatar
1
Mar 15
13784
Canceling delivery order (2beinvoiced) result in more problem when duplicate it
cancel deliveryorder
Avatar
0
Mar 15
4281
Customer with different delivey addresses Solved
deliveryorder salesorder customerinformation
Avatar
Avatar
2
Jul 24
1657