In this topic, you have an additional question to my post earlier.
One prepaid order exists.
Is there a payment plan installment of order 8.
that is, when the order and INVOICE SEPARATELY SHOULD be due for 8 pieces.
Prepaid order as you add, add up the INVOICES in reference to PAYTRANS table.
However, the customer's payment tools have ...Credit card, money transfer, etc.
Come into our bank account, we know that an instalment order of each of the said remittances.
This is further; I write a CURSOR to exist in each order instalment I got to.
FATURA_DURUMU column :
1.FATURA KESILMIS - 1.Invoice attached.
2.FATURA KESILMIS - 2.Invoice attached.
3.FATURA KESILMIS - 3.Invoice attached.
4.FATURA KESILMIS - 4.Invoice attached.
5.FATURA KESILMIS - 5.Invoice attached.
6.FATURA KESILMIS - 6.Invoice attached.
7.FATURAYI KES - 7. Add invoice.
8.FATURAYI KES - 8. Add invoice.
USE test1
DECLARE @FATURA_SAY INT
SELECT
CONVERT(VARCHAR,PT.DATE_,104)'Vade Tarihi',
CC.CODE CARI_KOD,
CC.DEFINITION_ ÜNVAN,
CASE(PT.MODULENR)
WHEN 3 THEN'SIPARIS'
WHEN 4 THEN'FATURA'
WHEN 5 THEN'CARI FIS'
WHEN 6 THEN'Çek - Senet'
WHEN 7 THEN'BANKA'
WHEN 10 THEN'KASA'
ELSE 'DIGER'
END 'TÜR',
--C.MODULENR, --Bu satir Pasif Yapilabilir.
CASE
WHEN (PT.MODULENR=4) AND (PT.TRCODE=2) THEN 'PER.SATIS.IADE.FTR'
WHEN (PT.MODULENR=5) AND (PT.TRCODE=3) THEN 'BORÇ DEKONTU'
WHEN (PT.MODULENR=7) AND (PT.TRCODE=3) THEN 'Gelen Havale'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) THEN 'SATIS SIPARISI'
END 'Fis Türü',
PT.DOCODE [Belge No],
PT.MODULENR MODÜL,
PT.TRCODE 'TRCODE',
CASE
WHEN PT.SIGN ='1' THEN 'ALACAK'
WHEN PT.SIGN ='0' THEN 'BORÇ'
END DURUM,
CASE
WHEN MONTH(PT.DISCDUEDATE)= '1' THEN 'Ocak'
WHEN MONTH(PT.DISCDUEDATE)= '2' THEN 'Subat'
WHEN MONTH(PT.DISCDUEDATE)= '3' THEN 'Mart'
WHEN MONTH(PT.DISCDUEDATE)= '4' THEN 'Nisan'
WHEN MONTH(PT.DISCDUEDATE)= '5' THEN 'Mayis'
WHEN MONTH(PT.DISCDUEDATE)= '6' THEN 'Haziran'
WHEN MONTH(PT.DISCDUEDATE)= '7' THEN 'Temmuz'
WHEN MONTH(PT.DISCDUEDATE)= '8' THEN 'Agustos'
WHEN MONTH(PT.DISCDUEDATE)= '9' THEN 'Eylül'
WHEN MONTH(PT.DISCDUEDATE)= '10' THEN 'Ekim'
WHEN MONTH(PT.DISCDUEDATE)= '11' THEN 'Kasim'
WHEN MONTH(PT.DISCDUEDATE)= '12' THEN 'Aralik'
END AY,
PT.TRCODE FIS_TÜRÜ,
SUM(PT.TOTAL) TUTAR,
PT.PAID AS KAPANAN,
SUM(PT.TOTAL)-PT.PAID AS FARK,
CASE
WHEN (PT.MODULENR<>3) AND (PT.TRCODE<>1) AND (SUM(PT.TOTAL)-PT.PAID<>0) THEN 'AÇIK ISLEM KONTROL ET'
WHEN (PT.MODULENR<>3) AND (PT.TRCODE<>1) AND (SUM(PT.TOTAL)-PT.PAID=0) THEN 'MANUEL KAPATILMIS'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) AND (SUM(PT.TOTAL)-PT.PAID=0) THEN 'FATURA KESILMIS'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) AND (SUM(PT.TOTAL)-PT.PAID>0) THEN 'FATURAYI KES'
END FATURA_DURUMU,
PT.FICHEREF AS [Fis Referansi]
FROM LG_011_01_PAYTRANS AS PT
INNER JOIN LG_011_CLCARD AS CC
ON PT.CARDREF = CC.LOGICALREF
WHERE CC.DEFINITION_ LIKE 'Ersoy AYDIN'
GROUP BY
CC.CODE,
PT.TRCODE,
PT.DISCDUEDATE,
PT.TOTAL,
CC.DEFINITION_,
PT.MODULENR,
PT.SIGN,
PT.DATE_,
PT.DOCODE,
PT.PAID,
PT.FICHEREF
ORDER BY PT.DATE_