From cf0a808e57c47f92c7ad05c4f45d0310d502db85 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 11 May 2021 11:37:18 +0200 Subject: [PATCH] RP:trial_balance syntax, format and dead code fix --- SL/RP.pm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/SL/RP.pm b/SL/RP.pm index 7b1b01bc6..a41c2a8f6 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -835,9 +835,9 @@ sub trial_balance { $tofrom .= " AND (ac.transdate >= $fromdate)"; $subwhere .= " AND (ac.transdate >= $fromdate)"; $sumsubwhere .= " AND (ac.transdate >= (select date_trunc('year', date $fromdate))) "; - $saldosubwhere .= " AND (ac,transdate>=(select date_trunc('year', date $fromdate))) "; - $invwhere .= " AND (a.transdate >= $fromdate)"; - $glsaldowhere .= " AND ac.transdate>=(select date_trunc('year', date $fromdate)) "; + $saldosubwhere .= " AND (ac.transdate >= (select date_trunc('year', date $fromdate))) "; + $invwhere .= " AND (a.transdate >= $fromdate)"; + $glsaldowhere .= " AND (ac.transdate >= (select date_trunc('year', date $fromdate))) "; $glwhere = " AND (ac.transdate >= $fromdate)"; $glsumwhere = " AND (ac.transdate >= (select date_trunc('year', date $fromdate))) "; } @@ -1097,7 +1097,7 @@ sub trial_balance { } - my ($debit, $credit, $saldo, $soll_saldo, $haben_saldo,$soll_kummuliert, $haben_kummuliert, $last_transaction); + my ($debit, $credit, $saldo, $soll_saldo, $haben_saldo, $soll_kumuliert, $haben_kumuliert, $last_transaction); foreach my $accno (sort keys %trb) { $ref = {}; -- 2.20.1