| commit | d3fe7ec8581775b65c9ec59606cdd17cc31d26c3 | [log] [tgz] |
|---|---|---|
| author | Rushabh Mehta <rmehta@gmail.com> | Tue Jun 02 12:21:17 2015 +0530 |
| committer | Rushabh Mehta <rmehta@gmail.com> | Tue Jun 02 12:21:17 2015 +0530 |
| tree | 5f0bd2f67f3a1165310dd3c0db91eb2e4b7bcdc4 | |
| parent | c8b406d05003b3ed18169761b3217355b1075041 [diff] |
[cleanup] customer not buying since long time report
diff --git a/erpnext/selling/report/customers_not_buying_since_long_time/customers_not_buying_since_long_time.py b/erpnext/selling/report/customers_not_buying_since_long_time/customers_not_buying_since_long_time.py index 2b2c550..de4c655 100644 --- a/erpnext/selling/report/customers_not_buying_since_long_time/customers_not_buying_since_long_time.py +++ b/erpnext/selling/report/customers_not_buying_since_long_time/customers_not_buying_since_long_time.py
@@ -43,8 +43,8 @@ def get_last_so_amt(customer): res = frappe.db.sql("""select base_net_total from `tabSales Order` - where customer ='%(customer)s' and docstatus = 1 order by transaction_date desc - limit 1""" % {'customer': frappe.db.escape(customer)}) + where customer = %s and docstatus = 1 order by transaction_date desc + limit 1""", customer) return res and res[0][0] or 0