X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRC.pm;h=6de28ab65e01ec8be997ab6f74a90f64d4604a63;hb=a5f55e6fe23ee776e90567d3e5ee6cdf116c3f9c;hp=63a41f434c1e8bab99e1c5047cbf1f36593cfddd;hpb=ee072e4f077213bf6f8792ca8f0a1afebbb6282f;p=kivitendo-erp.git diff --git a/SL/RC.pm b/SL/RC.pm index 63a41f434..6de28ab65 100644 --- a/SL/RC.pm +++ b/SL/RC.pm @@ -73,7 +73,7 @@ sub payment_transactions { if ($form->{fromdate}) { $query = qq|SELECT sum(a.amount), (SELECT DISTINCT c2.category FROM chart c2 - WHERE c2accno = '$form->{accno}') AS category + WHERE c2.accno = '$form->{accno}') AS category FROM acc_trans a JOIN chart c ON (c.id = a.chart_id) WHERE a.transdate < date '$form->{fromdate}'