Revision d5dee66f
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 1238 | 1238 |
"duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays,
|
| 1239 | 1239 |
(SELECT $buysell |
| 1240 | 1240 |
FROM exchangerate |
| 1241 |
WHERE (${arap}.curr = exchangerate.curr)
|
|
| 1241 |
WHERE (${arap}.currency_id = exchangerate.currency_id)
|
|
| 1242 | 1242 |
AND (exchangerate.transdate = ${arap}.transdate)) AS exchangerate
|
| 1243 | 1243 |
FROM ${arap}, ${ct}
|
| 1244 | 1244 |
WHERE ((paid != amount) OR (datepaid > (date $todate) AND datepaid is not null)) |
Auch abrufbar als: Unified diff
RP aging(): Anpassung auf curr => currency_id