Selamlar, aşağıda kullanmış olduğumuz raporda cari hesabın hangi satış elemanına bağlı olduğunu görebilir miyiz?
satıcı-cari tablosuna bağlantı mı gerekiyor yoksa sadece slsman yeterli olur mu? denedim fakat yapamadım, yardımcı olabilir misin?
SELECT DISTINCT CLNTC.LOGICALREF,CLNTC.CODE, CLNTC.SPECODE2, CLNTC.DEFINITION_,ISNULL(CLNUM.REPRISKTOTAL,0) AS REPRISKTOTAL,ISNULL(GNCLTOT.DEBIT,0) AS DEBIT,ISNULL( GNCLTOT.CREDIT,0) AS CREDIT,(ISNULL(GNCLTOT.DEBIT,0)-ISNULL( GNCLTOT.CREDIT,0)) AS BAKIYE FROM LG_012_CLCARD CLNTC LEFT OUTER JOIN LG_012_01_CLRNUMS CLNUM WITH(NOLOCK) ON (CLNTC.LOGICALREF = CLNUM.CLCARDREF) LEFT OUTER JOIN LG_012_01_GNTOTCL GNCLTOT WITH(NOLOCK) ON (CLNTC.LOGICALREF = GNCLTOT.CARDREF) AND (GNCLTOT.TOTTYP = 1) LEFT OUTER JOIN LG_012_01_GNTOTCL GENCLTOTR WITH(NOLOCK) ON (CLNTC.LOGICALREF = GENCLTOTR.CARDREF) AND (GENCLTOTR.TOTTYP = 2) WHERE (CLNTC.CODE LIKE '120%') AND (CLNTC.CARDTYPE <> 22) AND (CLNTC.ACTIVE=0) ORDER BY CLNTC.DEFINITION_