logo go da çalışan cari hesap bakiye raporu go 3 geçişte çalışmıyor

[ALABANDA]

herkese merhabalar.
daha öncesinde log go da çalışan cari hesap bakiye raporu
go3 geçiş sonrasında herhangi bir hata vermiyor fakat güncel bakiyeyi getirmiyor

yardımlarınızdan dolayı şimdiden teşekürler

SELECT DISTINCT TOP (100) PERCENT CLC.CODE AS [Cari Kodu], CLC.DEFINITION_ AS [Cari Adı], CLC.CITY AS Şehir, CLC.TELNRS1 AS [Telefon 1],
                          (SELECT     ISNULL(ROUND(DEBIT, 2), 0) AS Expr1
                            FROM          dbo.LG_003_05_GNTOTCL
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Borç,
                          (SELECT     ISNULL(ROUND(CREDIT, 2), 0) AS Expr1
                            FROM          dbo.LG_003_05_GNTOTCL AS LG_003_05_GNTOTCL_2
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Alacak,
                          (SELECT     ISNULL(ROUND(DEBIT - CREDIT, 2), 0) AS Expr1
                            FROM          dbo.LG_003_05_GNTOTCL AS LG_003_05_GNTOTCL_1
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Bakiye, SUBSTRING(CLC.CODE, 1, 3) AS [Kod Grup]
FROM         dbo.LG_003_05_CLFLINE AS LGMAIN LEFT OUTER JOIN
                      dbo.LG_003_CLCARD AS CLC ON CLC.LOGICALREF = LGMAIN.CLIENTREF
WHERE     (CLC.CODE LIKE '%')
ORDER BY [Cari Adı]

[Hüseyin FERAHLI]

  Aşağıdaki şekilde çalıştırabilirsiniz.

SELECT DISTINCT TOP (100) PERCENT CLC.CODE AS [Cari Kodu], CLC.DEFINITION_ AS [Cari Adı], CLC.CITY AS Şehir, CLC.TELNRS1 AS [Telefon 1],
                          (SELECT     ISNULL(ROUND(DEBIT, 2), 0) AS Expr1
                            FROM          dbo.LV_003_05_GNTOTCL
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Borç,
                          (SELECT     ISNULL(ROUND(CREDIT, 2), 0) AS Expr1
                            FROM          dbo.LV_003_05_GNTOTCL AS LV_003_05_GNTOTCL_2
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Alacak,
                          (SELECT     ISNULL(ROUND(DEBIT - CREDIT, 2), 0) AS Expr1
                            FROM          dbo.LV_003_05_GNTOTCL AS LV_003_05_GNTOTCL_1
                            WHERE      (CARDREF = CLC.LOGICALREF) AND (TOTTYP = 1)) AS Bakiye, SUBSTRING(CLC.CODE, 1, 3) AS [Kod Grup]
FROM         dbo.LG_003_05_CLFLINE AS LGMAIN LEFT OUTER JOIN
                      dbo.LG_003_CLCARD AS CLC ON CLC.LOGICALREF = LGMAIN.CLIENTREF
WHERE     (CLC.CODE LIKE '%')
ORDER BY [Cari Adı]