diff --git a/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py b/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py index d233643c244417c2d48878f9d601013bc35da932..96a6822cd113be3787526ef214c6f82347e607b4 100644 --- a/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py +++ b/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py @@ -79,7 +79,7 @@ def get_bom_stock(filters): BOM_ITEM.stock_qty, BOM_ITEM.stock_uom, BOM_ITEM.stock_qty * qty_to_produce / BOM.quantity, - Sum(BIN.actual_qty).as_("actual_qty"), + BIN.actual_qty.as_("actual_qty"), Sum(Floor(BIN.actual_qty / (BOM_ITEM.stock_qty * qty_to_produce / BOM.quantity))), ) .where((BOM_ITEM.parent == filters.get("bom")) & (BOM_ITEM.parenttype == "BOM"))