# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt

from __future__ import unicode_literals
import frappe

def execute():
	for d in frappe.db.sql("""select name from `tabBOM` where docstatus < 2 and total_fixed_cost IS NOT NULL""", as_dict=1):
		try:
			bom = frappe.get_doc('BOM', d.name)
			bom.ignore_validate_update_after_submit = True
			bom.calculate_cost()
			bom.save()
			frappe.db.commit()
		except:
			frappe.db.rollback()
		
# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt

from __future__ import unicode_literals
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 
		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)
			bom.ignore_validate_update_after_submit = True
			bom.calculate_cost()
			bom.save()
			frappe.db.commit()
		except:
			frappe.db.rollback()
		
patch fix