herkes ekolay gelsin.
benim şöyle bir raporum var.
ksıaca kasa ekstresini sql de alıyorum.
eklemek istediğim şey ise;
kasadan kapatılan satış faturasınını numarasını ekstreye yazdırmak.
olurmu bilmiyorum ama.
inşallah oluyordur..
şimdiden herkese tşk.
SELECT dbo.LG_001_KSCARD.NAME AS KasaKartiAciklama,
dbo.LG_001_05_KSLINES.DATE_ AS Tarih,
CASE TRCODE
WHEN 11 THEN 'CH Tahsilat'
WHEN 12 THEN 'CH Ödeme'
WHEN 21 THEN 'Bankaya Yatırılan'
WHEN 22 THEN 'Bankadan Çekilen'
WHEN 31 THEN 'Satınalma Faturası'
WHEN 34 THEN 'Alınan Hizmet'
WHEN 64 THEN 'Senet Ödemesi'
End AS [İşlem Türü],
dbo.LG_001_05_KSLINES.SPECODE AS [Ozel Kod],
dbo.LG_001_05_KSLINES.CYPHCODE AS [Yetki Kodu],
dbo.LG_001_05_KSLINES.CUSTTITLE AS [Kasa Aciklamasi],
dbo.LG_001_05_KSLINES.LINEEXP AS [Satir Aciklamasi],
dbo.LG_001_05_KSLINES.TRNET * dbo.LG_001_05_KSLINES.SIGN AS ALACAK,
dbo.LG_001_05_KSLINES.TRNET - dbo.LG_001_05_KSLINES.TRNET * dbo.LG_001_05_KSLINES.SIGN AS BORC
FROM dbo.LG_001_05_KSLINES LEFT OUTER JOIN
dbo.LG_001_KSCARD ON dbo.LG_001_05_KSLINES.CARDREF = dbo.LG_001_KSCARD.LOGICALREF LEFT OUTER JOIN
dbo.LG_001_KSCARD LG_001_KSCARD_1 ON dbo.LG_001_05_KSLINES.VCARDREF = LG_001_KSCARD_1.LOGICALREF LEFT OUTER JOIN
dbo.LG_001_EMUHACC ON dbo.LG_001_05_KSLINES.ACCREF = dbo.LG_001_EMUHACC.LOGICALREF LEFT OUTER JOIN
dbo.LG_001_EMUHACC LG_001_EMUHACC_1 ON dbo.LG_001_05_KSLINES.CSACCREF = LG_001_EMUHACC_1.LOGICALREF LEFT OUTER JOIN
dbo.LG_001_EMCENTER ON dbo.LG_001_05_KSLINES.CENTERREF = dbo.LG_001_EMCENTER.LOGICALREF LEFT OUTER JOIN
dbo.LG_001_EMCENTER LG_001_EMCENTER_1 ON
dbo.LG_001_05_KSLINES.CSCENTERREF = LG_001_EMCENTER_1.LOGICALREF
WHERE (DATE_ >= CONVERT(DATETIME, '2020-07-16 00:00:00', 102))
ORDER BY dbo.LG_001_05_KSLINES.DATE_, dbo.LG_001_05_KSLINES.SIGN, dbo.LG_001_KSCARD.CODE