Hi everybody,

can you explain me why this SQL request don't take of stock internal transfert?

"select sq.id from stock_quant sq inner join product_product pp on(pp.id=sq.product_id) "
                       " inner join product_template pt on(pt.id=pp.product_tmpl_id and pt.categ_id in %s) "
                       "where sq.location_id in %s and sq.qty > 0 and sq.in_date <=%s", (tuple(docs.product_categ.ids),
                                                                     tuple(docs.location_id.ids), docs.from_date))

Thanks