Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm trying to make a filter to use in scheduled actions to give me invoices that are overdue by, let's say 14 days.
The filter to show overdue invoices is:
["&", "&", ("invoice_date_due", "<", time.strftime("%Y-%m-%d")), ("state", "=", "posted"), ("payment_state", "in", ("not_paid", "partial"))]
I guess I just need to adjust it with timedelta, just don't know how.
Help would be much appriciated.
I did this by creating a computed field on the invoice. The code for the computed field was:
for record in self:
if record.invoice_date:
record['x_studio_block_date'] = record.invoice_date + dateutil.relativedelta.relativedelta(days=14)
else:
record['x_studio_block_date'] = False
Then update the overdueinvoices=env part of your scheduled action to:
overdueinvoices=env['account.move'].search(["&", "&", "&", ("x_studio_block_date", "<", time.strftime("%Y-%m-%d")), ("state", "=", "posted"), ("payment_state", "in", ["not_paid", "partial"]), ("amount_residual", "!=", "0")])
FYI, it will only update invoices created after the new field is added if I remember correctly. I hope this helps.
Hi,
You can use datetime and timedelta to calculate the date 14 days ago, and compare invoice_date_due to that.
from datetime import datetime, timedelta
overdue_date = (datetime.today() - timedelta(days=14)).strftime("%Y-%m-%d")
domain = [
"&", "&",
("invoice_date_due", "<", overdue_date),
("state", "=", "posted"),
("payment_state", "in", ("not_paid", "partial"))
]
Hope it helps
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
What version of Odoo are you using? Are you trying to do this in python, xml, or directly in the UI?
it doesn't seem to work, I run Odoo 17 enterprise.
Maybe I'll give more info. I'm trying to make scheduled action to add a warning messeage to customers with ovedue invoices. So far I've manage to do it and it adds the warning, but I want to make it that it'll add the warning to only those who are overdue by more than 14 days.
The scheduled action is:
warnmsgstring='Customer has overdue invoices.'
blockedcontacts=env['res.partner'].search([('sale_warn_msg','=',warnmsgstring)])
for contact in blockedcontacts:
contact['sale_warn']='no-message'
contact['sale_warn_msg']=''
overdueinvoices=env['account.move'].search(["&", "&", "&", ("invoice_date_due", "<", time.strftime("%Y-%m-%d")), ("state", "=", "posted"), ("payment_state", "in", ["not_paid", "partial"]), ("amount_residual", "!=", "0")])
for invoice in overdueinvoices:
invoice.partner_id['sale_warn']='warning'
invoice.partner_id['sale_warn_msg']=warnmsgstring
It's scheduled to run everyday and first it clears the messeage and than checks for overdue and adds it again where it should.