X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/ff159a4d47b9a2d10744dcfc23da2c63605c8a32..eeb5375ee7727c956cc357cc8f90b19d1bfe80b9:/SL/DB/VC.pm diff --git a/SL/DB/VC.pm b/SL/DB/VC.pm index 3cc7490d9..66eb0add6 100644 --- a/SL/DB/VC.pm +++ b/SL/DB/VC.pm @@ -32,7 +32,7 @@ SQL AND e.transdate = o.transdate) FROM oe o WHERE (o.${type}_id = ?) - AND NOT COALESCE(o.quotation, FALSE) + AND ((o.record_type = 'sales_order') OR (o.record_type = 'purchase_order')) AND NOT COALESCE(o.closed, FALSE) SQL