Selam arkadaşım,
Bende aşağıdaki gibi bir kod var ve işime yarıyor sanırım seninde işini görür. Kodun içindeki MONTH<4 ayarını istediğin dönem olarak değiştirisin. Bu Kod Mart sonu itibariyle çalışıyor.
SELECT (SELECT CODE FROM LG_312_CLCARD WHERE LOGICALREF=C.CARDREF) AS [Cari Kodu],
(SELECT DEFINITION_ FROM LG_312_CLCARD WHERE LOGICALREF=C.CARDREF) AS [Cari Ünvanı],
(SELECT CODE FROM LG_312_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AS [Muhasebe Kodu],
(SELECT DEFINITION_ FROM LG_312_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AS [Muhasebe Ünvanı],
(SELECT SUM(DEBIT-CREDIT) FROM LG_312_01_CLTOTFIL WHERE CARDREF IN (SELECT LOGICALREF FROM LG_312_CLCARD WHERE LOGICALREF=C.CARDREF) AND TOTTYP=1 AND MONTH_<4) AS [Finans Bakiye],
(SELECT SUM(DEBIT-CREDIT) FROM LG_312_01_EMUHTOT WHERE ACCOUNTREF IN (SELECT LOGICALREF FROM LG_312_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AND TOTTYPE=1 AND BRANCH =-1 AND DEPARTMENT =-1 AND MONTH_ <4) AS [Muhasebe Bakiye],
(SELECT SUM(DEBIT-CREDIT) FROM LG_312_01_CLTOTFIL WHERE CARDREF IN (SELECT LOGICALREF FROM LG_312_CLCARD WHERE LOGICALREF=C.CARDREF) AND TOTTYP=1 AND MONTH_<4)-(SELECT SUM(DEBIT-CREDIT) FROM LG_312_01_EMUHTOT WHERE ACCOUNTREF IN (SELECT LOGICALREF FROM LG_312_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AND TOTTYPE=1 AND BRANCH =-1 AND DEPARTMENT =-1 AND MONTH_ <4) AS [Fark]
FROM LG_312_CRDACREF C WHERE TRCODE=5 AND CARDREF IN (SELECT LOGICALREF FROM LG_312_CLCARD WHERE ACTIVE=0 AND CARDTYPE<4)
