Skip to Content
Menu
This question has been flagged
3869 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
2728
1
apr 16
4570
2
sep 23
19239
0
feb 19
3015
0
júl 25
354