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