need to get query report for stock balance - batch wise. any one can assist me. erpnext v 15
try This
[
SELECT
sle.item_code AS “Item Code”,
i.item_name AS “Item Name”,
sle.warehouse AS “Warehouse”,
sle.batch_no AS “Batch No”,
SUM(sle.actual_qty) AS “Quantity”,
i.stock_uom AS “UOM”
FROM tabStock Ledger Entry sle
JOIN tabItem i ON sle.item_code = i.name
WHERE sle.docstatus = 1
GROUP BY sle.item_code, sle.warehouse, sle.batch_no
ORDER BY sle.item_code, sle.warehouse, sle.batch_no;
]
add filters as per your requirement
the values are not correct.