(09-02-2022, Saat: 20:47)adelphiforumz Adlı Kullanıcıdan Alıntı: Merhabalar
LOGO yazılım Database ile bir entegrasyon yapmam lazım daha önceden uğraşan DB yapısını bilen varsa yardımcı olabilirmi
İhtiyacım olan firmanın günlük olarak tüm parasal giriş(TAHSİLAT) hareketlerine ulaşmaya çalışıyorum
Logo bunu herbiri farklı raporlarla veriyor bense Direkt DB üzerinden bir Soru ile alabilirmiyim.
KASA GİRİŞLERİ
HAVALE
EFT
ÇEK
KREDİ KARTI
POS
VB......
Teşekkürler
SELECT "Firma"='100', "Donem"='01', FIRM.NAME as Firma_Adı, L_CAPIDIV.NAME AS "ISYERI", L_CAPIDIV.NR AS "ISYERI_NO", L_CAPIDEPT.NAME AS "BOLUM", L_CAPIDEPT.NR AS "BOLUM_NO", KSCARD.NAME AS "KASA_ADI", KSCARD.CODE AS "KASA_KODU", KSCARD.EXPLAIN AS "KASA_ACIKLAMASI", KSLINES.DATE_ AS "TARIH", YEAR(KSLINES.DATE_) AS "YIL", AY=CASE MONTH(KSLINES.DATE_) WHEN 1 THEN '01_Ocak' WHEN 2 THEN '01_Şubat' WHEN 3 THEN '03_Mart' WHEN 4 THEN '04_Nisan' WHEN 5 THEN '05_Mayıs' WHEN 6 THEN '06_Haziran' WHEN 7 THEN '07_Temmuz' WHEN 8 THEN '08_Ağustos' WHEN 9 THEN '09_Eylül' WHEN 10 THEN '10_Ekim' WHEN 11 THEN '11_Kasım' WHEN 12 THEN '12_Aralık' END, -------------TL TUTARLAR KSLINES.AMOUNT AS "TUTAR", CASE KSLINES.SIGN WHEN 0 THEN KSLINES.AMOUNT ELSE 0 END AS "BORC", CASE KSLINES.SIGN WHEN 1 THEN KSLINES. AMOUNT ELSE 0 END AS "ALACAK", CASE KSLINES.SIGN WHEN 0 THEN KSLINES.AMOUNT ELSE KSLINES.AMOUNT*-1 END AS "TL_BAKIYE", ISNULL(L_CURRENCYLIST.CURCODE,'TL') AS "ISLEM_DOVIZ_TURU", ISNULL(L_CURRENCYLIST2.CURCODE,'TL') AS "KASA_DOVIZ_TURU", ISNULL(L_CURRENCYLIST.CURTYPE,0) AS CURTYPE, (CASE KSLINES.SIGN WHEN 1 THEN -1 ELSE 1 END)*(KSLINES.REPORTNET) AS "DOVIZ_BAKIYE", (CASE KSLINES.SIGN WHEN 1 THEN (CASE KSLINES.TRRATE WHEN 0 THEN KSLINES.AMOUNT ELSE KSLINES.TRNET END)*-1 ELSE (CASE KSLINES.TRRATE WHEN 0 THEN KSLINES.AMOUNT ELSE KSLINES.TRNET END) END) AS "ID_BAKIYE", (CASE KSLINES.SIGN WHEN 0 THEN 'BORC' ELSE 'ALACAK' END) AS "BORC_ALACAK", CASE KSLINES.TRRATE WHEN 0 THEN 'TL' ELSE L_CURRENCYLIST_2.CURCODE END AS "FIRMA_DOVIZ_TURU", KUR1=ISNULL((SELECT TOP 1 RATES1 AS "KUR1" FROM TIGER.[dbo].L_DAILYEXCHANGES EXCHANGE INNER JOIN TIGER.[dbo].L_CURRENCYLIST LISTE ON EXCHANGE.CRTYPE=LISTE.CURTYPE AND LISTE.FIRMNR='100' WHERE EDATE<=GETDATE() AND LISTE.CURTYPE=L_CURRENCYLIST.CURTYPE ORDER BY EDATE DESC),1), KSLINES.LOGICALREF AS KSLINES_LOGREF FROM TIGER.dbo.LG_100_01_KSLINES KSLINES (NOLOCK) LEFT JOIN TIGER.dbo.LG_100_PROJECT PROJECT (NOLOCK) ON KSLINES.PROJECTREF = PROJECT.LOGICALREF LEFT JOIN TIGER.dbo.LG_100_KSCARD KSCARD (NOLOCK) ON KSLINES.CARDREF = KSCARD.LOGICALREF LEFT JOIN TIGER.dbo.LG_100_KSCARD KSCARD_2 (NOLOCK) ON KSLINES.VCARDREF = KSCARD_2.LOGICALREF LEFT JOIN TIGER.dbo.LG_100_EMUHACC EMUHACC (NOLOCK) ON KSLINES.ACCREF = EMUHACC.LOGICALREF LEFT JOIN TIGER.[dbo].L_CURRENCYLIST L_CURRENCYLIST (NOLOCK) ON L_CURRENCYLIST.CURTYPE=KSLINES.TRCURR and L_CURRENCYLIST.FIRMNR='100' LEFT JOIN TIGER.[dbo].L_CURRENCYLIST L_CURRENCYLIST2 (NOLOCK) ON L_CURRENCYLIST2.CURTYPE=KSCARD.CCURRENCY and L_CURRENCYLIST2.FIRMNR='100' LEFT JOIN TIGER.[dbo].L_CAPIFIRM FIRM (NOLOCK) ON FIRM.NR='100' LEFT JOIN TIGER.[dbo].L_CURRENCYLIST L_CURRENCYLIST_2 (NOLOCK) ON L_CURRENCYLIST_2.CURTYPE=FIRM.LOCALCTYP and SEPEXCHTABLE=1 AND L_CURRENCYLIST_2.FIRMNR='100' LEFT JOIN TIGER.dbo.L_CAPIDIV L_CAPIDIV (NOLOCK) ON L_CAPIDIV.NR=KSLINES.BRANCH AND L_CAPIDIV.FIRMNR='100' LEFT JOIN TIGER.dbo.L_CAPIDEPT L_CAPIDEPT (NOLOCK) ON L_CAPIDEPT.NR=KSLINES.DEPARTMENT AND L_CAPIDEPT.FIRMNR='100' WHERE KSLINES.CANCELLED=0
Yukarıdaki sorgu ile kasada oluşan tüm hareketleri alabilirsiniz tüm detayı ile birlikte. Firma numarası 100 siz kendi firmanıza göre düzenlemelisiniz.
