Microsoft SQL Server Managament Studio \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r.<\/p>\n
New Query butonuna bas\u0131l\u0131r.<\/p>\n
Ctrl+U tu\u015flar\u0131na bas\u0131l\u0131r.<\/p>\n
Kullan\u0131lan veritaban\u0131 Master veritaban\u0131 yerine se\u00e7ilir.<\/p>\n
Query i\u00e7eri\u011fi a\u015fa\u011f\u0131da bloklanarak kopyalan\u0131p yap\u0131\u015ft\u0131r\u0131l\u0131r.<\/p>\n
<\/p>\n
EXECUTE (‘exec dbo.Enable_CARI_HESAP_HAREKETLERI_Triggers’)<\/p>\n
EXECUTE (‘exec dbo.Enable_STOK_HAREKETLERI_Triggers’)<\/p>\n
EXECUTE (‘exec dbo.Enable_ALL_SIPARIS_TABLES_Triggers’)<\/p>\n
EXECUTE (‘exec dbo.Enable_KONSINYE_HAREKETLERI_Triggers’)<\/p>\n
EXECUTE (‘exec dbo.Enable_MUHASEBE_FISLERI_Triggers’)<\/p>\n
<\/p>\n
F5 tu\u015funa bas\u0131l\u0131r.<\/p>\n
<\/p>\n
EXEC dbo.msp_STOK_HAREKETLERI_OZET_Update<\/p>\n
EXEC dbo.msp_SIPARISLER_OZET_Update<\/p>\n
EXEC dbo.msp_KONSINYE_HAREKETLERI_OZET_Update<\/p>\n
EXEC dbo.msp_CARI_HESAP_HAREKETLERI_OZET_Update<\/p>\n
EXEC dbo.msp_MUHASEBE_FISLERI_OZET_Update<\/p>\n
<\/p>\n
F5 tu\u015funa bas\u0131l\u0131r.<\/p>\n
<\/p>\n
\u015eayet D\u00fczelmez ise<\/p>\n
Mikrokur i\u00e7erisinde (\u00d6zet tablolar\u0131n g\u00fcncellenmesi – 505046)<\/p>\n
akabinde a\u015fa\u011f\u0131daki trigger \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r<\/p>\n
<\/p>\n
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mye_CARI_HESAP_HAREKETLERI_Trigger]’) and OBJECTPROPERTY(id, N’IsTrigger’) = 1)
\ndrop trigger [dbo].[mye_CARI_HESAP_HAREKETLERI_Trigger]
\nGO<\/p>\n
Create TRIGGER [dbo].[mye_CARI_HESAP_HAREKETLERI_Trigger] ON [dbo].[CARI_HESAP_HAREKETLERI]
\nFOR INSERT,UPDATE,DELETE
\nAS<\/p>\n
DECLARE @insertedcount AS integer
\nDECLARE @deletedcount AS integer
\nSELECT @insertedcount = COUNT(cha_RECno) FROM inserted WITH (NOLOCK)
\nSELECT @deletedcount = COUNT(cha_RECno) FROM deleted WITH (NOLOCK)
\n\/*
\nCARI_HESAP_HAREKETLERI –> EXEC dbo.msp_CreateTriggerColumnControl 51
\nA\u015fa\u011f\u0131da trigger\u0131 etkileyecek kolon eklemesi\/\u00e7\u0131karmas\u0131 yap\u0131ld\u0131\u011f\u0131nda
\nFIRMTRIGGER.SQL i\u00e7erisindeki msp_CreateTriggerColumnControl i\u00e7erisinde de d\u00fczenleme yap\u0131lmas\u0131 ve
\n\u00fcstteki komutun tekrar \u00e7al\u0131\u015ft\u0131r\u0131l\u0131p d\u00f6nen sonucun alttaki if blo\u011fu ile de\u011fi\u015ftirilmesi gerekmektedir
\n*\/
\nDECLARE @BinaryVal as varbinary(MAX)
\nSET @BinaryVal = COLUMNS_UPDATED()
\nIF (@insertedcount=0 and @deletedcount>0) OR \/*DELETE i\u015fleminde COLUMNS_UPDATED de\u011fer d\u00f6nm\u00fcyor*\/
\n(SUBSTRING(@BinaryVal,3 ,1) & 142 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,4 ,1) & 3 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,5 ,1) & 52 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,6 ,1) & 191 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,7 ,1) & 27 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,8 ,1) & 224 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,9 ,1) & 1 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,11 ,1) & 160 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,12 ,1) & 249 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,13 ,1) & 95 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,14 ,1) & 2 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,15 ,1) & 56 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,16 ,1) & 192 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,17 ,1) & 255 <> 0 ) OR
\n(SUBSTRING(@BinaryVal,18 ,1) & 1 <> 0 )
\nBEGIN
\nIF @insertedcount>1 OR @deletedcount>1
\nBEGIN
\nDECLARE @CARIHAROZET TABLE
\n(COZ_RECno integer,
\nCOZ_firmano integer,
\nCOZ_subeno integer,<\/p>\n
COZ_Cinsi tinyint,
\nCOZ_CariKodu nvarchar(25),
\nCOZ_ProjeKodu nvarchar(25),
\nCOZ_SrmMerkezi nvarchar(25),
\nCOZ_GrupNo tinyint,
\nCOZ_MaliYil integer,
\nCOZ_Donem tinyint,
\nCOZ_HareketCins tinyint,<\/p>\n
COZ_BA_Tip tinyint,
\nCOZ_Ana float,
\nCOZ_Alt float,
\nCOZ_Orj float,
\nCOZ_Insert_fl bit)<\/p>\n
\/*normal cari i\u015flemleri*\/
\nINSERT INTO @CARIHAROZET
\nSELECT
\nISNULL(MIN(cho_RECno),0),
\ncha_firmano,cha_subeno,cha_cari_cins,cha_kod,cha_projekodu,cha_srmrkkodu,cha_grupno,DatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,
\ncha_tip,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n2,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\n1
\nFROM INSERTED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET ON (cho_firmano = cha_firmano AND cho_subeno = cha_subeno AND
\ncho_Cinsi = cha_cari_cins AND cho_CariKodu = cha_kod AND
\ncho_ProjeKodu = cha_projekodu AND cho_SrmMerkezi = cha_srmrkkodu AND cho_GrupNo = cha_grupno AND
\ncho_MaliYil = DatePart(YYYY,cha_tarihi) AND cho_Donem = DatePart(mm,cha_tarihi) AND
\ncho_HareketCins = cha_cinsi)
\nGROUP BY cha_firmano,cha_subeno,cha_cari_cins,cha_kod,cha_projekodu,cha_srmrkkodu,cha_grupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip<\/p>\n
UNION ALL<\/p>\n
SELECT
\nISNULL(MIN(cho_RECno),0),
\ncha_firmano,cha_subeno,cha_cari_cins,cha_kod,cha_projekodu,cha_srmrkkodu,cha_grupno,DatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,
\ncha_tip,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n2,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\n0
\nFROM DELETED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET ON (cho_firmano = cha_firmano AND cho_subeno = cha_subeno AND
\ncho_Cinsi = cha_cari_cins AND cho_CariKodu = cha_kod AND
\ncho_ProjeKodu = cha_projekodu AND cho_SrmMerkezi = cha_srmrkkodu AND cho_GrupNo = cha_grupno AND
\ncho_MaliYil = DatePart(YYYY,cha_tarihi) AND cho_Donem = DatePart(mm,cha_tarihi) AND
\ncho_HareketCins = cha_cinsi)
\nGROUP BY cha_firmano,cha_subeno,cha_cari_cins,cha_kod,cha_projekodu,cha_srmrkkodu,cha_grupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip<\/p>\n
INSERT INTO dbo.CARI_HESAP_HAREKETLERI_OZET
\nSELECT COZ_firmano,COZ_subeno,
\nCOZ_Cinsi,COZ_CariKodu,COZ_ProjeKodu,COZ_SrmMerkezi,COZ_GrupNo,COZ_MaliYil,COZ_Donem,COZ_HareketCins,
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Ana ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Ana ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Alt ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Alt ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Orj ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Orj ELSE 0.0 END)
\nFROM @CARIHAROZET
\nWHERE COZ_RECno=0 AND COZ_Insert_fl=1
\nGROUP BY COZ_firmano,COZ_subeno,COZ_Cinsi,COZ_CariKodu,COZ_ProjeKodu,COZ_SrmMerkezi,COZ_GrupNo,COZ_MaliYil,COZ_Donem,COZ_HareketCins
\nDELETE @CARIHAROZET WHERE COZ_RECno=0 AND COZ_Insert_fl=1<\/p>\n
IF EXISTS (SELECT TOP 1 COZ_RECno FROM @CARIHAROZET)
\nBEGIN
\nUPDATE CHHO
\nSET
\ncho_Ana_Borc = cho_Ana_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Ana,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Ana,0.0) ELSE 0.0 END,
\ncho_Alt_Borc = cho_Alt_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Alt,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Alt,0.0) ELSE 0.0 END,
\ncho_Orj_Borc = cho_Orj_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Orj,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Orj,0.0) ELSE 0.0 END
\nFROM dbo.CARI_HESAP_HAREKETLERI_OZET CHHO WITH (NOLOCK)
\nLEFT OUTER JOIN @CARIHAROZET INS ON INS.COZ_RECno=cho_RECno AND INS.COZ_Insert_fl=1
\nLEFT OUTER JOIN @CARIHAROZET DEL ON DEL.COZ_RECno=cho_RECno AND DEL.COZ_Insert_fl=0
\nWHERE INS.COZ_BA_Tip=0 OR DEL.COZ_BA_Tip=0
\nDELETE @CARIHAROZET WHERE COZ_BA_Tip=0<\/p>\n
UPDATE CHHO
\nSET
\ncho_Ana_Alacak = cho_Ana_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Ana,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Ana,0.0) ELSE 0.0 END,
\ncho_Alt_Alacak = cho_Alt_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Alt,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Alt,0.0) ELSE 0.0 END,
\ncho_Orj_Alacak = cho_Orj_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Orj,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Orj,0.0) ELSE 0.0 END
\nFROM dbo.CARI_HESAP_HAREKETLERI_OZET CHHO WITH (NOLOCK)
\nLEFT OUTER JOIN @CARIHAROZET INS ON INS.COZ_RECno=cho_RECno AND INS.COZ_Insert_fl=1
\nLEFT OUTER JOIN @CARIHAROZET DEL ON DEL.COZ_RECno=cho_RECno AND DEL.COZ_Insert_fl=0
\nWHERE INS.COZ_BA_Tip=1 OR DEL.COZ_BA_Tip=1
\nDELETE @CARIHAROZET WHERE COZ_BA_Tip=1
\nEND
\n\/*kar\u015f\u0131 cari i\u015flemleri*\/
\nDELETE @CARIHAROZET<\/p>\n
INSERT INTO @CARIHAROZET
\nSELECT
\nISNULL(MIN(cho_RECno),0),
\ncha_firmano,cha_subeno,cha_kasa_hizmet,cha_kasa_hizkod,cha_projekodu,cha_karsisrmrkkodu,cha_karsidgrupno,DatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,
\nCASE WHEN cha_tip=0 THEN 1 ELSE 0 END,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n3,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\n1
\nFROM INSERTED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET ON (cho_firmano = cha_firmano AND cho_subeno = cha_subeno AND
\ncho_Cinsi = cha_kasa_hizmet AND cho_CariKodu = cha_kasa_hizkod AND
\ncho_ProjeKodu = cha_projekodu AND cho_SrmMerkezi = cha_karsisrmrkkodu AND cho_GrupNo = cha_karsidgrupno AND
\ncho_MaliYil = DatePart(YYYY,cha_tarihi) AND cho_Donem = DatePart(mm,cha_tarihi) AND
\ncho_HareketCins = cha_cinsi)
\nWHERE cha_kasa_hizkod <> ”
\nGROUP BY cha_firmano,cha_subeno,cha_kasa_hizmet,cha_kasa_hizkod,cha_projekodu,cha_karsisrmrkkodu,cha_karsidgrupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip<\/p>\n
UNION ALL<\/p>\n
SELECT
\nISNULL(MIN(cho_RECno),0),
\ncha_firmano,cha_subeno,cha_kasa_hizmet,cha_kasa_hizkod,cha_projekodu,cha_karsisrmrkkodu,cha_karsidgrupno,DatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,
\nCASE WHEN cha_tip=0 THEN 1 ELSE 0 END,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n3,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\n0
\nFROM DELETED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET ON (cho_firmano = cha_firmano AND cho_subeno = cha_subeno AND
\ncho_Cinsi = cha_kasa_hizmet AND cho_CariKodu = cha_kasa_hizkod AND
\ncho_ProjeKodu = cha_projekodu AND cho_SrmMerkezi = cha_karsisrmrkkodu AND cho_GrupNo = cha_karsidgrupno AND
\ncho_MaliYil = DatePart(YYYY,cha_tarihi) AND cho_Donem = DatePart(mm,cha_tarihi) AND
\ncho_HareketCins = cha_cinsi)
\nWHERE cha_kasa_hizkod <> ”
\nGROUP BY cha_firmano,cha_subeno,cha_kasa_hizmet,cha_kasa_hizkod,cha_projekodu,cha_karsisrmrkkodu,cha_karsidgrupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip<\/p>\n
IF EXISTS (SELECT TOP 1 COZ_RECno FROM @CARIHAROZET)
\nBEGIN
\nINSERT INTO dbo.CARI_HESAP_HAREKETLERI_OZET
\nSELECT COZ_firmano,COZ_subeno,
\nCOZ_Cinsi,COZ_CariKodu,COZ_ProjeKodu,COZ_SrmMerkezi,COZ_GrupNo,COZ_MaliYil,COZ_Donem,COZ_HareketCins,
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Ana ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Ana ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Alt ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Alt ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=0 THEN COZ_Orj ELSE 0.0 END),
\nSUM(CASE WHEN COZ_BA_Tip=1 THEN COZ_Orj ELSE 0.0 END)
\nFROM @CARIHAROZET
\nWHERE COZ_RECno=0 AND COZ_Insert_fl=1
\nGROUP BY COZ_firmano,COZ_subeno,COZ_Cinsi,COZ_CariKodu,COZ_ProjeKodu,COZ_SrmMerkezi,COZ_GrupNo,COZ_MaliYil,COZ_Donem,COZ_HareketCins
\nDELETE @CARIHAROZET WHERE COZ_RECno=0 AND COZ_Insert_fl=1<\/p>\n
IF EXISTS (SELECT TOP 1 COZ_RECno FROM @CARIHAROZET)
\nBEGIN
\nUPDATE CHHO
\nSET
\ncho_Ana_Borc = cho_Ana_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Ana,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Ana,0.0) ELSE 0.0 END,
\ncho_Alt_Borc = cho_Alt_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Alt,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Alt,0.0) ELSE 0.0 END,
\ncho_Orj_Borc = cho_Orj_Borc + CASE WHEN INS.COZ_BA_Tip=0 THEN ISNULL(INS.COZ_Orj,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=0 THEN ISNULL(DEL.COZ_Orj,0.0) ELSE 0.0 END
\nFROM dbo.CARI_HESAP_HAREKETLERI_OZET CHHO WITH (NOLOCK)
\nLEFT OUTER JOIN @CARIHAROZET INS ON INS.COZ_RECno=cho_RECno AND INS.COZ_Insert_fl=1
\nLEFT OUTER JOIN @CARIHAROZET DEL ON DEL.COZ_RECno=cho_RECno AND DEL.COZ_Insert_fl=0
\nWHERE INS.COZ_BA_Tip=0 OR DEL.COZ_BA_Tip=0
\nDELETE @CARIHAROZET WHERE COZ_BA_Tip=0<\/p>\n
UPDATE CHHO
\nSET
\ncho_Ana_Alacak = cho_Ana_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Ana,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Ana,0.0) ELSE 0.0 END,
\ncho_Alt_Alacak = cho_Alt_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Alt,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Alt,0.0) ELSE 0.0 END,
\ncho_Orj_Alacak = cho_Orj_Alacak + CASE WHEN INS.COZ_BA_Tip=1 THEN ISNULL(INS.COZ_Orj,0.0) ELSE 0.0 END –
\nCASE WHEN DEL.COZ_BA_Tip=1 THEN ISNULL(DEL.COZ_Orj,0.0) ELSE 0.0 END
\nFROM dbo.CARI_HESAP_HAREKETLERI_OZET CHHO WITH (NOLOCK)
\nLEFT OUTER JOIN @CARIHAROZET INS ON INS.COZ_RECno=cho_RECno AND INS.COZ_Insert_fl=1
\nLEFT OUTER JOIN @CARIHAROZET DEL ON DEL.COZ_RECno=cho_RECno AND DEL.COZ_Insert_fl=0
\nWHERE INS.COZ_BA_Tip=1 OR DEL.COZ_BA_Tip=1
\nDELETE @CARIHAROZET WHERE COZ_BA_Tip=1
\nEND
\nEND
\nEND
\nELSE
\nBEGIN
\nDECLARE @NormalBorcCarpan Float
\nDECLARE @NormalAlacakCarpan Float
\nDECLARE @NormalCariCins TinyInt
\nDECLARE @NormalGrupNo TinyInt
\nDECLARE @NormalAnaTutar Float
\nDECLARE @NormalAltTutar Float
\nDECLARE @NormalOrjTutar Float
\nDECLARE @normalozetrecno AS integer<\/p>\n
DECLARE @KarsiBorcCarpan Float
\nDECLARE @KarsiAlacakCarpan Float
\nDECLARE @KarsiCariCins TinyInt
\nDECLARE @KarsiGrupNo TinyInt
\nDECLARE @KarsiAnaTutar Float
\nDECLARE @KarsiAltTutar Float
\nDECLARE @KarsiOrjTutar Float
\nDECLARE @karsiozetrecno AS integer<\/p>\n
IF @insertedcount=1
\nBEGIN
\nSELECT
\n@NormalBorcCarpan = CASE WHEN cha_tip <> 1 THEN 1.0 ELSE 0.0 END,
\n@NormalAlacakCarpan = CASE WHEN cha_tip = 1 THEN 1.0 ELSE 0.0 END,
\n@NormalCariCins = cha_cari_cins,
\n@NormalGrupNo = cha_grupno,
\n@NormalAnaTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@NormalAltTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@NormalOrjTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n2,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@normalozetrecno = ISNULL(NORMALCARI.cho_RECno,0)<\/p>\n
FROM INSERTED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET NORMALCARI ON (NORMALCARI.cho_firmano = cha_firmano AND
\nNORMALCARI.cho_subeno = cha_subeno AND
\nNORMALCARI.cho_Cinsi = cha_cari_cins AND
\nNORMALCARI.cho_CariKodu = cha_kod AND
\nNORMALCARI.cho_ProjeKodu = cha_projekodu AND
\nNORMALCARI.cho_SrmMerkezi = cha_srmrkkodu AND
\nNORMALCARI.cho_GrupNo = cha_grupno AND
\nNORMALCARI.cho_MaliYil = DatePart(YYYY,cha_tarihi) AND
\nNORMALCARI.cho_Donem = DatePart(mm,cha_tarihi) AND
\nNORMALCARI.cho_HareketCins= cha_cinsi)<\/p>\n
IF @normalozetrecno=0
\nINSERT INTO dbo.CARI_HESAP_HAREKETLERI_OZET
\nSELECT
\ncha_firmano,
\ncha_subeno,
\ncha_cari_cins,
\ncha_kod,
\ncha_projekodu,
\ncha_srmrkkodu,
\ncha_grupno,
\nDatePart(YYYY,cha_tarihi),
\nDatePart(mm,cha_tarihi),
\ncha_cinsi,
\n@NormalAnaTutar * @NormalBorcCarpan,
\n@NormalAnaTutar * @NormalAlacakCarpan,
\n@NormalAltTutar * @NormalBorcCarpan,
\n@NormalAltTutar * @NormalAlacakCarpan,
\n@NormalOrjTutar * @NormalBorcCarpan,
\n@NormalOrjTutar * @NormalAlacakCarpan
\nFROM INSERTED WITH (NOLOCK)
\nELSE
\nUPDATE dbo.CARI_HESAP_HAREKETLERI_OZET
\nSET
\ncho_Ana_Borc = cho_Ana_Borc + (@NormalAnaTutar * @NormalBorcCarpan),
\ncho_Ana_Alacak = cho_Ana_Alacak + (@NormalAnaTutar * @NormalAlacakCarpan),
\ncho_Alt_Borc = cho_Alt_Borc + (@NormalAltTutar * @NormalBorcCarpan),
\ncho_Alt_Alacak = cho_Alt_Alacak + (@NormalAltTutar * @NormalAlacakCarpan),
\ncho_Orj_Borc = cho_Orj_Borc + (@NormalOrjTutar * @NormalBorcCarpan),
\ncho_Orj_Alacak = cho_Orj_Alacak + (@NormalOrjTutar * @NormalAlacakCarpan)
\nWHERE cho_RECno = @normalozetrecno
\nSELECT
\n@KarsiBorcCarpan = CASE WHEN cha_kasa_hizkod <> ” AND cha_tip = 1 THEN 1.0 ELSE 0.0 END,
\n@KarsiAlacakCarpan = CASE WHEN cha_kasa_hizkod <> ” AND cha_tip <> 1 THEN 1.0 ELSE 0.0 END,
\n@KarsiCariCins = cha_kasa_hizmet,
\n@KarsiGrupNo = cha_karsidgrupno,
\n@KarsiAnaTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@KarsiAltTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@KarsiOrjTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n3,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@karsiozetrecno = ISNULL(KARSICARI.cho_RECno,0)<\/p>\n
FROM INSERTED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET KARSICARI ON (cha_kasa_hizkod <> ” AND
\nKARSICARI.cho_firmano = cha_firmano AND
\nKARSICARI.cho_subeno = cha_subeno AND
\nKARSICARI.cho_Cinsi = cha_kasa_hizmet AND
\nKARSICARI.cho_CariKodu = cha_kasa_hizkod AND
\nKARSICARI.cho_ProjeKodu = cha_projekodu AND
\nKARSICARI.cho_SrmMerkezi = cha_karsisrmrkkodu AND
\nKARSICARI.cho_GrupNo = cha_karsidgrupno AND
\nKARSICARI.cho_MaliYil = DatePart(YYYY,cha_tarihi) AND
\nKARSICARI.cho_Donem = DatePart(mm,cha_tarihi) AND
\nKARSICARI.cho_HareketCins = cha_cinsi)<\/p>\n
IF @KarsiBorcCarpan > 0.0 or @KarsiAlacakCarpan > 0.0
\nBEGIN
\nIF @karsiozetrecno=0
\nINSERT INTO dbo.CARI_HESAP_HAREKETLERI_OZET
\nSELECT
\ncha_firmano,
\ncha_subeno,
\ncha_kasa_hizmet,
\ncha_kasa_hizkod,
\ncha_projekodu,
\ncha_karsisrmrkkodu,
\ncha_karsidgrupno,
\nDatePart(YYYY,cha_tarihi),
\nDatePart(mm,cha_tarihi),
\ncha_cinsi,
\n@KarsiAnaTutar * @KarsiBorcCarpan,
\n@KarsiAnaTutar * @KarsiAlacakCarpan,
\n@KarsiAltTutar * @KarsiBorcCarpan,
\n@KarsiAltTutar * @KarsiAlacakCarpan,
\n@KarsiOrjTutar * @KarsiBorcCarpan,
\n@KarsiOrjTutar * @KarsiAlacakCarpan
\nFROM INSERTED WITH (NOLOCK)
\nELSE
\nUPDATE dbo.CARI_HESAP_HAREKETLERI_OZET
\nSET
\ncho_Ana_Borc = cho_Ana_Borc + (@KarsiAnaTutar * @KarsiBorcCarpan),
\ncho_Ana_Alacak = cho_Ana_Alacak + (@KarsiAnaTutar * @KarsiAlacakCarpan),
\ncho_Alt_Borc = cho_Alt_Borc + (@KarsiAltTutar * @KarsiBorcCarpan),
\ncho_Alt_Alacak = cho_Alt_Alacak + (@KarsiAltTutar * @KarsiAlacakCarpan),
\ncho_Orj_Borc = cho_Orj_Borc + (@KarsiOrjTutar * @KarsiBorcCarpan),
\ncho_Orj_Alacak = cho_Orj_Alacak + (@KarsiOrjTutar * @KarsiAlacakCarpan)
\nWHERE cho_RECno = @karsiozetrecno
\nEND
\nEND<\/p>\n
IF @deletedcount=1
\nBEGIN
\nSELECT
\n@NormalBorcCarpan = CASE WHEN cha_tip <> 1 THEN 1.0 ELSE 0.0 END,
\n@NormalAlacakCarpan = CASE WHEN cha_tip = 1 THEN 1.0 ELSE 0.0 END,
\n@NormalCariCins = cha_cari_cins,
\n@NormalGrupNo = cha_grupno,
\n@NormalAnaTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@NormalAltTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@NormalOrjTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n2,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@normalozetrecno = ISNULL(NORMALCARI.cho_RECno,0),<\/p>\n
@KarsiBorcCarpan = CASE WHEN cha_kasa_hizkod <> ” AND cha_tip = 1 THEN 1.0 ELSE 0.0 END,
\n@KarsiAlacakCarpan = CASE WHEN cha_kasa_hizkod <> ” AND cha_tip <> 1 THEN 1.0 ELSE 0.0 END,
\n@KarsiCariCins = cha_kasa_hizmet,
\n@KarsiGrupNo = cha_karsidgrupno,
\n@KarsiAnaTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@KarsiAltTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@KarsiOrjTutar = dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n3,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu),
\n@karsiozetrecno = ISNULL(KARSICARI.cho_RECno,0)<\/p>\n
FROM DELETED WITH (NOLOCK)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET NORMALCARI ON (NORMALCARI.cho_firmano = cha_firmano AND
\nNORMALCARI.cho_subeno = cha_subeno AND
\nNORMALCARI.cho_Cinsi = cha_cari_cins AND
\nNORMALCARI.cho_CariKodu = cha_kod AND
\nNORMALCARI.cho_ProjeKodu = cha_projekodu AND
\nNORMALCARI.cho_SrmMerkezi = cha_srmrkkodu AND
\nNORMALCARI.cho_GrupNo = cha_grupno AND
\nNORMALCARI.cho_MaliYil = DatePart(YYYY,cha_tarihi) AND
\nNORMALCARI.cho_Donem = DatePart(mm,cha_tarihi) AND
\nNORMALCARI.cho_HareketCins= cha_cinsi)
\nLEFT OUTER JOIN dbo.CARI_HESAP_HAREKETLERI_OZET KARSICARI ON (cha_kasa_hizkod <> ” AND
\nKARSICARI.cho_firmano = cha_firmano AND
\nKARSICARI.cho_subeno = cha_subeno AND
\nKARSICARI.cho_Cinsi = cha_kasa_hizmet AND
\nKARSICARI.cho_CariKodu = cha_kasa_hizkod AND
\nKARSICARI.cho_ProjeKodu = cha_projekodu AND
\nKARSICARI.cho_SrmMerkezi = cha_karsisrmrkkodu AND
\nKARSICARI.cho_GrupNo = cha_karsidgrupno AND
\nKARSICARI.cho_MaliYil = DatePart(YYYY,cha_tarihi) AND
\nKARSICARI.cho_Donem = DatePart(mm,cha_tarihi) AND
\nKARSICARI.cho_HareketCins = cha_cinsi)<\/p>\n
IF @normalozetrecno>0 \/*silinen kayd\u0131n \u00f6zeti yoksa (normal \u015fartlarda olmal\u0131), bir\u015fey yapmaya gerek yok*\/
\nUPDATE dbo.CARI_HESAP_HAREKETLERI_OZET
\nSET
\ncho_Ana_Borc = cho_Ana_Borc – (@NormalAnaTutar * @NormalBorcCarpan),
\ncho_Ana_Alacak = cho_Ana_Alacak – (@NormalAnaTutar * @NormalAlacakCarpan),
\ncho_Alt_Borc = cho_Alt_Borc – (@NormalAltTutar * @NormalBorcCarpan),
\ncho_Alt_Alacak = cho_Alt_Alacak – (@NormalAltTutar * @NormalAlacakCarpan),
\ncho_Orj_Borc = cho_Orj_Borc – (@NormalOrjTutar * @NormalBorcCarpan),
\ncho_Orj_Alacak = cho_Orj_Alacak – (@NormalOrjTutar * @NormalAlacakCarpan)
\nWHERE cho_RECno = @normalozetrecno<\/p>\n
IF @KarsiBorcCarpan > 0.0 or @KarsiAlacakCarpan > 0.0
\nBEGIN
\nIF @karsiozetrecno>0 \/*silinen kayd\u0131n \u00f6zeti yoksa (normal \u015fartlarda olmal\u0131), bir\u015fey yapmaya gerek yok*\/
\nUPDATE dbo.CARI_HESAP_HAREKETLERI_OZET
\nSET
\ncho_Ana_Borc = cho_Ana_Borc – (@KarsiAnaTutar * @KarsiBorcCarpan),
\ncho_Ana_Alacak = cho_Ana_Alacak – (@KarsiAnaTutar * @KarsiAlacakCarpan),
\ncho_Alt_Borc = cho_Alt_Borc – (@KarsiAltTutar * @KarsiBorcCarpan),
\ncho_Alt_Alacak = cho_Alt_Alacak – (@KarsiAltTutar * @KarsiAlacakCarpan),
\ncho_Orj_Borc = cho_Orj_Borc – (@KarsiOrjTutar * @KarsiBorcCarpan),
\ncho_Orj_Alacak = cho_Orj_Alacak – (@KarsiOrjTutar * @KarsiAlacakCarpan)
\nWHERE cho_RECno = @karsiozetrecno
\nEND
\nEND
\nEND
\nEND
\nGO<\/p>\n
Exec sp_settriggerorder @triggername = ‘mye_CARI_HESAP_HAREKETLERI_Trigger’,
\n@order = ‘Last’,
\n@stmttype = ‘INSERT’,
\n@namespace = null
\nGO
\nExec sp_settriggerorder @triggername = ‘mye_CARI_HESAP_HAREKETLERI_Trigger’,
\n@order = ‘Last’,
\n@stmttype = ‘UPDATE’,
\n@namespace = null
\nGO
\nExec sp_settriggerorder @triggername = ‘mye_CARI_HESAP_HAREKETLERI_Trigger’,
\n@order = ‘Last’,
\n@stmttype = ‘DELETE’,
\n@namespace = null
\nGO
\n————————-<\/p>\n
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].Disable_CARI_HESAP_HAREKETLERI_Triggers’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
\ndrop procedure [dbo].Disable_CARI_HESAP_HAREKETLERI_Triggers
\nGO<\/p>\n
CREATE PROCEDURE dbo.Disable_CARI_HESAP_HAREKETLERI_Triggers
\nAS
\nBEGIN
\nif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].mye_CARI_HESAP_HAREKETLERI_Trigger’)and OBJECTPROPERTY(id, N’IsTrigger’) = 1)
\nEXECUTE (‘Disable TRIGGER [dbo].[mye_CARI_HESAP_HAREKETLERI_Trigger] ON [dbo].[CARI_HESAP_HAREKETLERI]’)
\nEND
\nGO<\/p>\n
————————-<\/p>\n
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].Enable_CARI_HESAP_HAREKETLERI_Triggers’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
\ndrop procedure [dbo].Enable_CARI_HESAP_HAREKETLERI_Triggers
\nGO<\/p>\n
CREATE PROCEDURE dbo.Enable_CARI_HESAP_HAREKETLERI_Triggers
\nAS
\nBEGIN
\nif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].mye_CARI_HESAP_HAREKETLERI_Trigger’)and OBJECTPROPERTY(id, N’IsTrigger’) = 1)
\nEXECUTE (‘Enable TRIGGER [dbo].[mye_CARI_HESAP_HAREKETLERI_Trigger] ON [dbo].[CARI_HESAP_HAREKETLERI]’)
\nEND
\nGO
\n—————————
\nif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].msp_CARI_HESAP_HAREKETLERI_OZET_Update’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
\ndrop procedure [dbo].msp_CARI_HESAP_HAREKETLERI_OZET_Update
\nGO<\/p>\n
CREATE PROCEDURE dbo.msp_CARI_HESAP_HAREKETLERI_OZET_Update
\nAS
\nBEGIN
\nTRUNCATE TABLE dbo.CARI_HESAP_HAREKETLERI_OZET<\/p>\n
INSERT INTO dbo.CARI_HESAP_HAREKETLERI_OZET
\nSELECT
\nCHFIRMA,
\nCHSUBE,
\nCHCARICINS,
\nCHCARIKOD,
\nCHPROJE,
\nCHSRMMRK,
\nCHGRUPNO,
\nCHYIL,
\nCHDONEM,
\nCHCINS,
\nSUM(CASE WHEN CHTIP=0 THEN CHANA ELSE 0.0 END),
\nSUM(CASE WHEN CHTIP=1 THEN CHANA ELSE 0.0 END),
\nSUM(CASE WHEN CHTIP=0 THEN CHALT ELSE 0.0 END),
\nSUM(CASE WHEN CHTIP=1 THEN CHALT ELSE 0.0 END),
\nSUM(CASE WHEN CHTIP=0 THEN CHORJ ELSE 0.0 END),
\nSUM(CASE WHEN CHTIP=1 THEN CHORJ ELSE 0.0 END)
\nFROM
\n(SELECT
\ncha_firmano AS CHFIRMA,
\ncha_subeno AS CHSUBE,
\ncha_cari_cins AS CHCARICINS,
\ncha_kod AS CHCARIKOD,
\ncha_projekodu AS CHPROJE,
\ncha_srmrkkodu AS CHSRMMRK,
\ncha_grupno AS CHGRUPNO,
\nDatePart(YYYY,cha_tarihi) AS CHYIL,
\nDatePart(mm,cha_tarihi) AS CHDONEM,
\ncha_cinsi AS CHCINS,
\ncha_tip AS CHTIP,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)) AS CHANA,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)) AS CHALT,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n2,cha_cari_cins,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)) AS CHORJ
\nFROM dbo.CARI_HESAP_HAREKETLERI WITH (NOLOCK)
\nGROUP BY cha_firmano,cha_subeno,cha_cari_cins,cha_kod,cha_projekodu,cha_srmrkkodu,cha_grupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip<\/p>\n
UNION ALL<\/p>\n
SELECT
\ncha_firmano,
\ncha_subeno,
\ncha_kasa_hizmet,
\ncha_kasa_hizkod,
\ncha_projekodu,
\ncha_karsisrmrkkodu,
\ncha_karsidgrupno,
\nDatePart(YYYY,cha_tarihi),
\nDatePart(mm,cha_tarihi),
\ncha_cinsi,
\nCASE WHEN cha_tip=0 THEN 1 ELSE 0 END,
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n0,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n1,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu)),
\nsum(dbo.fn_CariHesapMeblag(cha_meblag,cha_aratoplam,
\ncha_vergi1,cha_vergi2,cha_vergi3,cha_vergi4,cha_vergi5,cha_vergi6,cha_vergi7,cha_vergi8,cha_vergi9,cha_vergi10+
\ncha_ilave_edilecek_kdv1+cha_ilave_edilecek_kdv2+cha_ilave_edilecek_kdv3+cha_ilave_edilecek_kdv4+cha_ilave_edilecek_kdv5+
\ncha_ilave_edilecek_kdv6+cha_ilave_edilecek_kdv7+cha_ilave_edilecek_kdv8+cha_ilave_edilecek_kdv9+cha_ilave_edilecek_kdv10,
\ncha_d_kur,cha_altd_kur,cha_karsid_kur,cha_cinsi,cha_evrak_tip,
\n3,cha_kasa_hizmet,
\ncha_meblag_ana_doviz_icin_gecersiz_fl,cha_meblag_alt_doviz_icin_gecersiz_fl,cha_meblag_orj_doviz_icin_gecersiz_fl,
\ncha_ft_masraf1,cha_ft_masraf2,cha_ft_masraf3,cha_ft_masraf4,
\ncha_otvtutari,cha_oivtutari,cha_yuvarlama,cha_tevkifat_toplam,cha_stopaj,cha_savsandesfonu))
\nFROM dbo.CARI_HESAP_HAREKETLERI WITH (NOLOCK)
\nWHERE cha_kasa_hizkod <> ”
\nGROUP BY cha_firmano,cha_subeno,cha_kasa_hizmet,cha_kasa_hizkod,cha_projekodu,cha_karsisrmrkkodu,cha_karsidgrupno,
\nDatePart(YYYY,cha_tarihi),DatePart(mm,cha_tarihi),cha_cinsi,cha_tip
\n)AS CH
\nGROUP BY
\nCHFIRMA,
\nCHSUBE,
\nCHCARICINS,
\nCHCARIKOD,
\nCHPROJE,
\nCHSRMMRK,
\nCHGRUPNO,
\nCHYIL,
\nCHDONEM,
\nCHCINS
\nEND
\nGO
\n–EXEC dbo.msp_CARI_HESAP_HAREKETLERI_OZET_Update
\n————————————————————————-<\/p>\n