Index: trunk/SQL/Views/FakturyZaplacone.txt
===================================================================
--- trunk/SQL/Views/FakturyZaplacone.txt (revision 319)
+++ trunk/SQL/Views/FakturyZaplacone.txt (revision 323)
@@ -10,10 +10,10 @@
 -- jesli korekta to odejmij roznice od sumy szczegolow faktury
 CASE
-WHEN K.Roznica_Netto IS NULL THEN SUM(FD.NETTO)
-ELSE SUM(FD.NETTO) + K.Roznica_Netto
+WHEN K.Roznica_Netto IS NULL THEN ROUND(SUM(FD.NETTO), 2)
+ELSE ROUND(SUM(FD.NETTO) + K.Roznica_Netto, 2)
 END AS FakturaNetto, 
 CASE 
-WHEN K.Roznica_Netto IS NULL THEN SUM((FD.S_VAT + 1) * FD.NETTO)
-ELSE SUM((FD.S_VAT + 1) * FD.NETTO) + K.Roznica_Brutto
+WHEN K.Roznica_Netto IS NULL THEN ROUND(SUM((FD.S_VAT + 1) * FD.NETTO), 2)
+ELSE ROUND(SUM((FD.S_VAT + 1) * FD.NETTO) + K.Roznica_Brutto, 2)
 END AS FakturaBrutto, 
 FakturaWaluta = 
@@ -39,5 +39,5 @@
 --AND (MONTH(W.dataWplaty) = @ms) 
 --ignoruj faktury wystawione dla Poznania i Katowic
-AND F.Numer_Roz <> 'POZ' AND F.Numer_Roz <> 'KAT'
+--AND F.Numer_Roz <> 'POZ' AND F.Numer_Roz <> 'KAT'
 GROUP BY F.id_faktury, F.numer_rok, F.suma_zaplat, F.waluta_miano, F.waluta_brutto, 
 A.id_Agencji, A.Symbol, T.Symb, W.brutto, W.waluta_brutto, K.Roznica_Netto, K.Roznica_Brutto,