In the built-in sales order report, if a product has "vendor product code" set, it will show that number in front of the product's name. If it is not set, it will show the "internal reference".

We have created a new report and would like to show the internal reference/vendor product code in a column of its own.

I am unable to figure out how to reference a specific vendor for a specific product and obtain the "vendor product code".

In pseudo-code (not qweb but you get the idea):

if(sales_order_line.vendor_product_code.is_set())

    print( sales_order_line.vendor_product_code)

else

    print( sales_order_line.product.internal_id)