Revision 26ee3490
Von Jan Büren vor mehr als 8 Jahren hinzugefügt
| SL/BackgroundJob/SelfTest/Transactions.pm | ||
|---|---|---|
|
my $query = qq|(SELECT invnumber,datepaid from ar where datepaid is NOT NULL AND paid = 0
|
||
|
AND id not IN (select trans_id from acc_trans WHERE chart_link like '%paid%' AND acc_trans.trans_id = ar.id)
|
||
|
AND datepaid >= ? AND datepaid <= ?)
|
||
|
UNION
|
||
|
(SELECT invnumber,datepaid from ap where datepaid is NOT NULL AND paid = 0
|
||
|
UNION
|
||
|
(SELECT invnumber,datepaid from ap where datepaid is NOT NULL AND paid = 0
|
||
|
AND id not IN (select trans_id from acc_trans WHERE chart_link like '%paid%' AND acc_trans.trans_id = ap.id)
|
||
|
AND datepaid >= ? AND datepaid <= ?)|;
|
||
|
|
||
| ... | ... | |
|
Bezahl-Datum: $datepaid_should_be_null_nok->{datepaid}");
|
||
|
}
|
||
|
} else {
|
||
|
$self->tester->ok(1, "Hauptbuch Bezahl-Wert und Kreditoren-Nebenbuch-Bezahlwert stimmen überein.");
|
||
|
$self->tester->ok(1, "Kein Bezahl-Datum ohne Bezahl-Wert und ohne wirkliche Zahlungen gefunden (arap.datepaid, arap.paid konsistent).");
|
||
|
}
|
||
|
}
|
||
|
|
||
Auch abrufbar als: Unified diff
Kosmetik, bessere Beschreibung für neuen SelfTests (#24)
Copy und Paste-Fehler bei Beschreibung im Positiv-Testfall
übersehen, sowie Einrückungen verbessert.