• Merhaba Ziyaretçi,
    Microsoft 365 Uygulamaları ile ilgili yeni haberler, dikkat çekici konular, ilgi ile takip edeceğiniz yazılar için.

    Abone Olun
  • ESTE - Microsoft Office Eğitimleri

    Yeni yıl Microsoft Office Eğitim planlarınız için bütçenizi oluşturmadan önce ESTE eğitim kalitesi ile tanışın. 🙌
    Kullanıcıların ihtiyacı olan yazılı materyal, dosya ve video kaynağı desteğimiz ile tüm ofis çalışanlarının iş süreçlerini rahatlatacak eğitimler planlayın. 🎯
    Microsoft Office eğitimlerimiz hakkında detaylı bilgi için bize ulaşın.

    👉 Microsoft Office Eğitim Talebi

SQL Sorgu tüm alış ve satış faturalarını sql ile excelle çekme

E

enverdersin

Yeni Üye
Katılım
8 Şub 2019
Mesajlar
163
En iyi yanıt
0
Puanları
18
Yaş
45
Konum
istanbul
Ad Soyad
ENVER DERSİN
aşağıdaki koda işyeri, fabrika ve ambar kolanlarını ekleyebilir miyiz?




SELECT
YEAR(INV.DATE_) AS 'YIL',
MONTH(INV.DATE_) AS 'AY',
INV.DATE_ AS 'FATURA TARİHİ',
INV.FICHENO AS 'FATURA NO',
CL.CODE AS 'CARİ KODU',
CL.DEFINITION_ AS 'CARİ ÜNVAN',
EMCENTER.CODE AS 'MASRAF MERKEZİ KODU',
EMCENTER.DEFINITION_ AS 'MASRAF MERKEZİ ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.CODE WHEN 4 THEN SRVCARD.CODE WHEN 8 THEN IT.CODE ELSE ' ' END AS 'STOK KODU',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME WHEN 4 THEN SRVCARD.DEFINITION_ WHEN 8 THEN IT.NAME ELSE ' ' END AS 'STOK ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME3 WHEN 4 THEN SRVCARD.DEFINITION2 WHEN 8 THEN IT.NAME3 ELSE ' ' END AS 'STOK ADI_2',
ST.AMOUNT AS 'MİKTAR',
ST.PRICE AS 'BİRİM FİYAT',
ST.VAT AS 'SATIR KDV ORANI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN CONVERT(VARCHAR,ST.DEDUCTIONPART1) +' / '+ CONVERT(VARCHAR,ST.DEDUCTIONPART2) ELSE '' END AS 'TEVKİFAT ORANI',ST.DEDUCTCODE AS 'TEVKİFAT KODU',
ST.VATMATRAH AS 'MATRAH',
((ST.VATMATRAH*ST.VAT)/100) AS 'SATIR KDV TUTARI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN ST.VATAMNT ELSE 0 END AS 'TEVKİFAT KDV TUTARI',
(ST.VATMATRAH+((ST.VATMATRAH*ST.VAT)/100)) AS 'SATIR GENEL TOPLAM',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=2 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME SATIŞ FİYATI',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=1 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME ALIŞ FİYATI',
CASE INV.TRCODE WHEN 1 THEN 'Satınalma Faturası' WHEN 8 THEN 'Satış Faturası' WHEN 4 THEN 'Alınan Hizmet Faturası'
WHEN 6 THEN 'Satınalma İade Faturası' WHEN 13 THEN 'Satınalma Fiyat Farkı Faturası' WHEN 3 THEN 'Satış İade Faturası'
WHEN 9 THEN 'Verilen Hizmet Faturası' WHEN 14 THEN 'Satış Fiyat Farkı' ELSE ' ' END AS 'FATURA TÜRÜ',
EMUHACC.CODE AS 'MUHASEBE HESABI KODU',
EMUHACC.DEFINITION_ AS 'MUHASEBE HESABI ADI',
CL.TAXNR AS 'VERGİ NUMARASI',
CL.TCKNO AS 'TC NUMARASI',
CL.TAXOFFICE AS 'VERGİ DAİRESİ',
CL.ADDR1 AS 'ADRES',
CL.TELNRS1 AS 'TELEFON NUMARASI',
CL.EMAILADDR AS 'EMAIL ADRESİ',
INV.DEPARTMENT AS 'BOLUM'

