Help with query report

ERPNext Reports
1

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

2

Try cut.warehouse instead of cut.actual_qty in where clause.

3 Likes
3

@suyash . Awesome … Thanks it worked like a charm .

Thanks again for the help