Retrieving Product Quantities per warehouse using queries
Was trying to retrieve the stock quantity(quantity on hand) per warehouse using PGAdmin:
SELECT stock_inventory_line.product_qty as Quantity, stock_inventory_line.product_code as "Product Code", stock_inventory_line.product_name as "Product Name", stock_warehouse.code as "Warehouse"
inner join stock_inventory_line on stock_inventory_line.location_id = stock_warehouse.lot_stock_id
order by stock_warehouse.code;
It is getting the data which is different from the one presented by Odoo. What have I missed?