Einkaufs- und Verkaufsrechnungen: Filtermöglichkeiten nach Projektnummer sowie Anzeig...

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

diff --git a/SL/RC.pm b/SL/RC.pm
index f9e7891..6de28ab 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}'
@@ -117,11 +117,11 @@ sub payment_transactions {
   $query .= " AND ac.transdate <= '$form->{todate}'"   if $form->{todate};
 
   $query .= qq|
-  
+
       UNION
               SELECT v.name, ac.source, ac.transdate, ac.cleared,
              ac.fx_transaction, ac.amount, a.id,
-             $oid{$myconfig->{dbdriver}} AS oid 
+             $oid{$myconfig->{dbdriver}} AS oid
              FROM vendor v, acc_trans ac, ap a, chart ch
              WHERE v.id = a.vendor_id
 --           AND NOT ac.fx_transaction
@@ -135,11 +135,11 @@ sub payment_transactions {
   $query .= " AND ac.transdate <= '$form->{todate}'"   if $form->{todate};
 
   $query .= qq|
-  
+
       UNION
              SELECT g.description, ac.source, ac.transdate, ac.cleared,
              ac.fx_transaction, ac.amount, g.id,
-             $oid{$myconfig->{dbdriver}} AS oid 
+             $oid{$myconfig->{dbdriver}} AS oid
              FROM gl g, acc_trans ac, chart ch
              WHERE g.id = ac.trans_id
 --           AND NOT ac.fx_transaction
@@ -201,4 +201,3 @@ sub reconcile {
 }
 
 1;
-