Skip to Content
Menu
This question has been flagged
3890 Rodiniai

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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
0
vas. 19
2747
1
bal. 16
4578
2
rugs. 23
19257
0
vas. 19
3026
0
liep. 25
354