Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Prevent "Canceling" confirmed Sale Order if and Invoice is published.

sales invoice invoice_state sale.order server_actions

2 Odpowiedzi

4624 Widoki

Genaro Rodríguez

Hi, I'm attempting to prevent users from canceling a confirmed sale order if there is an invoice confirmed to the client. My current configuration for invoices is "Ordered quantities", not delivered like the majority.

I'm thinking of creating a automated action or something similar that triggers when the user tries to cancel the order.

The logic would be simple, if there is a confirmed invoice, you first need to cancel in order to cancel the sale order.

I don't know where to start or how to do it. Anyone has an idea or has done it before.

I would really appreciate any insights.

Cybrosys Techno Solutions Pvt.Ltd

Hi,

You can use the following code in the action.

sale = self.env["sale.order"].search([('name', '=', self.name)]) delivery = self.env["stock.picking"].search([('origin', '=', self.name)])
invoice = self.env["account.move"].search([('invoice_origin', '=', self.name)])
print(invoice.read())
delivery.state = 'draft'
sale.state = "draft"
invoice.state = "draft"
print('delivery', delivery)
print('delivery_o',sale)
for picking in delivery:
    for move in picking.move_lines:
        move.state = 'draft'
        move._do_unreserve()
        move.unlink()
        picking.unlink()

Hope it helps

Genaro Rodríguez

Autor

Hi Cybrosys, thank you for your feedback. I'm encountering the following error:

Down I attached more info on my response.

This is how the code is displayed.
Automated action
Model: Sales Order
Trigger: On creation & Update
Looking forward to hearing from you soon!

Thanks again.

Genaro Rodríguez

Autor

Hi Cybrosys, thank you for your feedback. I'm encountering the following error:

This is how the code is displayed.

Automated action

Model: Sales Order

Trigger: On creation & Update

Looking forward to hearing from you soon!

Thanks again.

Niyas Raphy (Walnut Software Solutions)

instead of self.env in the above code, just use env

also please cross and check verify, whether it is a stable solution as the above code uses the name field in the search

Genaro Rodríguez

Autor

Hi Niyas, that solved the big problem.
It appears there's a syntax error but I'm not getting why "sale =" is the problem.

SyntaxError : invalid syntax at line 1
sale = env["sale.order"].search([('name', '=', self.name)]) delivery = env["stock.picking"].search([('origin', '=', self.name)])

If I change it t "sale.order ="
Then the following syntax error appears:
Syntax errors detected :

Line 1:
sale.order = env["sale.order"].search([('name', '=', self.name)]) delivery = env["stock.picking"].search([('origin', '=', self.name)])
……………………………………………………………..^ (self.name)])
SyntaxError: invalid syntax

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Invoice Not Related to the Sale Order I Just Create From sales invoice sale.order Related	0 paź 25	1887
[8.0] Sale or Quotation order info about quantity to sell/total quantity on hand. And simple sell process Question warehouse invoice sale invoice_state sale.order	2 wrz 15	4190
Sales upload Template required sales invoice	2 gru 23	4108
Add option to select field Rozwiązane invoice_state sale.order	3 paź 22	7212
Create invoice from sales order using xml-rpc (python) invoice sale.order	1 paź 22	4880

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!