Revision 88286589
Von Daniel Krieger vor fast 6 Jahren hinzugefügt
| SL/BackgroundJob/SelfTest/Transactions.pm | ||
|---|---|---|
| 479 | 479 |
my $query = qq| |
| 480 | 480 |
select sum(ac.amount) as amount, ap.invnumber,ap.netamount |
| 481 | 481 |
from acc_trans ac left join ap on (ac.trans_id = ap.id) |
| 482 |
WHERE ac.chart_link like '%AP_amount%' |
|
| 482 |
WHERE ac.chart_link like '%AP_amount%' OR ac.chart_link like '%IC_cogs%'
|
|
| 483 | 483 |
AND ac.transdate >= ? AND ac.transdate <= ? |
| 484 | 484 |
group by invnumber,trans_id,netamount having sum(ac.amount) <> ap.netamount*-1|; |
| 485 | 485 |
|
Auch abrufbar als: Unified diff
SelfTests: False Positive bei Buchungen auf ic_cogs als Sammelkonto vermeiden