SQL Sorgu İşlem Dövizine Göre Mizan

Merhaba,

Aşağıda ay bazında Borç, Alacak ve Bakiye olarak kullandığım Mizan Sql sorgusu mevcut

SELECT ACCOUNTCODE AS HesapKodu, CASE LG_025_01_EMFLINE.MONTH_ WHEN 1 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Ocak2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 1 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Ocak2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 1 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Ocak2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 2 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Subat2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 2 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Subat2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 2 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Subat2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 3 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Mart2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 3 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Mart2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 3 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Mart2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 4 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Nisan2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 4 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Nisan2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 4 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Nisan2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 5 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Mayıs2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 5 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Mayıs2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 5 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Mayıs2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 6 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Haziran2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 6 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Haziran2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 6 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Haziran2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 7 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Temmuz2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 7 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Temmuz2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 7 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Temmuz2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 8 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Ağustos2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 8 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Ağustos2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 8 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Ağustos2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 9 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Eylül2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 9 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Eylül2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 9 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Eylül2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 10 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Ekim2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 10 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Ekim2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 10 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Ekim2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 11 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Kasım2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 11 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Kasım2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 11 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Kasım2025_Bakiye, CASE LG_025_01_EMFLINE.MONTH_ WHEN 12 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END))
ELSE 0 END AS Aralık2025_Borc, CASE LG_025_01_EMFLINE.MONTH_ WHEN 12 THEN (SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END))
ELSE 0 END AS Aralık2025_Alacak,
CASE LG_025_01_EMFLINE.MONTH_ WHEN 12 THEN (SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END))
ELSE 0 END AS Aralık2025_Bakiye, SUM(CASE WHEN SIGN = 0 THEN DEBIT ELSE 0 END) AS [2025_Borc], SUM(CASE WHEN SIGN = 1 THEN CREDIT ELSE 0 END)
AS [2025_Alacak], SUM(CASE WHEN SIGN = 0 THEN DEBIT WHEN SIGN = 1 THEN CREDIT * - 1 ELSE 0 END) AS [2025_Bakiye]
FROM dbo.LG_025_01_EMFLINE
WHERE (KEBIRCODE BETWEEN '100' AND '999') AND CANCELLED=0
GROUP BY ACCOUNTCODE, MONTH_


işlem dövizi olarak ta Borç, Alacak ve bakiye nasıl sorguda kullanabiliriz. Daha önce böyle bir çalışma yapan arkadaşlardan rica ediyorum.

WITH AYLAR AS (
SELECT
ACCOUNTCODE AS HesapKodu,
LIST.CURCODE,
MONTH_,
SUM(CASE WHEN SIGN = 0 THEN TRNET ELSE 0 END) AS Borc,
SUM(CASE WHEN SIGN = 1 THEN TRNET ELSE 0 END) AS Alacak,
SUM(CASE WHEN SIGN = 0 THEN TRNET ELSE 0 END) -
SUM(CASE WHEN SIGN = 1 THEN TRNET ELSE 0 END) AS Bakiye
FROM
LG_006_01_EMFLINE LINE INNER JOIN LG_006_01_EMFICHE FIC ON FIC.LOGICALREF = LINE.ACCFICHEREF
LEFT JOIN L_CURRENCYLIST LIST ON LIST.CURTYPE = CASE WHEN LINE.TRCURR IN (0) THEN 160 ELSE LINE.TRCURR END AND LIST.FIRMNR = '006'
WHERE LINE.CANCELLED=0
GROUP BY
ACCOUNTCODE, MONTH_,LIST.CURCODE
)
SELECT
HesapKodu,
CURCODE,
SUM(CASE WHEN MONTH_ = 1 THEN Borc ELSE 0 END) AS Ocak2025_Borc,
SUM(CASE WHEN MONTH_ = 1 THEN Alacak ELSE 0 END) AS Ocak2025_Alacak,
SUM(CASE WHEN MONTH_ <= 1 THEN Bakiye ELSE 0 END) AS Ocak2025_Bakiye,
SUM(CASE WHEN MONTH_ = 2 THEN Borc ELSE 0 END) AS Subat2025_Borc,
SUM(CASE WHEN MONTH_ = 2 THEN Alacak ELSE 0 END) AS Subat2025_Alacak,
SUM(CASE WHEN MONTH_ <= 2 THEN Bakiye ELSE 0 END) AS Subat2025_Bakiye,
SUM(CASE WHEN MONTH_ = 3 THEN Borc ELSE 0 END) AS Mart2025_Borc,
SUM(CASE WHEN MONTH_ = 3 THEN Alacak ELSE 0 END) AS Mart2025_Alacak,
SUM(CASE WHEN MONTH_ <= 3 THEN Bakiye ELSE 0 END) AS Mart2025_Bakiye

FROM
AYLAR
GROUP BY
HesapKodu,CURCODE