X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e713c3142d8c603b31d25fff371da47f56976aae..HEAD:/templates/webpages/custom_data_export_designer/edit.html

diff --git a/templates/webpages/custom_data_export_designer/edit.html b/templates/webpages/custom_data_export_designer/edit.html
index 9b8f68cfe..9008759b2 100644
--- a/templates/webpages/custom_data_export_designer/edit.html
+++ b/templates/webpages/custom_data_export_designer/edit.html
@@ -41,8 +41,7 @@
 SELECT extract(YEAR FROM oe.transdate) AS "Jahr", SUM(oe.amount) AS "Angebotssumme"
 FROM oe
 LEFT JOIN employee ON (oe.employee_id = employee.id)
-WHERE (oe.customer_id IS NOT NULL)
-  AND COALESCE(oe.quotation, FALSE)
+WHERE oe.record_type = 'sales_quotation'
   AND (employee.login = <%Benutzer-Login%>)
 GROUP BY "Jahr"
 ORDER BY "Jahr"