--select top 5 * from STOKHARDETBAG WHERE CariNo=2963 order by FaturaTarihi DESC
DECLARE @I INT=580045  ---(585537,s)
DECLARE @I3 INT =580045
SELECT 'STOKHAR',IslemNo,IslemNo3,SUM(SonTutar) TOPLAM FROM STOKHAR where IslemNo3=@I3 or IslemNo=@I group by IslemNo ,IslemNo3
select 'STOKHAR',IslemNo ino,IslemNo3,SonTutar,* from STOKHAR where IslemNo3=@I3 or IslemNo=@I order  by IslemNo
select 'STOKHARDETBAG',IslemNo ino,IslemNo3,* from STOKHARDETBAG where IslemNo3=@I3 or IslemNo=@I order  by IslemNo
select 'ACARI',* from ACARI WHERE ISLEMNO=@I OR ISLEMNO=@I3
select 'Tevkifat',IslemNo  from Tevkifat where  IslemNo IN (@I,@I3) order  by IslemNo

DECLARE @i int
SET @i=  456645-- 457003 --455849
--455935
 --  455849  -- 455577 --  455935
select 'AC',Update_Date,ISLEMNO,BORC,ALACAK,BAACIKLA,CARINO,MUSKOD  from ACARI WHERE ISLEMNO =@i UNION
select 'KS','',ISLEMNO,BORC,ALACAK,BAACIKLA,HARNO,KASAADI from KASA WHERE ISLEMNO =@i UNION
select 'OD','',IslemNo ,sum(Borc) ,sum(Alacak),BAAcikla,CariNo,CariKodu   from Odeme  WHERE IslemNo  =@i group by IslemNo,CariNo,CariKodu,BAAcikla UNION
select 'SH','',IslemNo ,(SELECT SUM(SonTutar) FROM STOKHAR WHERE IslemNo=@i or IslemNo3=@i ) ,(SELECT SUM(SonTutarDov) FROM STOKHAR WHERE IslemNo=@i or IslemNo3=@i ),IslemTuru,IslemNo3,CariKodu from STOKHAR  WHERE IslemNo  =@i or IslemNo3=@i UNION
select 'SD',Update_Date,IslemNo ,Tutar ,DovizTut,IslemTuru,NoId,CariKodu from STOKHARDETBAG  WHERE IslemNo  =@i  union
select 'SHL',EklemeTarihi,IslemNo,SonTutar,SonTutarDov,IslemTuru,NoId,(Select MUSKOD from AMUSTERI Where MUSNO =  shl.CariNo) from StokHarLog shl  WHERE IslemNo  =@i 

---
declare @i int = 458489  
declare @i3 int = 458489  
select 'AC',* from ACARI WHERE ISLEMNO = (@Ý) or ISLEMNO =@i3
select 'SD',* from STOKHARDETBAG WHERE IslemNo   =@Ý OR IslemNo  =@Ý3
select 'SH_TOPLAM',SUM(SonTutar) from STOKHAR WHERE IslemNo  =@Ý or  IslemNo  =@Ý3 or IslemNo3  =@Ý or IslemNo3  =@Ý3 
select 'SH_INO_GRUP',IslemNo,IslemNo3,SUM(SonTutar) INO_TOPLAM from STOKHAR WHERE IslemNo  =@Ý or  IslemNo  =@Ý3 or IslemNo3  =@Ý or IslemNo3  =@Ý3 GROUP BY IslemNo,IslemNo3
select 'SH',IslemNo,IslemNo3,* from STOKHAR WHERE IslemNo  =@Ý or  IslemNo  =@Ý3 or IslemNo3  =@Ý or IslemNo3  =@Ý3
---
select DISTINCT *,abs(Tutar-sh_Tutar ) TutarFarký ,abs(KdvTutari-sh_Kdv)KdvFarký ,abs(A_BORC-Tutar) CariFark from (
SELECT SD.IslemNo,SD.CariNo,SD.IslemTuru ,SD.Tutar, SD.KdvTutari , 
(select sum(SH.SonTutar) from STOKHAR SH WHERE SH.IslemNo=SD.IslemNo group by IslemNo)  sh_Tutar,
(select sum(SH.KdvTutari) from STOKHAR SH WHERE SH.IslemNo=SD.IslemNo group by IslemNo )  sh_Kdv,
(select SUM(BORC ) from ACARI A WHERE A.ISLEMNO=SD.IslemNo group by ISLEMNO) A_BORC,
(select SUM(ALACAK ) from ACARI A WHERE A.ISLEMNO=SD.IslemNo group by ISLEMNO) A_ALACAK
FROM STOKHARDETBAG SD 
--left JOIN ACARI A on A.ISLEMNO=SD.IslemNo 
--FULL JOIN Odeme O 
WHERE SD.IslemTuru ='Prk.Satýþ' OR SD.IslemTuru ='Satýþ'
)t 
where abs(Tutar-sh_Tutar )>0.01  or  abs(KdvTutari-sh_Kdv)>0.01-- OR ABS(A_TUTAR-Tutar)>0.01
order by 1

--STOKHAR-DETBAG FARKI

select DISTINCT *,abs(Tutar-sh_Tutar ) TutarFarký ,abs(KdvTutari-sh_Kdv)KdvFarký  from (
SELECT SD.CariAdi,SD.IslemNo,SD.CariNo,SD.IslemTuru ,SD.Tutar, SD.KdvTutari , 
(select sum(SH.SonTutar) from STOKHAR SH WHERE ( SH.IslemNo=SD.IslemNo or  SH.IslemNo3=SD.IslemNo) )  sh_Tutar
-- ,(select sum(SH.KdvTutari) from STOKHAR SH WHERE ( SH.IslemNo=SD.IslemNo or  SH.IslemNo3=SD.IslemNo) )  sh_Kdv
FROM STOKHARDETBAG SD 
--left JOIN ACARI A on A.ISLEMNO=SD.IslemNo 
--FULL JOIN Odeme O 
WHERE SD.IslemTuru  in ('Prk.Satýþ','Satýþ','Alýþ')
)t 
where abs(Tutar-sh_Tutar )>0.01  or  abs(KdvTutari-sh_Kdv)>0.01-- OR ABS(A_TUTAR-Tutar)>0.01
order by 1
--STOKHARDETBAG - ACARI FARKI
select DISTINCT *,abs(A_BORC+A_ALACAK-Tutar) CariFark from (
SELECT SD.IslemNo,SD.CariNo,SD.IslemTuru ,SD.Tutar, SD.KdvTutari , 
(select SUM(BORC ) from ACARI A WHERE A.ISLEMNO=SD.IslemNo AND A.BAACIKLA=SD.IslemTuru group by ISLEMNO) A_BORC,
(select SUM(ALACAK ) from ACARI A WHERE A.ISLEMNO=SD.IslemNo AND A.BAACIKLA=SD.IslemTuru group by ISLEMNO) A_ALACAK
FROM STOKHARDETBAG SD 
--left JOIN ACARI A on A.ISLEMNO=SD.IslemNo 
--FULL JOIN Odeme O 
WHERE SD.IslemTuru IN  ('Prk.Satýþ','Satýþ','Alýþ')-- and CariKodu ='CARÝ 298'
)t 
where abs(A_BORC+A_ALACAK-Tutar)>0.01  order by 1