| commit | f9a9754dab1caf9c415807d8d5d338de3bf4575e | [log] [tgz] |
|---|---|---|
| author | sbkolate <kolate.sambhaji@gmail.com> | Wed Feb 24 19:25:35 2016 +0530 |
| committer | sbkolate <kolate.sambhaji@gmail.com> | Wed Feb 24 19:25:35 2016 +0530 |
| tree | 46c6344a997d9cb0c1eadc535ce8dac9934a7dbd | |
| parent | 980f68a5faeb0185e2b89154a0f74647c24cb251 [diff] |
opportunities status fix in Sales Funnel report reference https://discuss.erpnext.com/t/sales-funnel-not-showing-updated-opportunities/10702/4
diff --git a/erpnext/selling/page/sales_funnel/sales_funnel.py b/erpnext/selling/page/sales_funnel/sales_funnel.py index eb3b996..4d12efd 100644 --- a/erpnext/selling/page/sales_funnel/sales_funnel.py +++ b/erpnext/selling/page/sales_funnel/sales_funnel.py
@@ -17,7 +17,7 @@ and status != "Passive" """, (from_date, to_date))[0][0] opportunities = frappe.db.sql("""select count(*) from `tabOpportunity` - where docstatus = 1 and (date(`creation`) between %s and %s) + where (date(`creation`) between %s and %s) and status != "Lost" """, (from_date, to_date))[0][0] quotations = frappe.db.sql("""select count(*) from `tabQuotation`