X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAR.pm;h=01a2ee6f5de20f1c991602bed25e1e9bcc84c3c8;hb=4e0ff82714c4c494262ff750619159b6139a5b99;hp=a3284ed9265f1541d84fa29733a98324068f4804;hpb=9263b0fac80043206bb1e32c47e2abbc3395d206;p=kivitendo-erp.git

diff --git a/SL/AR.pm b/SL/AR.pm
index a3284ed92..01a2ee6f5 100644
--- a/SL/AR.pm
+++ b/SL/AR.pm
@@ -472,8 +472,12 @@ sub ar_transactions {
     $where .=
       qq|AND ((a.globalproject_id = ?) OR EXISTS | .
       qq|  (SELECT * FROM invoice i | .
-      qq|   WHERE i.project_id = ? AND i.trans_id = a.id))|;
-    push(@values, $form->{"project_id"}, $form->{"project_id"});
+      qq|   WHERE i.project_id = ? AND i.trans_id = a.id) | .
+      qq| OR EXISTS | .
+      qq|  (SELECT * FROM acc_trans at | .
+      qq|   WHERE at.project_id = ? AND at.trans_id = a.id)| .
+      qq|  )|;
+    push(@values, $form->{project_id}, $form->{project_id}, $form->{project_id});
   }
 
   if ($form->{transdatefrom}) {