Community mailing list archives

community@mail.odoo.com

Re: Filter invoices by city and/or tags

by
Dave Ellison
- 02/02/2015 04:49:38
Hi,

Just off top of my head, you'd need to change the search view. Add in a
group by.. however the partner is linked by a many2one. So the city is
not actually stored in the invoice model. So how you would / can expose
the city from there, I am not 100% sure.

Thanks
Dave

On Sun, 2015-02-01 at 01:52 +0000, Felipe Scarel wrote:
> Hello all,
> 
> 
> I'm currently deploying Odoo with a client, and a doubt arose and I
> couldn't readily find how to solve this problem. This client sells on
> a variety of cities, and he asked if it'd be possible to print a
> report or sort/filter invoices categorized by customer city (or,
> alternatively, tags assigned to customers).
> 
> For example, if clients A, B and C are all from city X, he'd want to
> show all invoices for clients on city X.
> 
> 
> As far as I've researched, it's possible to filter invoices by a
> variety of parameters, but the only one pertaining to the client is
> its name. The city/address and tag parameters seem to be available for
> filtering only on the "Clients" context, which I'm assuming is due to
> the fact that they belong to the client table or something similar.
> Therefore, I'd imagine some sort of SQL JOIN would solve that problem,
> but it doesn't seem to be available through the Odoo interface.
> 
> 
> Is this sort of operation supported natively by Odoo, or perhaps by
> any addons/applications? Or, rather, should I query the SQL database
> directly to produce that sort of report?
> 
> 
> Thanks in advance for your help!
> 
> -- 
> Felipe Scarel
> Information Security and Infrastructure Consultant
> URL: www.fbscarel.com
> 
> Phone: (+55)(61)91297200
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
>