Revision 24bcc880
Von Jan Büren vor fast 6 Jahren hinzugefügt
| SL/BackgroundJob/SelfTest/Transactions.pm | ||
|---|---|---|
| 480 | 480 |
my $query = qq| |
| 481 | 481 |
select sum(ac.amount) as amount, ap.invnumber,ap.netamount |
| 482 | 482 |
from acc_trans ac left join ap on (ac.trans_id = ap.id) |
| 483 |
WHERE ac.chart_link like '%AP_amount%' OR ac.chart_link like '%IC_cogs%'
|
|
| 483 |
WHERE (ac.chart_link like '%AP_amount%' OR ac.chart_link like '%IC_cogs%')
|
|
| 484 | 484 |
AND ac.transdate >= ? AND ac.transdate <= ? |
| 485 | 485 |
group by invnumber,trans_id,netamount having sum(ac.amount) <> ap.netamount*-1|; |
| 486 | 486 |
|
Auch abrufbar als: Unified diff
SelfTests: check_ap_paid berücksichtigt Auswahl von fromdate und todate