How to change Status for Locked Sales Order

Question

I have a locked Sales order. But it was wrong. Accidentally locked it. Now, it is stuck at locked status. I need it to change it to Draft and make some changes.
How can I do it?

KAMDEM FOTSO · Accepted Answer

I had use this code in onchange method of my custom module, done is the state for locked sale
sales = self .env[ 'sale.order' ]
recSale = sales.search([( 'state' ,  '=' ,  'done' )])
for x in recSale:
x.write({ 'state' : 'draft' })

Alex Theordore · Answer

If I update a query manually, will accounting and delivery will be in synced?
How do I make sure that nothing is broken? or how do I check what transactions - Account, stock move were generated prior to locking the SO?

Robert Montemayor · Answer

You can query that in postgres , its like "update sale order table set status = 'draft'  where status = 'locked'

Pujara Geet · Answer

Hey
Currently There Is No Button in sale order After You Lock It. If You want to Change Something on sale order after Lock You have to add button and stages as per your requirement.

Thanks

Dipak Shah · Answer

Hey,
there is one button named as 'Unlock' on Sales order itself .by using it you can unlock the Sales order.
So,
1) click on 'Unlock' button
2) click on Cancel button and then
3) click on 'Set to Quotation' button so you will get draft record easily.
Thanks

This question has been flagged

Enjoying the discussion? Don't just read, join in!