Odoo Help


group sales by partner category

Drew Dixon
on 5/10/13, 10:16 PM 2,222 views

Using version 6.1.1 and I have assigned partners into various categories based on location and now I want to try and see the sales based on these categories. When I am in the sales order list view there does not seem to be any option to group via partner categories. I have tried to add a new group by filter, but the partner category does not seem to be available.

Is there a way to do this?

I have the same need for version 7, I'm looking for a solution ... and if I find, I share it.

Michel Hugues
on 10/10/13, 5:45 AM

odoo.ma by IBS Group

--odoo.ma by IBS Group--
| 4 5 8
Tétouan, Morocco
--odoo.ma by IBS Group--

For more informations about IBS, please visit our website at www.ibs-na.com.

For a specific questions, collaboration or help, please send us an email to support@ibs-na.com

odoo.ma by IBS Group
On 10/10/13, 1:55 PM

You can't group by a many2many field. Some similar question:


My advise to you is to add a new one_category_id many2one field linked to the res.partner.category model and put it in your partner view.

Then add a new filter to your search view :

<filter string="Category" context="{'group_by': 'one_category_id'}"/>

The difference is that in this case you can only specify one category per partner.

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

0 follower(s)


Asked: 5/10/13, 10:16 PM
Seen: 2222 times
Last updated: 3/16/15, 8:10 AM