Like in this i can see my items based on warehouse, and i am getting difficulty in the Total balance Item, or is there any other alternative option that i can see my stock balance total qty without warehouse segregation.
Please create a Query Report for it.
SELECT a.item_code as "Item:Link/Item:120", SUM(b.actual_qty) as "Total Balance Qty:Float:140" FROM `tabItem` a left join `tabBin` b ON a.item_code = b.item_code GROUP BY a.item_code
I hope this helps.
Thanks… it works…
@NCP Where can i learn this?
Please check it.