Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3983 Zobrazení

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šit
Related Posts Odpovědi Zobrazení Aktivita
0
úno 19
2829
1
dub 16
4688
2
zář 23
19539
0
úno 19
3093
1
srp 25
175