SELECT STOK.STOKID, STOKGRUP.ADI AS GADI, SFIYAT1,STOK.GRUP, STOK.KODU, RNO,OPTMIKTAR,STOK.ADI, STOK.SSATICI, STOK.SALISFIYAT, STOK.SFATURANO, STOK.SFATTARIHI, ((SFIYAT1)*(100-STOK.ALISIND)/100) AS ALIS, ((SFIYAT1)*(100-STOK.AMIKTAR)/100) AS AALIS, SKARY,SATISIND, ((SFIYAT1)*(100-SATISIND)*(100+SKARY)/10000) AS SATIS, ((SATIS)*1.025) AS SATIS1,((SATIS)*1.05) AS SATIS2,((SATIS)*1.075) AS SATIS3, ((SATIS)*1.01) AS SATIS4,SATISKDV,SATIS*(100+SATISKDV)/100 AS KSATIS,SATIS1*(100+SATISKDV)/100 AS AKDVS, STOK.SDOVIZ AS DV, (SELECT TOP 1 KUR2 FROM DOVIZISL WHERE DOVIZISL.KODU=STOK.SDOVIZ ORDER BY TARIH DESC) AS SATISKUR, KSATIS*SATISKUR AS SATISTL,SATIS*SATISKUR AS KDVSIZTL,AKDVS*SATISKUR AS ASATISTL, (SELECT SUM(ADET) FROM FATISL WHERE FATISL.STOKID=STOK.STOKID) AS BAKIYE, STOK.BIRIM AS B, BAKIYE*KATSAYI2 AS BAKIYE2, STOK.BIRIM2, STOK.KATSAYI2 AS KATSAYI, (SATIS-ALIS)*BAKIYE AS KAR, (SELECT TOP 1 KUR2 FROM DOVIZISL WHERE DOVIZISL.KODU=STOK.SDOVIZ ORDER BY TARIH DESC) AS MBKUR, CARI.KODU AS SATICI, STOK.EK1  FROM (STOKGRUP RIGHT JOIN STOK ON STOKGRUP.KODU = STOK.GRUP) LEFT JOIN CARI ON STOK.SSATICI = CARI.CARIID WHERE SSATICI=10 ORDER BY STOK.KODU


Elektra
                                                                              Tarih       : [BUGUN   ]
                                                                              Saat        :   [BUSAAT]
                                                                              Alındığı T. : [GTARIH  ]

                                        HADDE URUNLERI VE SACLAR SATIS LISTESI 


  KODU   URUN ADI                     P.SATIS F. DVZ/BRM   15G SATIS F. 30G SATIS F. 45G SATIS F. 60G SATIS F. P.SATIS (TL) P.SATIS (TL)KDVLI      
  ------ ---------------------------- ---------- --------- ------------ ------------ ------------ ------------ ------------ -----------------
{ [KODU] [ADI                       ] [>SATIS:N] [>DV]/[B] [>SATIS1:N ] [>SATIS2:N ] [>SATIS3:N ] [>SATIS4:N ] [>KDVSIZTL ][>SATISTL:N   ]TL}
