Skip to Content
This question has been flagged
databasecanceldeletedeliveryordersalesorder
1 Odpoveď
12372 Zobrazenia
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
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
How to cancel and delete delivery orders?
cancel delete deliveryorder
Avatar
Avatar
Avatar
2
máj 24
16845
Delivery Order does not mirror Sales Order
deliveryorder salesorder
Avatar
0
nov 18
3566
how do you delete a database?
database delete
Avatar
Avatar
1
mar 15
13901
Canceling delivery order (2beinvoiced) result in more problem when duplicate it
cancel deliveryorder
Avatar
0
mar 15
4352
Customer with different delivey addresses Solved
deliveryorder salesorder customerinformation
Avatar
Avatar
2
júl 24
1710