Revision 8eca5e84
Von Sven Schöling vor fast 12 Jahren hinzugefügt
| SL/Form.pm | ||
|---|---|---|
| 2812 | 2812 |
FROM acc_trans a |
| 2813 | 2813 |
LEFT JOIN chart c ON (c.id = a.chart_id) |
| 2814 | 2814 |
LEFT JOIN project p ON (p.id = a.project_id) |
| 2815 |
LEFT JOIN tax t ON (t.id= a.tax_id) |
|
| 2815 |
LEFT JOIN tax t ON (t.id= (SELECT tk.tax_id FROM taxkeys tk |
|
| 2816 |
WHERE (tk.taxkey_id=a.taxkey) AND |
|
| 2817 |
((CASE WHEN a.chart_id IN (SELECT chart_id FROM taxkeys WHERE taxkey_id = a.taxkey) |
|
| 2818 |
THEN tk.chart_id = a.chart_id |
|
| 2819 |
ELSE 1 = 1 |
|
| 2820 |
END) |
|
| 2821 |
OR (c.link='%tax%')) AND |
|
| 2822 |
(startdate <= a.transdate) ORDER BY startdate DESC LIMIT 1)) |
|
| 2816 | 2823 |
WHERE a.trans_id = ? |
| 2817 | 2824 |
AND a.fx_transaction = '0' |
| 2818 | 2825 |
ORDER BY a.acc_trans_id, a.transdate|; |
Auch abrufbar als: Unified diff
Revert "Probleme bei Mwst-Wechsel"
This reverts commit 072919154edb34f4afed6bf93fdbdae5b0969385.