FROM LG_420_02_STLINE AS ST
LEFT OUTER JOIN LG_420_ITEMS as IT ON ST.STOCKREF=IT.LOGICALREF
LEFT OUTER JOIN LG_420_CLCARD as CL ON ST.CLIENTREF=CL.LOGICALREF
LEFT OUTER JOIN LG_420_02_INVOICE as INV ON ST.INVOICEREF=INV.LOGICALREF
LEFT OUTER JOIN LG_420_EMCENTER EMCENTER ON ST.CENTERREF=EMCENTER.LOGICALREF
LEFT OUTER JOIN LG_420_EMUHACC EMUHACC ON INV.ACCOUNTREF=EMUHACC.LOGICALREF
LEFT OUTER JOIN LG_420_SRVCARD SRVCARD ON SRVCARD.LOGICALREF=ST.STOCKREF

WHERE ((INV.TRCODE IN (1, 2, 3, 4, 12,31,8,9,6)) AND (INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 13) AND (INV.DECPRDIFF = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 14) AND (INV.DECPRDIFF = 1))
AND YEAR(INV.DATE_) ='2021'
 
R

Rahle

Yeni Üye
Katılım
20 Haz 2018
Mesajlar
137
En iyi yanıt
0
Puanları
18
Yaş
51
Konum
İstanbul
Ad Soyad
Huzeyfe Yaman
Office Vers.
Office 2010
Merhaba,

Deneyiniz.

SQL: 
SELECT
YEAR(INV.DATE_) AS 'YIL',
MONTH(INV.DATE_) AS 'AY',
INV.DATE_ AS 'FATURA TARİHİ',
INV.FICHENO AS 'FATURA NO',
CL.CODE AS 'CARİ KODU',
CL.DEFINITION_ AS 'CARİ ÜNVAN',
EMCENTER.CODE AS 'MASRAF MERKEZİ KODU',
EMCENTER.DEFINITION_ AS 'MASRAF MERKEZİ ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.CODE WHEN 4 THEN SRVCARD.CODE WHEN 8 THEN IT.CODE ELSE ' ' END AS 'STOK KODU',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME WHEN 4 THEN SRVCARD.DEFINITION_ WHEN 8 THEN IT.NAME ELSE ' ' END AS 'STOK ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME3 WHEN 4 THEN SRVCARD.DEFINITION2 WHEN 8 THEN IT.NAME3 ELSE ' ' END AS 'STOK ADI_2',
ST.AMOUNT AS 'MİKTAR',
ST.PRICE AS 'BİRİM FİYAT',
ST.VAT AS 'SATIR KDV ORANI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN CONVERT(VARCHAR,ST.DEDUCTIONPART1) +' / '+ CONVERT(VARCHAR,ST.DEDUCTIONPART2) ELSE '' END AS 'TEVKİFAT ORANI',ST.DEDUCTCODE AS 'TEVKİFAT KODU',
ST.VATMATRAH AS 'MATRAH',
((ST.VATMATRAH*ST.VAT)/100) AS 'SATIR KDV TUTARI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN ST.VATAMNT ELSE 0 END AS 'TEVKİFAT KDV TUTARI',
(ST.VATMATRAH+((ST.VATMATRAH*ST.VAT)/100)) AS 'SATIR GENEL TOPLAM',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=2 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME SATIŞ FİYATI',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=1 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME ALIŞ FİYATI',
CASE INV.TRCODE WHEN 1 THEN 'Satınalma Faturası' WHEN 8 THEN 'Satış Faturası' WHEN 4 THEN 'Alınan Hizmet Faturası'
WHEN 6 THEN 'Satınalma İade Faturası' WHEN 13 THEN 'Satınalma Fiyat Farkı Faturası' WHEN 3 THEN 'Satış İade Faturası'
WHEN 9 THEN 'Verilen Hizmet Faturası' WHEN 14 THEN 'Satış Fiyat Farkı' ELSE ' ' END AS 'FATURA TÜRÜ',
EMUHACC.CODE AS 'MUHASEBE HESABI KODU',
EMUHACC.DEFINITION_ AS 'MUHASEBE HESABI ADI',
CL.TAXNR AS 'VERGİ NUMARASI',
CL.TCKNO AS 'TC NUMARASI',
CL.TAXOFFICE AS 'VERGİ DAİRESİ',
CL.ADDR1 AS 'ADRES',
CL.TELNRS1 AS 'TELEFON NUMARASI',
CL.EMAILADDR AS 'EMAIL ADRESİ',
INV.DEPARTMENT AS 'BOLUM',
INV.BRANCH 'İŞ YERİ',
INV.SOURCEINDEX 'AMBAR',
INV.FACTORYNR 'FABRİKA'

