Stock report issue

[NCP]

Please try it. Use the Bin doctype for get the stock qty.

SELECT 
    a.item_code AS "Item:Link/Item:120",
    a.item_name AS "Item Name::150",
    a.item_group AS "Item Group:Link/Item Group:120",
    a.description AS "Description::150",
    b.warehouse AS "Warehouse:Link/Warehouse:120",
    b.actual_qty AS "Balance Qty:Float:140",
    w.company AS "Company:Link/Company:120"

FROM 
    `tabItem` a

LEFT JOIN `tabBin` b ON a.item_code = b.item_code
LEFT JOIN `tabWarehouse` w ON b.warehouse = w.name

WHERE
    w.company = %(company)s

Output:

(Only available in v14 or v13)

Query Report - Stock Balance

Hi @Rajkumudu_Rk, The system offers a standard feature to view the current stock balance of items through a Query Report. Kindly review this functionality and proceed to generate a new report. Simply replicate the existing query and customize it to suit your specific requirements. [image] [image] I hope this helps. Thank You!