commit 723c64ba738b027323487500f09dfd7cafe3468d
author s-aga-r <sagarsharma.s312@gmail.com> Sat Dec 10 14:00:29 2022 +0530
committer s-aga-r <sagarsharma.s312@gmail.com> Tue Dec 13 14:00:30 2022 +0530
tree 2653c022cc1c823ecadb4bfc78a7ff5780ab0835
parent 5c0f8ee44fcd98fb91c03e227d171fbf8d438a57

fix: `Enough Parts to Build` in `BOM Stock Report`

erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py

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 1e1b435..cdf1541 100644
--- a/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py
+++ b/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.py
@@ -4,7 +4,7 @@
 
 import frappe
 from frappe import _
-from frappe.query_builder.functions import Floor, Sum
+from frappe.query_builder.functions import Sum
 from pypika.terms import ExistsCriterion
 
 
@@ -58,9 +58,9 @@
 			bom_item.description,
 			bom_item.stock_qty,
 			bom_item.stock_uom,
-			bom_item.stock_qty * qty_to_produce / bom.quantity,
-			Sum(bin.actual_qty).as_("actual_qty"),
-			Sum(Floor(bin.actual_qty / (bom_item.stock_qty * qty_to_produce / bom.quantity))),
+			(bom_item.stock_qty / bom.quantity) * qty_to_produce,
+			Sum(bin.actual_qty),
+			Sum(bin.actual_qty) / (bom_item.stock_qty / bom.quantity),
 		)
 		.where((bom_item.parent == filters.get("bom")) & (bom_item.parenttype == "BOM"))
 		.groupby(bom_item.item_code)