FROM LG_420_02_STLINE AS ST
LEFT OUTER JOIN LG_420_ITEMS as IT ON ST.STOCKREF=IT.LOGICALREF
LEFT OUTER JOIN LG_420_CLCARD as CL ON ST.CLIENTREF=CL.LOGICALREF
LEFT OUTER JOIN LG_420_02_INVOICE as INV ON ST.INVOICEREF=INV.LOGICALREF
LEFT OUTER JOIN LG_420_EMCENTER EMCENTER ON ST.CENTERREF=EMCENTER.LOGICALREF
LEFT OUTER JOIN LG_420_EMUHACC EMUHACC ON INV.ACCOUNTREF=EMUHACC.LOGICALREF
LEFT OUTER JOIN LG_420_SRVCARD SRVCARD ON SRVCARD.LOGICALREF=ST.STOCKREF

WHERE ((INV.TRCODE IN (1, 2, 3, 4, 12,31,8,9,6)) AND (INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 13) AND (INV.DECPRDIFF = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 14) AND (INV.DECPRDIFF = 1))
AND YEAR(INV.DATE_) ='2021'
 
E

enverdersin

Yeni Üye
Katılım
8 Şub 2019
Mesajlar
163
En iyi yanıt
0
Puanları
18
Yaş
45
Konum
istanbul
Ad Soyad
ENVER DERSİN
Rahle' Alıntı:
Merhaba,

Deneyiniz.

SQL: 
SELECT
YEAR(INV.DATE_) AS 'YIL',
MONTH(INV.DATE_) AS 'AY',
INV.DATE_ AS 'FATURA TARİHİ',
INV.FICHENO AS 'FATURA NO',
CL.CODE AS 'CARİ KODU',
CL.DEFINITION_ AS 'CARİ ÜNVAN',
EMCENTER.CODE AS 'MASRAF MERKEZİ KODU',
EMCENTER.DEFINITION_ AS 'MASRAF MERKEZİ ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.CODE WHEN 4 THEN SRVCARD.CODE WHEN 8 THEN IT.CODE ELSE ' ' END AS 'STOK KODU',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME WHEN 4 THEN SRVCARD.DEFINITION_ WHEN 8 THEN IT.NAME ELSE ' ' END AS 'STOK ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME3 WHEN 4 THEN SRVCARD.DEFINITION2 WHEN 8 THEN IT.NAME3 ELSE ' ' END AS 'STOK ADI_2',
ST.AMOUNT AS 'MİKTAR',
ST.PRICE AS 'BİRİM FİYAT',
ST.VAT AS 'SATIR KDV ORANI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN CONVERT(VARCHAR,ST.DEDUCTIONPART1) +' / '+ CONVERT(VARCHAR,ST.DEDUCTIONPART2) ELSE '' END AS 'TEVKİFAT ORANI',ST.DEDUCTCODE AS 'TEVKİFAT KODU',
ST.VATMATRAH AS 'MATRAH',
((ST.VATMATRAH*ST.VAT)/100) AS 'SATIR KDV TUTARI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN ST.VATAMNT ELSE 0 END AS 'TEVKİFAT KDV TUTARI',
(ST.VATMATRAH+((ST.VATMATRAH*ST.VAT)/100)) AS 'SATIR GENEL TOPLAM',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=2 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME SATIŞ FİYATI',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=1 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME ALIŞ FİYATI',
CASE INV.TRCODE WHEN 1 THEN 'Satınalma Faturası' WHEN 8 THEN 'Satış Faturası' WHEN 4 THEN 'Alınan Hizmet Faturası'
WHEN 6 THEN 'Satınalma İade Faturası' WHEN 13 THEN 'Satınalma Fiyat Farkı Faturası' WHEN 3 THEN 'Satış İade Faturası'
WHEN 9 THEN 'Verilen Hizmet Faturası' WHEN 14 THEN 'Satış Fiyat Farkı' ELSE ' ' END AS 'FATURA TÜRÜ',
EMUHACC.CODE AS 'MUHASEBE HESABI KODU',
EMUHACC.DEFINITION_ AS 'MUHASEBE HESABI ADI',
CL.TAXNR AS 'VERGİ NUMARASI',
CL.TCKNO AS 'TC NUMARASI',
CL.TAXOFFICE AS 'VERGİ DAİRESİ',
CL.ADDR1 AS 'ADRES',
CL.TELNRS1 AS 'TELEFON NUMARASI',
CL.EMAILADDR AS 'EMAIL ADRESİ',
INV.DEPARTMENT AS 'BOLUM',
INV.BRANCH 'İŞ YERİ',
INV.SOURCEINDEX 'AMBAR',
INV.FACTORYNR 'FABRİKA'

