Odoo Help


How to group invoice with a filter with 'group_by':'date_invoice' ???

Pascal Tremblay
on 12/7/15, 2:41 PM 1,673 views

Hello all,

I'm in Odoo 8. Here is the XML for a filter. This filter displays invoice from the current year.

If I use :

    <field name="context">{'group_by':'period_id'}</field>

    Invoices are grouped by period (monthly) correctly.

If I use 'date_invoice' instead, invoice are ALSO grouped monthly. Same thing than 'period_id'.

<record id="filters_lapagept.ventes_annuelles_cf" model="ir.filters">

<field name="name">Ventes annuelles - CF</field>

<field name="model_id">account.invoice</field>

<field name="is_default" eval="False" />

<field name="user_id" ref="" />

            <field name="domain">[['invoice_year','=',time.strftime('%Y')]]</field>

<field name="context">{'group_by':'date_invoice'}</field>


Do you know I could group my invoice by date_invoice instead of by period (month)?




Pascal Tremblay

--Pascal Tremblay--
| 5 3 7
Alma, Canada
--Pascal Tremblay--

Pascal Tremblay
On 12/7/15, 7:26 PM

I have found my answer here : https://www.odoo.com/fr_FR/forum/help-1/question/how-to-group-by-day-25139

When I think about my question, it's true that the field 'date_invoice' contents himself a day, a month and a year...

So, these lines work well :

    <field name="context">{'group_by':'date_invoice:day'}</field>


    <field name="context">{'group_by':'date_invoice:week'}</field>

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/7/15, 2:41 PM
Seen: 1673 times
Last updated: 12/7/15, 7:45 PM