Index: trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt
===================================================================
--- trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (revision 474)
+++ trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (revision 597)
@@ -29,20 +29,38 @@
 				CASE 
 					WHEN dbo.Wplaty.waluta_miano='PLN' THEN 
-						 CASE
-							WHEN ROUND((ROUND(SUM(FAKTURA_DETAILS.NETTO) * (1 + FAKTURA_DETAILS.S_VAT), 2)-Wplaty.brutto),0)<=1 THEN 1
-							ELSE 0
-						 END
+						CASE 
+						WHEN K.ID_FAKTURY IS NOT NULL THEN
+							CASE 
+								WHEN ROUND(K.brutto-Wplaty.brutto,0)<=1 THEN 1
+								ELSE 0
+							END
+						
+						ELSE
+							 CASE
+								WHEN ROUND((ROUND(SUM(FAKTURA_DETAILS.NETTO) * (1 + FAKTURA_DETAILS.S_VAT), 2)-Wplaty.brutto),0)<=1 THEN 1
+								ELSE 0
+							 END
+						END
 					ELSE 
+CASE 
+						WHEN K.ID_FAKTURY IS NOT NULL THEN
+							CASE 
+								WHEN ROUND(K.waluta_brutto-Wplaty.waluta_brutto,0)<=1 THEN 1
+								ELSE 0
+							END
+						
+						ELSE
 						CASE 
 							WHEN ROUND(FAKTURY.waluta_brutto-dbo.Wplaty.waluta_brutto, 0)<=1 THEN 1
 							ELSE 0
 						END
+END
 			END
-
 			ELSE REKLAMA.ZAP£ACONO
 END,
 REKLAMA.ZAP£ACONO,
 reklama.[DATA ZAP£ATY],
-FAKTURY.zaplata_data,reklama.[reklamaId], 
+FAKTURY.zaplata_data,
+reklama.[reklamaId], 
 KLIENCI.firstname, 
 FAKTURY.TERMIN_ZAPLATY,
@@ -55,5 +73,6 @@
 FAKTURY.Korekta,
 Wplaty.idZamowienia,
-IsKorekta = CASE WHEN K.ID_FAKTURY IS NOT NULL THEN 1 ELSE 0 END
+IsKorekta = CASE WHEN K.ID_FAKTURY IS NOT NULL THEN 1 ELSE 0 END,
+IdKorekty = K.ID_Faktury
 FROM FAKTURY 
 LEFT JOIN FAKTURA_DETAILS ON FAKTURY.ID_FAKTURY = FAKTURA_DETAILS.ID_FAKTURY 
@@ -96,5 +115,7 @@
 FAKTURY.Korekta,
 Wplaty.idZamowienia,
-K.ID_FAKTURY
+K.ID_FAKTURY,
+K.brutto,
+K.waluta_brutto
 GO