I am using Odoo V12 and writing a custom report, exporting an inventory valuation at a given date. I noticed that the values that are returned at Inventory Valuation are incorrect, but the quantities in stock returned at Inventory Report are correct. So I tried writing my own module querying the values and I am using this code to get the products:

products = self.env['product.product'].\
            search([('type', '=', 'product'), ('qty_available', '!=', 0)]).\
            with_context(dict(to_date=self.date, company_owned=True,
                              create=False, edit=False))

1. What is the difference between Inventory Valuation and Inventory Report? I thought only the view is different but not the query.

2. Does anyone knows why this does not return the right values?

Thank You.