Hi Guys ,
I am preparing a query report to find out the actual qty of a particular item available in a particular warehouse , below is my code . The result displays 0 when I run the report but the available qty in that particular warehouse is 500 .
select
it.item_code as "Part no:Data:120",
cut.actual_qty as "Cutting:Data:60"
from
`tabItem` it, `tabBin` cut
where
it.item_code = cut.item_code
and cut.actual_qty in ('Cutting - MYCOMPANY')
Could anyone please help me.
Thanks