# 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():
	frappe.db.sql("""
		update `tabProject` p
		set total_sales_cost = (select sum(base_grand_total) 
			from `tabSales Order` where project=p.name and docstatus=1)
	""")
@@ -19,17 +19,14 @@
 13, 
-Web Notes
+Frapp%C3%A9
  Tec
@@ -259,16 +259,23 @@
 _cost = 
+ifnull(
 (select 
@@ -295,17 +295,16 @@
 d_total)
- 
 %0A%09%09%09from
@@ -362,10 +362,15 @@
 s=1)
+, 0)
 %0A%09%22%22%22)
+%0A

Update update_sales_cost_in_project.py (#11595)