Revision 07291915
Von Niclas Zimmermann vor fast 12 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 664 | 664 |
(SELECT c1.accno |
| 665 | 665 |
FROM chart c1, tax t1 |
| 666 | 666 |
WHERE (t1.id = t.id) AND (c1.id = t.chart_id)) AS taxaccno, |
| 667 |
(SELECT tk.tax_id |
|
| 668 |
FROM taxkeys tk |
|
| 669 |
WHERE (tk.chart_id = a.chart_id) AND (tk.startdate <= a.transdate) |
|
| 670 |
ORDER BY tk.startdate desc LIMIT 1) AS tax_id |
|
| 667 |
a.tax_id AS tax_id |
|
| 671 | 668 |
FROM acc_trans a |
| 672 | 669 |
JOIN chart c ON (c.id = a.chart_id) |
| 673 | 670 |
LEFT JOIN project p ON (p.id = a.project_id) |
| 674 | 671 |
LEFT JOIN tax t ON |
| 675 |
(t.id = |
|
| 676 |
(SELECT tk.tax_id |
|
| 677 |
FROM taxkeys tk |
|
| 678 |
WHERE (tk.taxkey_id = a.taxkey) AND |
|
| 679 |
((CASE WHEN a.chart_id IN |
|
| 680 |
(SELECT chart_id FROM taxkeys WHERE taxkey_id = a.taxkey) |
|
| 681 |
THEN tk.chart_id = a.chart_id |
|
| 682 |
ELSE 1 = 1 |
|
| 683 |
END) |
|
| 684 |
OR (c.link LIKE '%tax%')) |
|
| 685 |
AND (startdate <= a.transdate) |
|
| 686 |
ORDER BY startdate DESC LIMIT 1)) |
|
| 672 |
(t.id = a.tax_id) |
|
| 687 | 673 |
WHERE (a.trans_id = ?) |
| 688 | 674 |
AND (a.fx_transaction = '0') |
| 689 | 675 |
ORDER BY a.acc_trans_id, a.transdate|; |
Auch abrufbar als: Unified diff
Probleme bei Mwst-Wechsel
Durch einen Mwst-Wechsel kam es bisher zu einigen Problemen, folgende
behebt dieser Commit:
1.Korrektes Öffnen von Dialogbuchung bei inkl Steuern
2.Korrekte Anzeige Steuersatz in
Berichte-Kontenübersicht-...-Konto auswählen
3.Korrektes Öffnen von Kreditorenbuchungen