Bir rapor yapmaya çalıştım fakat sonuç yanlış döndürüyor yardımcı olabilir misiniz?
Rapor sonucun da çift kayıt dönüyor ve biri doğru diğeri yanlış.
Kod şöyle;
Kod: Tümünü seç
--ALTER VIEW [dbo].[_FATURAKDV_MATRAH] AS
SELECT
CASE WHEN STHAR_HTUR IN ('J','L') THEN 'Fatura' ELSE 'BOS' END AS FATURA_TIPI,
CASE STHAR_FTIRSIP
WHEN '2' THEN ('Alış')
WHEN '1' THEN ('Satış') END AS TIPI,
CASE FT.TIPI
WHEN '1' THEN ('Kapalı Fatura')
WHEN '2' THEN ('Açık Fatura')
WHEN '3' THEN ('Muhtelif Fatura')
WHEN '4' THEN ('İade Fatura')
WHEN '5' THEN ('Zayi İade Fatura') END AS FaturaTipi,
FT.BRUTTUTAR,CS.CARI_ISIM AS CARI_UNVAN, VERGI_NUMARASI,FISNO AS FUTURA_NO,FT.GENELTOPLAM,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='1' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS MATRAH_KDV1,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='1' THEN (STHAR_GCMIK * STHAR_NF)*0.01 ELSE 0 END) AS TUTAR_KDV1,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='1' THEN 1 ELSE 1 END) AS KDV_ORAN1,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='8' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS MATRAH_KDV8,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='8' THEN (STHAR_GCMIK * STHAR_NF)*0.08 ELSE 0 END) AS TUTAR_KDV8,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='8' THEN 8 ELSE 8 END) AS KDV_ORAN2,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='18' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS MATRAH_KDV18,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='18' THEN (STHAR_GCMIK * STHAR_NF)*0.18 ELSE 0 END) AS TUTAR_KDV18,
(CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='18' THEN 18 ELSE 18 END) AS KDV_ORAN3,
CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='1' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END + CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='8' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END + CASE WHEN STHAR_GCKOD IN ('C','G') AND STHAR_HTUR IN ('J','L') AND STHAR_KDV='18' THEN STHAR_GCMIK * STHAR_NF ELSE 0 END AS TOPLAM
FROM TBLSTHAR SH
INNER JOIN TBLCASABIT CS ON (SH.STHAR_ACIKLAMA = CS.CARI_KOD)
INNER JOIN TBLFATUIRS FT ON (SH.FISNO = FT.FATIRS_NO)
WHERE STHAR_HTUR IN ('J','L') AND SH.FISNO='000000000000006' AND STHAR_ACIKLAMA='270'
GO
Fatura Satis Açik Fatura 1107.64000000 ALMALI GIDA 000000000000006 1307.02000000 1370.160000 13.701600 -Yanlış
Fatura Satis Açik Fatura 1557.00000000 ALMALI GIDA 000000000000006 1383.86000000 1370.160000 13.701600 -Doğru