Odoo Help

Welcome!

This community 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.

0

How to view Customers by State or County?

By
Catherine Ansbro
on 3/23/15, 2:11 PM 488 views

How can I view Customers by State (this field exists), or by County (this field doesn't yet exist)?

I am using v8.0

Catherine Ansbro
on 3/23/15, 5:27 PM

Thank you this worked! In Technical User I had to go into User Interface. After that the instructions went exactly as described. Now when I go into Customers I can group by State, or search by State. (In my case, the "States" were new ones I defined--counties in Ireland) Thank you!

Catherine Ansbro
on 3/23/15, 6:55 PM
1

Jérémy Kersten (jke)

--Jérémy Kersten (jke)--
2993
| 3 2 5
Jodoigne, Belgium
--Jérémy Kersten (jke)--

Jérémy is a member of the core R&D team since september 2013. He developed several projects for OpenERP version 8 including the eCommerce, the Google Calendar synchronization and the new product variants/configurator. Now, he manages Odoo website and themes for saas.

Jérémy Kersten (jke)
On 3/23/15, 4:13 PM

Open all customers : Messaging / Organizer / contacts 

At top right, you can group by country 


UPDATE

You can add a new group by in search view with an inherited view !

Settings -> Technical User -> Views -> Create


Name: what you want

View type: search

Object: res.partner

Inherited view: res.partner.select

View inheritance mode: Extension view


Architecture:

 <group string="Group By" position="inside">
    <filter string="State" context="{'group_by':'state_id'}"/>
</group>



After, you can click in tree view : first group by country, secondly state, to have a tree

country 1

   State 1

       Customers...

   state 2

        Customers...

Country 2

   undefined (no state)

         Customers...


Let us know if it works for you !

1
Alby Antony
On 3/25/15, 2:10 AM

catherine if you have a field in database for state defenitly you can apply the same code in your view

0
Catherine Ansbro
On 3/23/15, 4:52 PM

[I am trying to respond to the initial suggestion below, to explain why it does not work.] When I open the Sales module my only options on the left side are Customers, Leads, Opportunities, Quotations and Sales Orders.

There is a "Messaging" module at the top--but when I click on it, I am not longer in Sales and cannot see any customers. My only options in Messaging are Inbox, Organizer and My Groups.  Under Organizer, there is only Calendar. There is nothing for contacts like you describe.

***I understand that I can group by country. But I want to group by State.***  How can I  create that option?

Which version are you using ? v7 ? V8 ? V8.Sass-6 ?

Jérémy Kersten (jke)
on 3/23/15, 5:18 PM

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 3/23/15, 2:11 PM
Seen: 488 times
Last updated: 3/25/15, 2:10 AM