Skip to Content
Dette spørgsmål er blevet anmeldt
5 Besvarelser
17217 Visninger
Avatar
Alex Theordore

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?

Avatar
Kassér
Avatar
KAMDEM FOTSO
Bedste svar

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'})
Avatar
Kassér
Avatar
Alex Theordore
Forfatter Bedste svar

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?


Avatar
Kassér
Avatar
Robert Montemayor
Bedste svar

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

Avatar
Kassér
Avatar
Pujara Geet
Bedste svar

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

Avatar
Kassér
Avatar
Dipak Shah
Bedste svar

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

Avatar
Kassér