Bu hata kötü olmuş, ben 2.42 kullanıyorum.
Aşağıdaki gibi de rapor üretici ile oluşturduğum "Sipariş Karşılama Analizi" raporum var.
Eğer hareketlerin listeleneceği bir rapor gerekiyorsa bir dene bakalım bu rapor da patlayacak mı ?
SELECT
SIP.DATE_ AS 'Sipariş Tarihi',
PLN.[DATE_] AS 'Ödeme TARİHİ',
DAY(PLN.[DATE_])AS 'GÜN',
MONTH(PLN.[DATE_]) AS 'AY',
YEAR(PLN.[DATE_]) AS 'YIL',
CC.CODE AS 'CH Kodu',
CC.DEFINITION_ AS 'Ünvanı'
,CC.TRADINGGRP AS 'CC T.İ.G'
,SIP.TRADINGGRP AS 'SİP T.İ.G'
,PLN.[FICHEREF] As 'Sipariş Referansı'
,SIP.SPECODE As 'Sip.ÖK'
,SIP.FICHENO As 'Sip.No'
,SIP.DOCODE As 'Sip.Belge No'
,CASE WHEN (FAT.[FICHENO] IS NULL) THEN '0' WHEN (FAT.[FICHENO] IS NOT NULL) THEN FAT.[FICHENO] END AS 'Fatura No'
,PLN.[TRCODE]
,PLN.[TOTAL]/1.08 AS 'PLN Taksit Tutarı KDV HARİÇ'
,(PLN.[TOTAL]-(PLN.[TOTAL]/1.08)) AS 'PLN KDV Tutarı'
,PLN.[TOTAL] AS 'PLN Taksit Tutarı KDV DAHİL'
,CASE WHEN (FAT.[NETTOTAL] IS NULL) THEN '0' WHEN (FAT.[NETTOTAL] IS NOT NULL) THEN FAT.[NETTOTAL] END AS 'Kesilen.Fat.Tut KDV DAHİL'
,CASE WHEN (PLN.[TOTAL]- FAT.[NETTOTAL] IS NOT NULL) THEN '0' WHEN (PLN.[TOTAL]- FAT.[NETTOTAL] IS NULL) THEN 'Faturalanmamış' END AS 'FARK'
,CASE WHEN (FAT.[TOTALVAT] IS NULL) THEN '0' WHEN (FAT.[TOTALVAT] IS NOT NULL) THEN FAT.[TOTALVAT] END AS 'Kesilen KDV'
,CASE WHEN (FAT.[TOTALVAT] IS NOT NULL) THEN '0' WHEN (FAT.[TOTALVAT]IS NULL) THEN ROUND((PLN.[TOTAL]-(PLN.[TOTAL]/1.08)),2) END AS 'KesileCEK KDV'
,PLN.[CANCELLED] As 'İPTAL Durumu'
,PLN.[MODIFIED] AS 'Değiştiren'
,WH.NAME AS 'OKUL'
,PLN.[PAYNO] AS 'Öd.Pln.Satırı'
,CASE WHEN (FAT.[TRACKNR] IS NULL) THEN 'Faturalanmamış' WHEN (FAT.[TRACKNR] IS NOT NULL) THEN FAT.[TRACKNR] END AS 'FAT.SIRA.NO'
FROM
LG_114_01_PAYTRANS AS PLN LEFT OUTER JOIN
LG_114_CLCARD CC ON CC.LOGICALREF = PLN.CARDREF LEFT OUTER JOIN
LG_114_01_INVOICE AS FAT ON PLN.FICHEREF=FAT.DOCTRACKINGNR AND FAT.TRACKNR=PLN.PAYNO LEFT OUTER JOIN
LG_114_01_ORFICHE AS SIP ON PLN.FICHEREF=SIP.LOGICALREF
LEFT OUTER JOIN L_CAPIWHOUSE AS WH ON SIP.BRANCH=WH.NR
Where MODULENR=3 AND WH.FIRMNR='114'