1234567891011 |
- select * from (
- select hedef as kod,c.cari_isim as cari_isim,
- sum(case when vade_tarihi <='@vade_tarihi@' and ftip='G' then round(geneltoplam,2) else
- case when vade_tarihi <='@vade_tarihi@' and ftip='C' then (-1*round(geneltoplam,2)) else 0 end end) as vgborc,
- sum(case when ftip='G' then round(geneltoplam,2) else (-1*round(geneltoplam,2)) end) as topborc
- from fatura as f
- inner join tblcasabit as c on f.hedef=c.cari_kod
- inner join tblcasabit as cx on f.kaynak=cx.cari_kod
- where cx.grup_kodu='@kaynak@' AND c.cari_tip='F' and c.rapor_kodu1='takip_alacak'
- group by hedef ORDER BY vgborc ASC,topborc asc ) as t
- where t.vgborc <=0 and topborc<0
|