SELECT
GLACC.CODE,GLACC.DEFINITION_ ,
ISNULL (FORMAT(SUM(GLTRN.DEBIT),'##,##0.00'),0) AS BORC,
ISNULL (FORMAT(SUM(GLTRN.CREDIT),'##,##0.00'),0) AS ALACAK,
--ISNULL (CONVERT(NUMERIC(15,2),SUM(GLTRN.CREDIT)),0) AS ALACAK ,
--SELECT CONVERT( numeric(10,2), 5634.6334) as number
--ISNULL(SUM(GLTRN.CREDIT),0) AS ALACAK,
--ISNULL (SUM(GLTRN.DEBIT),0)-ISNULL (SUM(GLTRN.CREDIT),0) AS BAKIYE
ISNULL (FORMAT((SUM (GLTRN.DEBIT)-SUM(GLTRN.CREDIT)),'##,##0.00'),0) AS BAKIYE
FROM
LG_049_EMUHACC GLACC WITH(NOLOCK) LEFT OUTER JOIN LG_049_01_EMFLINE GLTRN WITH(NOLOCK) ON (GLACC.LOGICALREF = GLTRN.ACCOUNTREF)
WHERE
(
(GLACC.CODE LIKE '120.10%')
OR (GLACC.CODE LIKE '120.11%')
OR (GLACC.CODE LIKE '120.20%')
OR (GLACC.CODE LIKE '120.30%')
OR (GLACC.CODE LIKE '120.40%')
OR (GLACC.CODE LIKE '120.41%')
OR (GLACC.CODE LIKE '120.42%')
OR (GLACC.CODE LIKE '320%' )
OR (GLACC.CODE LIKE '329%' ) )
AND ((GLTRN.DATE_ >= CONVERT(dateTime, '1-1-2023', 101)) AND (GLTRN.DATE_ <= CONVERT(dateTime, '12-31-2023', 101)))
AND (GLTRN.TRCODE IN (1,2,3,4,6,7))
AND (GLTRN.BRANCH IN (0))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.STATUS = 0)
AND (GLTRN.DEPARTMENT IN (0))
GROUP BY GLACC.CODE,GLACC.DEFINITION_ ORDER BY GLACC.CODE
İki Tarih arası Muhasebe bakiye raporu
Bir Cevap Yazın