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
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-foreach="o.bom_id.bom_line_ids" t-as="line">
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
There is a lot of help for customizing reports - just Google odoo qweb custom reports.
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
|Asked: 3/8/16, 11:24 AM|
|Seen: 428 times|
|Last updated: 5/11/16, 11:21 AM|