Alacak Bakiyeli Cari Listesi
Logo Yazılım dan Sql Managent tarafından Alacak Bakiyeli Cari Listesi için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT LG_001_CLCARD.CODE AS Kod, LG_001_CLCARD.DEFINITION_ AS Unvan, SUM((1 - LG_001_01_CLFLINE.SIGN) * LG_001_01_CLFLINE.AMOUNT) - SUM(LG_001_01_CLFLINE.SIGN * LG_001_01_CLFLINE.AMOUNT) AS Bakiye, LG_001_CLCARD.ADDR1 AS Adres1, LG_001_CLCARD.ADDR2 AS Adres2, LG_001_CLCARD.DISTRICT AS Semt, LG_001_CLCARD.TOWN AS ilce, LG_001_CLCARD.CITY AS Sehir, LG_001_CLCARD.TELNRS1 AS Telefon1, LG_001_CLCARD.TELNRS2 AS Telefon2, LG_001_CLCARD.ACTIVE AS Statusu FROM LG_001_01_CLFLINE LG_001_01_CLFLINE INNER JOIN LG_001_CLCARD LG_001_CLCARD ON LG_001_01_CLFLINE.CLIENTREF = LG_001_CLCARD.LOGICALREF AND LG_001_01_CLFLINE.CANCELLED = 0 GROUP BY LG_001_CLCARD.CODE, LG_001_CLCARD.DEFINITION_, LG_001_CLCARD.ADDR1, LG_001_CLCARD.ADDR2, LG_001_CLCARD.CITY, LG_001_CLCARD.TELNRS1, LG_001_CLCARD.TELNRS2, LG_001_CLCARD.TOWN, LG_001_CLCARD.DISTRICT, LG_001_CLCARD.ACTIVE HAVING (LG_001_CLCARD.ACTIVE = 0 And (SUM((1 - LG_001_01_CLFLINE.SIGN) * LG_001_01_CLFLINE.AMOUNT) - SUM(LG_001_01_CLFLINE.SIGN * LG_001_01_CLFLINE.AMOUNT)) < 0) ORDER BY Unvan Asc |
Paylaş:
