Odoo Help


Possible to edit a confirmed sales order?

Shahar Or
on 4/18/13, 11:36 AM 12,018 views

I have a work flow where it necesarry to edit sales orders, but I see that editing is not available by default.

The reason that I need sales orders to be editable is because there are usually changes between what the customer ordered and what we eventually supply to him. For example, he ordered 1kg of tomatoes but supply him 1.1kg of tomatoes (because fresh produce is usually not accurate in weight). This is normal and accepted by the customers but in OpenERP we can't edit the sales orders to update the ammounts (also, we some times can't supply certain products so they need to go off the sales order).

In short, we need the ability to edit sales orders. Is this possible? What complications might this incur? One foreseeable issue is that it would be wise to turn off the automatic triggering of delivery orders because they would have wrong amounts otherwise.

Thanks, Shahar

I'm thinking that perhaps the sales order should not change. Perhaps only the invoice should change but what about the delivery orders, then? I'm not even sure that we require delivery orders. They are internal documents, aren't they? Or are they the same thing as delivery certificate?

Shahar Or
on 4/18/13, 11:46 AM

So if editing sales orders is not recommended because it will lead to inconsistencies, then where should I make the edit? In the invoice?

Shahar Or
on 4/18/13, 12:11 PM

II don't need to edit sales orders. What I needed was the "invoice by delivery orders". I needed to rephrase the question: help.openerp.com/question/12332/how-to-handle-a-workflow-in-which-changes-to-customer-orders-during-packaging-are-the-norm

Shahar Or
on 4/19/13, 1:08 PM

Did you consider creating a new sales order for the differences between the initial one and the actual deliveries? I know it is not highly elegant, but... The new SO would need to make reference to the first one for auditing purposes.

AD LIBITOM, michel Guénard
on 1/19/15, 11:21 AM
On 4/18/13, 11:41 AM

Yess you can edit by changing the view file but its not recommended.

How is this done, please? Why is it not recommended?

Shahar Or
on 4/18/13, 11:45 AM

which field you want to edit? Its not recommended because every module has its workflow. Once sales order is confirmed its stock move, invoices are also generated. And a single mistake will be very painful for you in future.

on 4/18/13, 11:48 AM

This is the wronh thing you can do. When you confirm an order, openerp create stock move with products and quantities relative to order lines. If you change a confirmed order, you can't know how many product you have moved, for example.

Francesco OpenCode
on 4/18/13, 12:06 PM

Bad reply ..

Daniel Diaz
on 8/31/17, 4:13 AM
Francesco OpenCode
On 4/18/13, 11:41 AM

If you want edit a confirmed sale order, you can delete stock move relative to this order, reopen it, set it as draft, modify the order and confirm it again. This is the unique solution. If the order generate an invoice you must delete the invoice too.

Thanks. This is too much work for a fixed workflow.

Shahar Or
on 4/18/13, 11:44 AM

Why do you want to modify a confirmed sales order? Because you had an agreement with the customer (the order), and one of the parties wants to change the agreement.

on 4/19/13, 9:14 AM

I guess that this is the answer, even if I won't end up doing this. I had the wrong question :)

Shahar Or
on 4/19/13, 1:08 PM

@Patrick I know this is very late to the party, but there are many reason why you would want to reopen a sales order other than something so accusatory or drastic as "one party wants to change the agreement." Ie, a situation we are now trying to solve is a new user created a sales order under the wrong shop. They used the parent company shop and now everything from SO, DO, and Invoice are incorrect. You can't edit just the invoice and have to figure out a way to retrace all the steps.

Elephante, Sean Samborski
on 7/15/14, 1:02 AM
Sean Samborski
On 7/15/14, 1:03 AM

I have just found https://www.odoo.com/apps/7.0/sale_order_reopen which I am investigating now. It sounds promising, but I have yet to test it and so don't quote me.

After installing all the dependencies (account_invoice_reopen, stock_picking_reopen, and sale_order_reopen) it turns out it cannot handle all cases including my own. I cannot edit a confirmed sales order, I cannot edit a delivered delivery order, etc.

Elephante, Sean Samborski
on 7/15/14, 2:48 AM
Akhil P Sivan
On 10/14/16, 3:14 AM

I have tested the module mentioned by Sean Samborski. It had some bugs to run on v8, but made some changes and seems working fine on v8. If any one needs help, pls contact me: akhilpsivan01@gmail.com

Karel van der Esch
On 9/10/14, 4:08 AM

I have the same requirement -I want to change a SO in concert with the customer. So very interested to know whether a workable solution is available for modifying a SO.

My way of working (service company no warehouse management) - duplicate SO and modify new quotation -  remove old SO.

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

5 follower(s)


Asked: 4/18/13, 11:36 AM
Seen: 12018 times
Last updated: 10/14/16, 3:14 AM