{"id":1848,"date":"2021-11-21T22:26:49","date_gmt":"2021-11-21T19:26:49","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1848"},"modified":"2021-11-25T21:58:07","modified_gmt":"2021-11-25T18:58:07","slug":"logo-yazilim-hangi-urun-kime-satilmis-raporu","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/logo-yazilim-hangi-urun-kime-satilmis-raporu\/","title":{"rendered":"Logo Yaz\u0131l\u0131m Hangi \u00dcr\u00fcn Kime Sat\u0131lm\u0131\u015f Raporu"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT\r\nCONVERT(nvarchar(20), INVOICE.DATE_,104) as Tarih,\r\n--INVOICE.DATE_ AS &#91;Tarih],\r\nCLCARD.CODE as &#91;Cari Kod],\r\nCLCARD.DEFINITION_ as &#91;Cari Ad],\r\nINVOICE.SERIALCODE &#91;Seri No],\r\nINVOICE.FICHENO &#91;Fi\u015f No],\r\nCOALESCE(\r\nCASE STLINE.UINFO1\r\nWHEN 0 THEN STLINE.AMOUNT\r\nELSE STLINE.AMOUNT*STLINE.UINFO2\/STLINE.UINFO1\r\nEND, STLINE.AMOUNT\/1000) &#91;Miktar],\r\nUNT.CODE &#91;Birim],\r\nCASE WHEN STLINE.LINETYPE=4 THEN SRV.CODE ELSE INV.CODE END AS &#91;Malzeme Kod],\r\nCASE WHEN STLINE.LINETYPE=4 THEN SRV.DEFINITION_ ELSE INV.NAME END AS &#91;Malzeme Ad],\r\nCASE WHEN STLINE.LINETYPE=4 THEN '' ELSE INV.STGRPCODE END AS &#91;Malzeme Grup],\r\nCASE WHEN STLINE.LINETYPE=4 THEN SRV.SPECODE ELSE INV.SPECODE END AS &#91;Malzeme \u00d6zel Kod],\r\nSTLINE.PRICE &#91;Birim Fiyat],\r\nSTLINE.VATMATRAH &#91;KDV Matrah],\r\nSTLINE.VATAMNT &#91;KDV Tutar],\r\nSTLINE.VAT &#91;KDV %],\r\n(CASE\r\nWHEN INVOICE.TRCODE=1 THEN 'Sat\u0131nalma Faturas\u0131'\r\nWHEN INVOICE.TRCODE=2 THEN 'Perakende Sat\u0131\u015f \u0130ade Faturas\u0131'\r\nWHEN INVOICE.TRCODE=3 THEN 'Toptan Sat\u0131\u015f \u0130ade Faturas\u0131'\r\nWHEN INVOICE.TRCODE=4 THEN 'Al\u0131nan Hizmet Faturas\u0131'\r\nWHEN INVOICE.TRCODE=5 THEN 'Al\u0131nan Proforma Faturas\u0131'\r\nWHEN INVOICE.TRCODE=6 THEN 'Sat\u0131nalma \u0130ade Faturas\u0131'\r\nWHEN INVOICE.TRCODE=7 THEN 'Perakende Sat\u0131\u015f Faturas\u0131'\r\nWHEN INVOICE.TRCODE=8 THEN 'Toptan Sat\u0131\u015f Faturas\u0131'\r\nWHEN INVOICE.TRCODE=9 THEN 'Verilen Hizmet Faturas\u0131'\r\nWHEN INVOICE.TRCODE=10 THEN 'Verilen Proforma Faturas\u0131'\r\nWHEN INVOICE.TRCODE=12 THEN 'Al\u0131nan Vade Fark\u0131 Faturas\u0131'\r\nWHEN INVOICE.TRCODE=13 THEN 'Sat\u0131nalma Fiyat Fark\u0131 Faturas\u0131'\r\nWHEN INVOICE.TRCODE=14 THEN 'Sat\u0131\u015f Fiyat Fark\u0131 Faturas\u0131'\r\nWHEN INVOICE.TRCODE=26 THEN 'M\u00fcstahsil Makbuzu' END\r\n) as &#91;Fatura Tipi],\r\nCASE WHEN CLCARD.ISPERSCOMP=1 THEN CLCARD.TCKNO ELSE CLCARD.TAXNR END AS &#91;Cari VNO],\r\nCLCARD.TAXOFFICE as &#91;Cari VDaire],\r\nEMUH.CODE as &#91;Muhasebe Hesap Plan\u0131 Kod],\r\nEMUH.DEFINITION_ as &#91;Muhasebe Hesap Plan\u0131 Ad],\r\nRTRIM(INVOICE.GENEXP1+' '+INVOICE.GENEXP2+' '+INVOICE.GENEXP3+' '+INVOICE.GENEXP4) AS &#91;A\u00e7\u0131klama]\r\nFROM LG_021_01_INVOICE AS INVOICE WITH (NOLOCK)\r\nRIGHT OUTER JOIN LG_021_01_STLINE AS STLINE ON INVOICE.LOGICALREF = STLINE.INVOICEREF\r\nRIGHT OUTER JOIN LG_021_ITEMS INV ON INV.LOGICALREF=STLINE.STOCKREF\r\nLEFT JOIN LG_021_SRVCARD SRV ON SRV.LOGICALREF=STLINE.STOCKREF\r\nRIGHT OUTER JOIN LG_021_CLCARD CLCARD ON CLCARD.LOGICALREF=INVOICE.CLIENTREF\r\nLEFT JOIN LG_021_EMUHACC EMUH ON EMUH.LOGICALREF=STLINE.ACCOUNTREF\r\nRIGHT OUTER JOIN LG_021_UNITSETL UNT ON UNT.UNITSETREF=INV.UNITSETREF AND LINENR=1\r\nWHERE(INVOICE.TRCODE IN(2,3,7,8,9,10,14))\r\n--AND INVOICE.DATE_ >= '2020-01-01 00:00:00.000'\r\n--AND INVOICE.DATE_ &lt;= '2020-12-31 23:59:59.999'\r\nORDER BY INVOICE.DATE_,\r\nINVOICE.SOURCEINDEX,\r\nINVOICE.FICHENO<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1842,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[75],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1848"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1848"}],"version-history":[{"count":3,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1848\/revisions"}],"predecessor-version":[{"id":1857,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1848\/revisions\/1857"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media\/1842"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}