FROM LG_420_02_STLINE AS ST
LEFT OUTER JOIN LG_420_ITEMS as IT ON ST.STOCKREF=IT.LOGICALREF
LEFT OUTER JOIN LG_420_CLCARD as CL ON ST.CLIENTREF=CL.LOGICALREF
LEFT OUTER JOIN LG_420_02_INVOICE as INV ON ST.INVOICEREF=INV.LOGICALREF
LEFT OUTER JOIN LG_420_EMCENTER EMCENTER ON ST.CENTERREF=EMCENTER.LOGICALREF
LEFT OUTER JOIN LG_420_EMUHACC EMUHACC ON INV.ACCOUNTREF=EMUHACC.LOGICALREF
LEFT OUTER JOIN LG_420_SRVCARD SRVCARD ON SRVCARD.LOGICALREF=ST.STOCKREF

WHERE ((INV.TRCODE IN (1, 2, 3, 4, 12,31,8,9,6)) AND (INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 13) AND (INV.DECPRDIFF = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 14) AND (INV.DECPRDIFF = 1))
AND YEAR(INV.DATE_) ='2021'
Genişletmek için tıkla ...

Üstad eline sağlık. kolay gelsin.
 
E

enverdersin

Yeni Üye
Katılım
8 Şub 2019
Mesajlar
163
En iyi yanıt
0
Puanları
18
Yaş
45
Konum
istanbul
Ad Soyad
ENVER DERSİN
Rahle' Alıntı:
Merhaba,

Deneyiniz.

SQL: 
SELECT
YEAR(INV.DATE_) AS 'YIL',
MONTH(INV.DATE_) AS 'AY',
INV.DATE_ AS 'FATURA TARİHİ',
INV.FICHENO AS 'FATURA NO',
CL.CODE AS 'CARİ KODU',
CL.DEFINITION_ AS 'CARİ ÜNVAN',
EMCENTER.CODE AS 'MASRAF MERKEZİ KODU',
EMCENTER.DEFINITION_ AS 'MASRAF MERKEZİ ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.CODE WHEN 4 THEN SRVCARD.CODE WHEN 8 THEN IT.CODE ELSE ' ' END AS 'STOK KODU',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME WHEN 4 THEN SRVCARD.DEFINITION_ WHEN 8 THEN IT.NAME ELSE ' ' END AS 'STOK ADI',
CASE ST.LINETYPE WHEN 0 THEN IT.NAME3 WHEN 4 THEN SRVCARD.DEFINITION2 WHEN 8 THEN IT.NAME3 ELSE ' ' END AS 'STOK ADI_2',
ST.AMOUNT AS 'MİKTAR',
ST.PRICE AS 'BİRİM FİYAT',
ST.VAT AS 'SATIR KDV ORANI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN CONVERT(VARCHAR,ST.DEDUCTIONPART1) +' / '+ CONVERT(VARCHAR,ST.DEDUCTIONPART2) ELSE '' END AS 'TEVKİFAT ORANI',ST.DEDUCTCODE AS 'TEVKİFAT KODU',
ST.VATMATRAH AS 'MATRAH',
((ST.VATMATRAH*ST.VAT)/100) AS 'SATIR KDV TUTARI',
CASE WHEN ST.DEDUCTIONPART1>0 OR ST.DEDUCTIONPART2>0 THEN ST.VATAMNT ELSE 0 END AS 'TEVKİFAT KDV TUTARI',
(ST.VATMATRAH+((ST.VATMATRAH*ST.VAT)/100)) AS 'SATIR GENEL TOPLAM',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=2 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME SATIŞ FİYATI',
(SELECT TOP 1 PRC.PRICE FROM LG_001_PRCLIST PRC WHERE PRC.PTYPE=1 AND PRC.ACTIVE=0 AND INV.DATE_ BETWEEN PRC.BEGDATE AND PRC.ENDDATE AND PRC.CARDREF=IT.LOGICALREF ORDER BY PRC.BEGDATE DESC) AS 'MALZEME ALIŞ FİYATI',
CASE INV.TRCODE WHEN 1 THEN 'Satınalma Faturası' WHEN 8 THEN 'Satış Faturası' WHEN 4 THEN 'Alınan Hizmet Faturası'
WHEN 6 THEN 'Satınalma İade Faturası' WHEN 13 THEN 'Satınalma Fiyat Farkı Faturası' WHEN 3 THEN 'Satış İade Faturası'
WHEN 9 THEN 'Verilen Hizmet Faturası' WHEN 14 THEN 'Satış Fiyat Farkı' ELSE ' ' END AS 'FATURA TÜRÜ',
EMUHACC.CODE AS 'MUHASEBE HESABI KODU',
EMUHACC.DEFINITION_ AS 'MUHASEBE HESABI ADI',
CL.TAXNR AS 'VERGİ NUMARASI',
CL.TCKNO AS 'TC NUMARASI',
CL.TAXOFFICE AS 'VERGİ DAİRESİ',
CL.ADDR1 AS 'ADRES',
CL.TELNRS1 AS 'TELEFON NUMARASI',
CL.EMAILADDR AS 'EMAIL ADRESİ',
INV.DEPARTMENT AS 'BOLUM',
INV.BRANCH 'İŞ YERİ',
INV.SOURCEINDEX 'AMBAR',
INV.FACTORYNR 'FABRİKA'

