SQL Sorgu MALZEME SATIŞ EKSTESİ

SELECT
INV.FICHENO AS FaturaNo,
CAST(INV.DATE_ AS DATE) AS FaturaTarihi, -- sadece tarih
C.CODE AS CariKodu,
C.DEFINITION_ AS CariAdi,
I.CODE AS MalzemeKodu,
I.NAME AS MalzemeAdi,
S.AMOUNT AS Miktar,
S.PRICE AS BirimFiyat,
(S.AMOUNT * S.PRICE) AS Tutar,
P.CODE AS OdemePlani,
CAST(PT.DISCDUEDATE AS DATE) AS VadeTarihi -- sadece tarih
FROM LG_222_01_STLINE S
INNER JOIN LG_222_ITEMS I ON I.LOGICALREF = S.STOCKREF
INNER JOIN LG_222_01_INVOICE INV ON INV.LOGICALREF = S.INVOICEREF
INNER JOIN LG_222_CLCARD C ON C.LOGICALREF = INV.CLIENTREF
LEFT JOIN LG_222_PAYPLANS P ON P.LOGICALREF = INV.PAYDEFREF
LEFT JOIN LG_222_01_PAYTRANS PT ON PT.FICHEREF = INV.LOGICALREF
WHERE S.LINETYPE = 0 -- sadece malzeme satırları
AND INV.TRCODE = 8 -- 8 = satış faturası
AND S.CANCELLED = 0
AND INV.CANCELLED = 0
AND CAST(INV.DATE_ AS DATE) BETWEEN '2025-09-24' AND '2025-09-24'
ORDER BY INV.DATE_, INV.FICHENO;



BU SORGUYA SATIR KDV ORANI, SATIR KDV TUTARI VE SATIR NET TUTARI EKLEYEBİLİRMİYİZ

Sorguyu bu şekilde değiştirip kullanabilirsiniz;