X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCA.pm;h=cf4ccce08bd1340af29aa095f69d4bca8566505d;hb=3879426c4db6c8a2ff8afa9a98992eeaede38a49;hp=1fb05e9dafa195f84e5e0134de04ce6a648cfb04;hpb=6b8ce220b3b70e43f6a6eb46c3c611875815f4af;p=kivitendo-erp.git diff --git a/SL/CA.pm b/SL/CA.pm index 1fb05e9da..cf4ccce08 100644 --- a/SL/CA.pm +++ b/SL/CA.pm @@ -202,9 +202,7 @@ sub all_transactions { qq|SELECT SUM(ac.amount) AS amount FROM acc_trans ac JOIN chart c ON (ac.chart_id = c.id) - $dpt_join WHERE ((select date_trunc('year', ac.transdate::date)) = (select date_trunc('year', ?::date))) AND ac.ob_transaction - $dpt_where $project AND c.accno = ? $acc_cash_where|;