Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
Hi
Try this code in search view of sale order
<filter string="Current Month" name="current_month" domain="[('create_date','<',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')), ('create_date','>=',time.strftime('%%Y-%%m-01'))]"/>
Regards
Can you send a screenshot of where to put this code?
Thanks!
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"))]Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
Sales Order Follow up
Đã xử lý
|
|
2
thg 9 23
|
1871 | |
|
1
thg 2 24
|
1218 | ||
|
1
thg 12 23
|
4666 | ||
|
1
thg 5 25
|
1984 | ||
|
1
thg 4 25
|
3043 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
