USTVA: Fall IST-Versteuerung aggregat an der richtigen Stellen

und nicht im Subselect für die Abfrage bezahlter Beleg oder nicht.

diff --git a/SL/USTVA.pm b/SL/USTVA.pm
index 22d12cecf0909adf199590342b137ff0e447d1f9..122a17a169d006f23290cbeb2020e0c160ff7613 100644 (file)
--- a/SL/USTVA.pm
+++ b/SL/USTVA.pm
@@ -691,7 +691,7 @@ sub get_accounts_ustva {
          SUM( ac.amount *
             -- Bezahlt / Rechnungssumme
            (
-             SELECT SUM(acc.amount), t.rate, c.accno
+             SELECT SUM(acc.amount)
              FROM acc_trans acc
              INNER JOIN chart c ON (acc.chart_id   =   c.id
                                     AND c.link   like  '%AR_paid%')
@@ -699,13 +699,12 @@ sub get_accounts_ustva {
               1=1
               $ARwhere
               AND acc.trans_id = ac.trans_id
-              )
-           /
+              )           /
            (
             SELECT amount FROM ar WHERE id = ac.trans_id
            )
          ) AS amount,
-         tk.pos_ustva
+         tk.pos_ustva,  t.rate, c.accno
        FROM acc_trans ac
        LEFT JOIN chart c ON (c.id  = ac.chart_id)
        LEFT JOIN ar      ON (ar.id = ac.trans_id)