Revision 54bccdcf
Von Jan Büren vor fast 2 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 61 | 61 |
|
| 62 | 62 |
LEFT JOIN payment_terms pt ON (${arap}.payment_id = pt.id)
|
| 63 | 63 |
|
| 64 |
WHERE ${arap}.amount > (COALESCE(open_transfers.amount, 0) + ${arap}.paid)
|
|
| 64 |
WHERE (${arap}.amount - (COALESCE(open_transfers.amount, 0) + ${arap}.paid)) >= 0.01
|
|
| 65 | 65 |
|
| 66 | 66 |
ORDER BY lower(vc.name) ASC, lower(${arap}.invnumber) ASC
|
| 67 | 67 |
|; |
Auch abrufbar als: Unified diff
SEPA-Lastschrift, Rundungsfehler bei offenen Rechnungen berücksichtigen