Community mailing list archives
Re: Filter invoices by city and/or tagsby
Thanks, and regards.
Saw your reply on the mailing list archives Dave, I'm now wondering about it.The "Group by" suggestion you offered seems like a good one, but as predicted it's not readily available. The only parameters available for filtering via the "Advanced Search" option are the ones exposed through the invoice model. So my question now is: is there any addon/application that tackles this kind of problem, or would a coding solution be required to solve it? I'm not big on Python coding by any means, so if it comes to coding an addon to include that kind of fuctionality I'd probably be better off querying the SQL database directly to produce the desired output, I reckon.
On Sat, Jan 31, 2015 at 11:48 PM, Felipe Scarel <firstname.lastname@example.org> wrote:
Thanks in advance for your help!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?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.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.