Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
from odoo import models, fields, api, tools, _
from datetime import datetime, timedelta
class SaleOrder(models.Model):
_inherit = 'sale.order'
def autocancel_draft_sent_orders(self):
limit_date = datetime.now()
draft_sales = self.env['sale.order'].search( [('state', 'in', ['draft', 'sent']),
('validity_date' , ' =', limit_date)])
for sale in draft_sales:
sale.state = 'cancel'
Hello @hendmazied
Hope you are doing well
For you to auto cancel the order when expiration date is finished you need to write the following method.
Please find code in comment.
Feel free to contact me if needed
Hope this will help you.
Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari
Please find code here :-
def autocancel_draft_sent_orders()
for order in self.filtered(lambda rec: rec.state not in ["sale", "done", "cancel"] and rec.validity_date < datetime.now())
order.action_cancel()
And create a scheduled action to execute the method.
<record id="model_sale_order_action_cancel" model="ir.cron">
<field name="name">Cancel order</field>
<field name="active" eval="True"/>
<field name="interval_number">1</field>
<field name="interval_type">days</field>
<field name="numbercall">-1</field>
<field name="model_id" ref="sale.model_sale_order"/>
<field name="state">code</field>
<field name="code">model.autocancel_draft_sent_orders()</field>
</record>
Hi,
Please try as this:
def autocancel_draft_sent_orders(self):
limit_date = datetime.now()
draft_sales = self.env['sale.order'].search( [('state', 'in', ['draft', 'sent']),
('validity_date' , ' =', limit_date)])
draft_sales.action_cancel():
Thanks
Hi,
Instead of changing the state, you can call the function action_cancel to cancel the sale orders.
Change the code to:
for sale in draft_sales:
sale.action_cancel
Hope it helps
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Please try to use write method instead of give value directly.
def autocancel_draft_sent_orders(self):
limit_date = datetime.now()
draft_sales = self.env['sale.order'].search( [('state', '=', ['draft', 'sent']),
('validity_date' , '<=', limit_date)])
for sale in draft_sales:
sale.action_cancel
use code but not working