Odoo Help


group sales by partner category

Drew Dixon
on 5/10/13, 10:16 PM 1,604 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--
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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 1604 times
Last updated: 3/16/15, 8:10 AM