Fixed bom patch
diff --git a/erpnext/patches/v4_2/recalculate_bom_costs.py b/erpnext/patches/v4_2/recalculate_bom_costs.py
index 25fd7f3..c05fd03 100644
--- a/erpnext/patches/v4_2/recalculate_bom_costs.py
+++ b/erpnext/patches/v4_2/recalculate_bom_costs.py
@@ -5,8 +5,8 @@
import frappe
def execute():
- for d in frappe.db.sql("""select bom.name from `tabBOM` bom where bom.docstatus < 2 and
- exists(select bom_item.name from `tabBOM Operation` bom_op where
+ for d in frappe.db.sql("""select bom.name from `tabBOM` bom where bom.docstatus < 2 and
+ exists(select bom_op.name from `tabBOM Operation` bom_op where
bom.name = bom_op.parent and bom_op.fixed_cycle_cost IS NOT NULL)""", as_dict=1):
try:
bom = frappe.get_doc('BOM', d.name)
@@ -16,4 +16,3 @@
frappe.db.commit()
except:
frappe.db.rollback()
-
\ No newline at end of file