Recommit von r1001 von skoehler: Behebt/umgeht Bug 323. SQL-Fehler bei Kontenabgeleic...

[kivitendo-erp.git] / SL / RC.pm

diff --git a/SL/RC.pm b/SL/RC.pm
index 63a41f434c1e8bab99e1c5047cbf1f36593cfddd..6de28ab65e01ec8be997ab6f74a90f64d4604a63 100644 (file)
--- 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}'