http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 10 Jun 2026 00:46:56 +0000 Sun, 12 May 2013 00:09:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=3439 http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18817.html#18817 Yazar: emiray
Konu: 3439
Gönderim Zamanı: 12 Mayıs 2013 Saat 00:09

SELECT     TOP (100) PERCENT dbo.TBLSTSABIT.STOK_KODU, dbo.TBLSTSABIT.STOK_ADI, dbo.TBLSTHAR.STHAR_TARIH AS TARIH, dbo.TBLSTHAR.STHAR_NF AS NET_FIAT,
                      dbo.TBLSTHAR.STHAR_ACIKLAMA AS CARI_KOD, dbo.TBLSTHAR.STHAR_GCKOD AS GCKOD, dbo.TBLSTHAR.STHAR_KDV AS KDV,
                      dbo.TBLSTHAR.STHAR_HTUR AS HTUR, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'C' AND TBLSTHAR.STHAR_HTUR IN ('I', 'J', 'K')
                      THEN STHAR_GCMIK ELSE 0 END) AS SATIS_MIKTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'C' AND TBLSTHAR.STHAR_HTUR IN ('I', 'J', 'K')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS SATIS_TUTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'G' AND TBLSTHAR.STHAR_HTUR IN ('I', 'J', 'K')
                      THEN STHAR_GCMIK ELSE 0 END) AS ALIS_MIKTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'G' AND TBLSTHAR.STHAR_HTUR IN ('I', 'J', 'K')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS ALIS_TUTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'C' AND TBLSTHAR.STHAR_HTUR IN ('L', 'M')
                      THEN STHAR_GCMIK ELSE 0 END) AS ALISTAN_IADE_MIKTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'C' AND TBLSTHAR.STHAR_HTUR IN ('L', 'M')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS ALISTAN_IADE_TUTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'G' AND TBLSTHAR.STHAR_HTUR IN ('L', 'M')
                      THEN STHAR_GCMIK ELSE 0 END) AS SATISTAN_IADE_MIKTARI, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'G' AND TBLSTHAR.STHAR_HTUR IN ('L', 'M')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS IADE_TUTARI, dbo.TBLSTSABIT.GRUP_KODU, dbo.TBLSTSABIT.KOD_1 AS KOD1,
                      dbo.TBLSTSABIT.KOD_2 AS KOD2, dbo.TBLSTSABIT.KOD_3 AS KOD3, dbo.TBLSTSABIT.KOD_4 AS KOD4, dbo.TBLSTSABIT.KOD_5 AS KOD5,
                      dbo.TBLSTSABIT.ALIS_FIAT1, dbo.TBLCASABIT.CARI_ISIM, dbo.TBLSTHAR.PLASIYER_KODU AS PLS, DATEPART(MONTH, dbo.TBLSTHAR.STHAR_TARIH) AS AY,
                      dbo.TBLSTHAR.STHAR_KOD2, dbo.TBLSTHAR.STHAR_BGTIP, dbo.TBLCASABIT.CARI_ILCE AS ILCE, dbo.TBLCASABIT.CARI_IL AS IL,
                      dbo.TBLCASABIT.RAPOR_KODU1 AS RUT, dbo.TBLCASABIT.CARI_ADRES AS ADRES, dbo.TBLCASABIT.VERGI_DAIRESI AS V_DAIRESI,
                      dbo.TBLCASABIT.VERGI_NUMARASI AS V_NO, dbo.TBLCASABIT.CARI_TEL AS TEL_NO, dbo.TBLCASABIT.CARI_TIP, dbo.TBLSTSABIT.OLCU_BR1 AS BR,
                      dbo.TBLSTHAR.STHAR_KDV, (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'C' AND TBLSTHAR.STHAR_HTUR IN ('I', 'J', 'K')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) - (CASE WHEN TBLSTHAR.STHAR_GCKOD = 'G' AND TBLSTHAR.STHAR_HTUR IN ('L', 'M')
                      THEN STHAR_GCMIK * STHAR_NF ELSE 0 END) AS NET_SATIS, dbo.TBLCARIPLASIYER.PLASIYER_ACIKLAMA AS PLAS_ADI, RIGHT(dbo.TBLSTHAR.FISNO, 6)
                      AS F_NO
FROM         dbo.TBLSTHAR INNER JOIN
                      dbo.TBLSTSABIT ON dbo.TBLSTHAR.STOK_KODU = dbo.TBLSTSABIT.STOK_KODU INNER JOIN
                      dbo.TBLCASABIT ON dbo.TBLSTHAR.STHAR_ACIKLAMA = dbo.TBLCASABIT.CARI_KOD INNER JOIN
                      dbo.TBLCARIPLASIYER ON dbo.TBLSTHAR.PLASIYER_KODU = dbo.TBLCARIPLASIYER.PLASIYER_KODU
ORDER BY dbo.TBLSTHAR.SIRA
****************************************************************
bu viewin isinizi görecegini umarim.
]]> Sun, 12 May 2013 00:09:38 +0000 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18817.html#18817 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18814.html#18814 Yazar: Conari
Konu: 3439
Gönderim Zamanı: 10 Mayıs 2013 Saat 11:19

Rapor > stok cari analiz.]]> Fri, 10 May 2013 11:19:24 +0000 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18814.html#18814 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18812.html#18812 Yazar: bybarone
Konu: 3439
Gönderim Zamanı: 09 Mayıs 2013 Saat 09:25

selimtuncer Yazdı: Mal Detayli Karlilik Raporu içini görür.

+1]]> Thu, 09 May 2013 09:25:39 +0000 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18812.html#18812 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18811.html#18811 Yazar: selimtuncer
Konu: 3439
Gönderim Zamanı: 07 Mayıs 2013 Saat 11:10

Mal Detayli Karlilik Raporu içini görür.]]> Tue, 07 May 2013 11:10:45 +0000 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18811.html#18811 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18810.html#18810 Yazar: zhorba
Konu: 3439
Gönderim Zamanı: 07 Mayıs 2013 Saat 10:27

Satis faturasinin ayrintili raporunu nasil görüntülerim.
Örnegin ilk üç aylik satislarimizin.
Hangi faturanin içinde hangi ürünler var bu rapor olarak nereden alirim ?

]]> Tue, 07 May 2013 10:27:30 +0000 http://www.erpne.org/fatura-ayrintili-rapor_topic3439_post18810.html#18810