Cari Hesap Muavini Karşılaştırlması Listesi
Logo Yazılım dan Sql Managent tarafından Cari Hesap Muavini Karşılaştırlması Listesi için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT (SELECT CODE FROM LG_001_CLCARD WHERE LOGICALREF=C.CARDREF) AS [Cari Kodu], (SELECT DEFINITION_ FROM LG_001_CLCARD WHERE LOGICALREF=C.CARDREF) AS [Cari Ünvanı], (SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AS [Muhasebe Kodu], (SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AS [Muhasebe Ünvanı], (SELECT CONVERT(money,SUM(DEBIT-CREDIT)) FROM LV_001_01_CLTOTFIL WHERE CARDREF IN (SELECT LOGICALREF FROM LG_001_CLCARD WHERE LOGICALREF=C.CARDREF) AND TOTTYP=1 AND MONTH_<13) AS [Cari Bakiye], (SELECT CONVERT(money,SUM(DEBIT-CREDIT)) FROM LV_001_01_EMUHTOT WHERE ACCOUNTREF IN (SELECT LOGICALREF FROM LG_001_EMUHACC WHERE LOGICALREF=C.ACCOUNTREF) AND TOTTYPE=1 AND BRANCH IN (0,1) AND DEPARTMENT IN (0,1) AND MONTH_ <13-1) AS [Muhasebe Bakiye] FROM LG_001_CRDACREF C WHERE TRCODE=5 AND CARDREF IN (SELECT LOGICALREF FROM LG_001_CLCARD WHERE ACTIVE=0 AND CARDTYPE<4 And CODE Between '' And 'ZZZZZZZZZZZZZZZZ') |
Paylaş:
