Odoo Help


How to filter Invoice reports by product variants

Randall Risser
on 3/8/16, 11:24 AM 1,214 views

I currently have Odoo V9 online cloud version.

Is there any way to filter the report by the invoices that contain a product with a certain variants.

Example: I have a T-shirt with Variants of Red, Brown, Blue.

I only want the invoices to show in the report that have the product T-shirt with the Variant of Blue

William Brugger
On 3/8/16, 3:19 PM

You have to edit the qweb view "report_saleorder_document" and add t-if statements.   I have a template where I filter bom materials based on their product category.  So at the top of each table I put this:


<t t-if="o.move_lines">

<t t-foreach="o.bom_id.bom_line_ids" t-as="line">

<t t-if="line.product_id.product_tmpl_id.categ_id.id==4">



<span t-field="line.name"/>

</td>  etc...

In your case you will want to check the variant at the top of the loop over items on your sales order.

<t t-if="line.product_id.attribute_value_ids.name == 'blue'">  or if you know the id of that variant

<t t-if="line.product_id.attribute_value_ids.id==3">

 There is a lot of help for customizing reports - just Google odoo qweb custom reports.

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

1 follower(s)


Asked: 3/8/16, 11:24 AM
Seen: 1214 times
Last updated: 5/11/16, 11:21 AM