Revision 2791faa4
Von Jan Büren vor etwa 2 Jahren hinzugefügt
| SL/BackgroundJob/SelfTest/Transactions.pm | ||
|---|---|---|
|
my $query = qq|
|
||
|
select sum(ac.amount) as paid_amount, ar.invnumber,ar.paid
|
||
|
from acc_trans ac left join ar on (ac.trans_id = ar.id)
|
||
|
WHERE ac.chart_link like '%AR_paid%' OR ac.fx_transaction
|
||
|
WHERE (ac.chart_link like '%AR_paid%' OR ac.fx_transaction)
|
||
|
AND ac.trans_id in (SELECT trans_id from acc_trans ac where ac.transdate >= ? AND ac.transdate <= ?)
|
||
|
group by invnumber, paid having sum(ac.amount) <> ar.paid*-1|;
|
||
|
|
||
Auch abrufbar als: Unified diff
SelfTest: logische Klammer vergessen
Ansonsten wird die UND Verknüpfung über den Zeitraum nicht beachtet