FROM LG_420_02_STLINE AS ST
LEFT OUTER JOIN LG_420_ITEMS as IT ON ST.STOCKREF=IT.LOGICALREF
LEFT OUTER JOIN LG_420_CLCARD as CL ON ST.CLIENTREF=CL.LOGICALREF
LEFT OUTER JOIN LG_420_02_INVOICE as INV ON ST.INVOICEREF=INV.LOGICALREF
LEFT OUTER JOIN LG_420_EMCENTER EMCENTER ON ST.CENTERREF=EMCENTER.LOGICALREF
LEFT OUTER JOIN LG_420_EMUHACC EMUHACC ON INV.ACCOUNTREF=EMUHACC.LOGICALREF
LEFT OUTER JOIN LG_420_SRVCARD SRVCARD ON SRVCARD.LOGICALREF=ST.STOCKREF

WHERE ((INV.TRCODE IN (1, 2, 3, 4, 12,31,8,9,6)) AND (INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 13) AND (INV.DECPRDIFF = 0) OR
(INV.NETTOTAL <> 0) AND (INV.CLIENTREF <> 0) AND (INV.CANCELLED = 0) AND (INV.TRCODE = 14) AND (INV.DECPRDIFF = 1))
AND YEAR(INV.DATE_) ='2021'
Genişletmek için tıkla ...

üstad ba-bs kanunu değiştiği için e-belge olanlarda ekteki belge gibi belge türünü işaretlemek gerekiyor. Bu belge türü kolonunu bu sorguya ekleme imkanımız var mı? Olursa herkese faydalı olacaktır. Bu kolanlardan e-belge olup da kağıt fatura seçilenleri hızlı şekilde tespit edebiliriz.
 

Ekli dosyalar

  • e-belge türü.png
    e-belge türü.png
    13.2 KB · Görüntüleme: 12
R

Rahle

Yeni Üye
Katılım
20 Haz 2018
Mesajlar
137
En iyi yanıt
0
Puanları
18
Yaş
51
Konum
İstanbul
Ad Soyad
Huzeyfe Yaman
Office Vers.
Office 2010
Merhaba,

Sorguya aşağıdaki satırı ilave edebilirsiniz.

SQL: 
CASE WHEN INV.EINVOICE=1 THEN 'E-Fatura' ELSE 'Kağıt Fatura' END 'FATURA CİNSİ',
 
Vedat ÖZER

Vedat ÖZER

Logo Uzmanı
Geliştirici
Katılım
4 Haz 2018
Mesajlar
288
En iyi yanıt
4
Puanları
63
Yaş
33
Konum
Antalya / Merkez
Ad Soyad
Vedat ÖZER
Office Vers.
2019
Case when ELECTDOC=0 or ELECTDOC IS NULL then 'İşaretli Değil' else 'İşaretli' end
 
Cevap yazmak için giriş yap yada kayıt ol.
Üst Alt