Çözüldü muhasebe mahsup fişleri cari kod bağlantı

SELECT

EMU.CODE AS [Hesap Kodu],
EMU.DEFINITION_ AS [Hesap Adı],
EMF.JOURNALNO [Yevmiye No],
EMFL.DATE_ AS [Tarih],
EMFL.LINEEXP [İşlem Açıklaması],
EMF.LOGICALREF,
CASE EMF.TRCODE WHEN 1 THEN 'Açılış' WHEN 2 THEN 'Tahsil' WHEN
3 THEN 'Tediye' WHEN 4 THEN 'Mahsup' WHEN 5 THEN 'Özel Fiş' WHEN
6 THEN 'Kur Farkı' WHEN 7 THEN 'Kapanış' ELSE 'Diğer' END AS [Fiş Türü],

EMF.FICHENO AS [Fiş Numarası],
CLCARD.CODE AS carikod,
CLCARD.TAXNR AS vergino,
CLCARD.TCKNO AS tckn,

CASE EMFL.SIGN WHEN 0 THEN EMFL.DEBIT ELSE '' END AS [Borç ],
CASE EMFL.SIGN WHEN 1 THEN EMFL.CREDIT ELSE '' END AS [Alacak ]

FROM dbo.LG_006_01_EMFLINE AS EMFL WITH (NOLOCK) LEFT OUTER JOIN LG_006_01_EMFICHE AS EMF WITH (NOLOCK)
ON EMFL.ACCFICHEREF=EMF.LOGICALREF
LEFT JOIN LG_006_EMUHACC AS EMU WITH (NOLOCK)
LEFT JOIN LG_006_EMUHACC AS EM2 WITH (NOLOCK)
ON LEFT(EMU.CODE,3)= EM2.CODE
ON EMU.LOGICALREF = EMFL.ACCOUNTREF LEFT JOIN L_CAPIDIV AS CP
ON EMF.BRANCH = CP.NR
LEFT JOIN LG_006_01_GUARANTOR AS GUARANTOR  WITH (NOLOCK) ON GUARANTOR.FICHEREF=EMF.LOGICALREF
LEFT JOIN LG_006_CLCARD AS CLCARD  WITH (NOLOCK) ON CLCARD.LOGICALREF=GUARANTOR.CLIENTREF
WHERE (EMFL.CANCELLED = 0)
AND EMU.SUBACCOUNTS =0 AND CP.FIRMNR = 006 AND
MONTH (EMFL.DATE_) IN (1,2,3,4,5,6,7,8,9,10,11,12)