Skip to Content
Menu
This question has been flagged
3975 Zobrazenia

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

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
feb 19
2824
1
apr 16
4684
2
sep 23
19526
0
feb 19
3087
1
aug 25
145