Is there any report where i can see the Stock balance without select the warehouse

[Prabhas_Chakraborty]

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.

[NCP]

Hi @Prabhas_Chakraborty,

Please create a Query Report for it.

Query:

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

Output:

I hope this helps.

Thank You!

[Prabhas_Chakraborty]

Thanks… it works…
@NCP Where can i learn this?

[NCP]

@Prabhas_Chakraborty

Where can i learn this?

Please check it.

Create scripts report error

Hi @Zeeshan_Naeem, I think You should check the documentation of the server script report and also check the video. Query Report for please check it. [Reports II - Query Report] Script Report for please check it. [Reports III - Script Report] I hope this helps. Thank You!

[Prabhas_Chakraborty]

thanks…