<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.3.16" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="42676" ReportOptions.Description.Text="" ReportOptions.LastChange="42677,550421169" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="KullaniciQ" DataSetName="Alanlar"/>
  </Datasets>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="KullaniciQ" UserName="Alanlar" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select &#13;&#10;   'SATIŞ KDV' AS TIP, H.KDV AS KDVDILIMI, 0.000 AS KDVALACAK, SUM(H.KDVTUTARI) AS KDVBORC&#13;&#10; from TBLSATFATHAREKET H &#13;&#10; LEFT OUTER JOIN TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID &#13;&#10; WHERE ISNULL(B.DELETED, 0) = 0 AND H.KDV &#62; 0 AND B.YIL = DATEPART(Year, GETDATE()) and AY = :AY       &#13;&#10; GROUP BY H.KDV &#13;&#10; UNION ALL &#13;&#10; Select  &#13;&#10;   'ALIŞ KDV' AS TIP, H.KDV AS KDVDILIMI, SUM(H.KDVTUTARI) AS KDVTUTARI, 0.00 &#13;&#10; from TBLALFATHAREKET H &#13;&#10; LEFT OUTER JOIN TBLALFATBASLIK B WITH(INDEX=TBLALFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID &#13;&#10; WHERE ISNULL(B.DELETED, 0) = 0 AND H.KDV &#62; 0  AND B.YIL = DATEPART(Year, GETDATE()) and AY = :AY       &#13;&#10; GROUP BY H.KDV &#13;&#10;   " PropData="05704C656674038C000470546F7002400A506172616D65746572730101061F204E616D653D224159222044617461547970653D226674496E7465676572220001061F204E616D653D224159222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="115,11812" Left="0" Top="16" Width="793,7013">
      <TfrxMemoView Name="BASLIK" Left="57,67718" Top="6,22047" Width="640,39363" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="KDV RAPORU"/>
      <TfrxMemoView Name="TARIH" Left="700" Top="25" Width="125" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="101,77953" Width="800" Height="0" Color="0" Frame.Typ="4" Frame.Width="10"/>
      <TfrxMemoView Name="TIPBASLIK" Left="0" Top="75" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="KDV TÜRÜ"/>
      <TfrxMemoView Name="KDVDILIMIBASLIK" Left="108,77953" Top="75" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="KDV ORANI"/>
      <TfrxMemoView Name="KDVALACAKBASLIK" Left="206,22047" Top="75" Width="122,67718" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="ALIŞ KDV"/>
      <TfrxMemoView Name="KDVBORCBASLIK" Left="330,11812" Top="75" Width="107,55906" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="SATIŞ KDV"/>
      <TfrxMemoView Name="Memo1" Left="612,28386" Top="71,81107" Width="156,69295" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="SATIŞ KDV MATRAHI"/>
      <TfrxMemoView Name="Memo4" Left="445,98454" Top="71,81107" Width="160,47248" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="ALIS KDV MATRAHI"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="36,11812" Left="0" Top="152" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="TIPVIEW" Left="0" Top="0" Width="101,52668317" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Alanlar.&#34;TIP&#34;]"/>
      <TfrxMemoView Name="KDVDILIMIVIEW" Left="110,57152383" Top="0" Width="105,30621317" Height="23,77953" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;KDVDILIMI&#34;]"/>
      <TfrxMemoView Name="KDVALACAKVIEW" Left="221,14304766" Top="0" Width="105,30621317" Height="23,77953" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVALACAK&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[Alanlar.&#34;KDVALACAK&#34;]"/>
      <TfrxMemoView Name="KDVBORCVIEW" Left="331,71457149" Top="0" Width="105,30621317" Height="23,77953" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVBORC&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[Alanlar.&#34;KDVBORC&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="615,84780089" Top="0" Width="152,86662228" Height="23,77953" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVBORC&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[&#60;Alanlar.&#34;KDVBORC&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;]"/>
      <TfrxMemoView Name="Memo3" Left="446,03133772" Top="0" Width="156,64615228" Height="23,77953" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVALACAK&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[&#60;Alanlar.&#34;KDVALACAK&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;]"/>
      <TfrxLineView Name="Line1" Left="0" Top="30,23624" Width="800" Height="0" Color="0" Frame.Typ="4" Frame.Width="4"/>
      <TfrxLineView Name="Line2" Left="105,82684" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
      <TfrxLineView Name="Line3" Left="219,21274" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
      <TfrxLineView Name="Line4" Left="328,81911" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
      <TfrxLineView Name="Line5" Left="442,20501" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
      <TfrxLineView Name="Line6" Left="608,50433" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
      <TfrxLineView Name="Line7" Left="771,02412" Top="0" Width="0" Height="30,23624" Color="0" Frame.Width="3" Diagonal="True"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="142,04731" Left="0" Top="416" Width="793,7013">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="670" Top="10" Width="120" Height="25" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="188,9765" Left="0" Top="208" Width="793,7013">
      <TfrxMemoView Name="AlanlarKDVALACAK" Left="219,21274" Top="37,7953" Width="109,60637" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="AlanlarKDVBORC" Left="328,81911" Top="37,7953" Width="113,3859" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVBORC&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo5" Left="11,33859" Top="37,7953" Width="162,51979" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="TOPLAM                      :"/>
      <TfrxMemoView Name="Memo6" Left="445,98454" Top="37,7953" Width="156,64615228" Height="20" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVALACAK&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo7" Left="604,7248" Top="37,7953" Width="160,42568228" Height="20" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Alanlar.&#34;KDVALACAK&#34;&#62;=0" Highlight.FillType="ftBrush" Highlight.Visible="False" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVBORC&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;)]"/>
      <TfrxLineView Name="Line8" Left="0" Top="68,03154" Width="800" Height="0" Color="0" Frame.Typ="4" Frame.Width="10"/>
      <TfrxMemoView Name="Memo9" Left="241,88992" Top="139,84261" Width="181,41744" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;,MASTERDATA)]">
        <Highlights>
          <item Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Condition="SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;)&#60;0" FillType="ftGradient" Fill.StartColor="255" Fill.GradientStyle="gsHorizontal"/>
          <item Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Condition="SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;)&#62;0" FillType="ftGradient" Fill.StartColor="32768" Fill.GradientStyle="gsHorizontal"/>
        </Highlights>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo10" Left="170,07885" Top="90,70872" Width="253,22851" Height="49,13389" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="FATURALANDIRILABİLİR &#13;&#10;KDV TUTARI"/>
      <TfrxMemoView Name="Memo11" Left="532,91373" Top="139,84261" Width="162,51979" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;*100/&#60;Alanlar.&#34;KDVDILIMI&#34;&#62;,MASTERDATA)]">
        <Highlights>
          <item Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Condition="SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;)&#60;0" FillType="ftGradient" Fill.StartColor="255" Fill.GradientStyle="gsHorizontal"/>
          <item Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Condition="SUM(&#60;Alanlar.&#34;KDVALACAK&#34;&#62;-&#60;Alanlar.&#34;KDVBORC&#34;&#62;)&#62;0" FillType="ftGradient" Fill.StartColor="32768" Fill.GradientStyle="gsHorizontal"/>
        </Highlights>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo12" Left="476,22078" Top="90,70872" Width="215,43321" Height="37,7953" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="KESİLEBİLECEK FATURA TUTARI"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
