Skip to Content
This question has been flagged
odoo16features#filter#Sales
2 Replies
2545 Views
Avatar
Anthony

Hello,

I want to add a filter to the sales app that shows the sales orders so far in the current month (updated automatically). That way I can add it to a spreadsheet to make a custom dashboard. 

However I have not been able to create a filter that filters the creation date for the current month automatically.


Can someone help?

Thanks 

Avatar
Discard
Avatar
Mily Shajan
Best Answer

Hi 

Try this code in search view of sale order 

    

<filter string="Current Month" name="current_month"
        domain="[('create_date','&lt;',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')),
        ('create_date','&gt;=',time.strftime('%%Y-%%m-01'))]"/>


Regards

Avatar
Discard
Anthony
Author

Can you send a screenshot of where to put this code?

Thanks!

Avatar
Daniel Alejandro Nieto Barreto (danb)
Best Answer

If you don't want to edit the view, (in Odoo 17+) in the filter pop-up you can input the following

(you need developer mode on)

The code is

[("date_order", ">", datetime.datetime.combine(context_today(), datetime.time(6, 0, 0)).strftime("%Y-%m-01 %H:%M:%S"))]
Avatar
Discard
Related Posts Replies Views Activity
Sales Order Follow up Solved
odoo16features #Sales
Avatar
Avatar
Avatar
2
सित॰ 23
2675
Disable 'create' suggestions in the 'sales quotations' add new product or customer Solved
odoo16features #Sales
Avatar
Avatar
1
फ़र॰ 24
1689
How to filter records in tree view based on selected company in Odoo v16 ? Solved
odoo16features #filter #records #domain
Avatar
Avatar
1
दिस॰ 23
5571
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Solved
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
5
सित॰ 25
24779
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
अग॰ 25
3777