Quantity on hand sql query

Question

Does anybody knows a SQL query to have Quality on Hand?
I need this through an sql query to feed another program database so I could link the information.

Paulo · Answer

It dont work, I already try this but it gives a syntax error on %s
where
location_id NOT IN %s
and location_dest_id IN %s
and product_id IN %s
and state IN %s

Pinakin Nayi (pna) · Answer

Probably this may help you.. https://www.odoo.com/forum/help-1/question/where-to-find-product-quantity-on-hand-42626

This question has been flagged

Enjoying the discussion? Don't just read, join in!