Pular para o conteúdo
Esta pergunta foi sinalizada
odoo16features#filter#Sales
2 Respostas
1644 Visualizações
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
Cancelar
Avatar
Mily Shajan
Melhor resposta

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
Cancelar
Anthony
Autor

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

Thanks!

Avatar
Daniel Alejandro Nieto Barreto (danb)
Melhor resposta

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
Cancelar
Publicações relacionadas Respostas Visualizações Atividade
Sales Order Follow up Resolvido
odoo16features #Sales
Avatar
Avatar
Avatar
2
set. 23
1874
Disable 'create' suggestions in the 'sales quotations' add new product or customer Resolvido
odoo16features #Sales
Avatar
Avatar
1
fev. 24
1221
How to filter records in tree view based on selected company in Odoo v16 ? Resolvido
odoo16features #filter #records #domain
Avatar
Avatar
1
dez. 23
4668
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
mai. 25
1998
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
abr. 25
3056