<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.2.3" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41391,8924728009" ReportOptions.Description.Text="" ReportOptions.LastChange="42147,8742435995" ScriptLanguage="PascalScript" ScriptText.Text="procedure Memo18OnBeforePrint(Sender: TfrxComponent);&#13;&#10;Var&#13;&#10;  S: String;                              &#13;&#10;begin&#13;&#10;  kdvQ.First;&#13;&#10;  S:= #13#10#13#10'KDV Grupları'#13#10#13#10;                   &#13;&#10;  while not KDVQ.EOF Do&#13;&#10;  Begin&#13;&#10;    S:= S +  ' %'+ IntToStr(&#60;KDV Grupları.&#34;KDV&#34;&#62;) + ' ' + FormatFloat('##0.#0', &#60;KDV Grupları.&#34;KDVMATRAHI&#34;&#62;) +' = ' + &#13;&#10;       FormatFloat('#,#0.#0', &#60;KDV Grupları.&#34;KDVTUTARI&#34;&#62;) + #13#10;&#13;&#10;    KDVQ.Next;&#13;&#10;  End;&#13;&#10;  Memo18.Text:= S;                                     &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="baslikQ" DataSetName="İşlem Başlığı"/>
    <item DataSet="detayQ" DataSetName="İşlem Detayları"/>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
    <item DataSet="KDVQ" DataSetName="KDV Grupları"/>
  </Datasets>
  <Variables>
    <item Name="BelgeNo" Value="1"/>
    <item Name="IslemTipi" Value="2"/>
    <item Name="KARTNO"/>
    <item Name="CARIID"/>
    <item Name="TARIH"/>
    <item Name="YaziIle" Value="'Otuzİki TL Yirmi KR'"/>
  </Variables>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="baslikQ" UserName="İşlem Başlığı" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select B.*, P.AD +' '+ P.SOYAD AS PERSONEL,  D.ACIKLAMA AS DEPO from TBLSATFATBASLIK B LEFT OUTER JOIN TBLPERSONEL P ON B.PERSONELID = P.KARTNO  LEFT OUTER JOIN TBLDEPOLAR D ON B.DEPOID = D.KARTNO  WHERE B.KARTNO = :KARTNO" PropData="05704C65667402640470546F7003C8000A506172616D657465727301010642204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B42656C67654E6F262336323B220000"/>
    <TfrxFDQuery Name="detayQ" UserName="İşlem Detayları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select &#13;&#10;  S.STOKKODU, S.CINSI, B.BIRIMADI,B.BARKOD, H.*,   Cast(0.000 AS Decimal(18, 4)) AS ISKONTO1TOPLAMI,  &#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO2TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO3TOPLAMI, Cast(0.000 AS Decimal(18, 4)) AS ISKONTO4TOPLAMI,&#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILFIYAT, Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILTUTAR                                                     &#13;&#10;From TBLSATFATHAREKET H &#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S ON H.STOKID = S.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B ON H.BIRIMID = B.KARTNO  &#13;&#10;WHERE H.FATURAID = :KARTNO" PropData="05704C65667402640470546F70032C010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI  WHERE KARTNO = :CARIID" PropData="05704C65667402640470546F7002640A506172616D65746572730101145F000000204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B434152494944262333343B262336323B220000"/>
    <TfrxFDQuery Name="KDVQ" UserName="KDV Grupları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="SELECT KDV, SUM(MIKTARI * FIYATI - ISKONTOTOPLAMI) AS KDVMATRAHI, SUM(KDVTUTARI) AS KDVTUTARI  FROM TBLSATFATHAREKET WHERE FATURAID = :KARTNO GROUP BY KDV" PropData="05704C65667402640470546F700390010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="210" PaperHeight="150" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="245,66945" Left="0" Top="18,89765" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="baslikQ" DataSetName="İşlem Başlığı" RowCount="0">
      <TfrxMemoView Name="CariKartFIRMAKODU" Left="15,11812" Top="94,48825" Width="400,63018" Height="18,89765" DataField="FIRMAKODU" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAKODU&#34;]"/>
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="15,11812" Top="117,16543" Width="400,63018" Height="18,89765" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="CariKartADRES" Left="15,11812" Top="139,84261" Width="400,63018" Height="18,89765" DataField="ADRES" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;ADRES&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="570,70903" Top="170,07885" Width="147,40167" Height="15,11812" DataField="BELGENO" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Başlığı.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="570,70903" Top="185,19697" Width="109,60637" Height="15,11812" DataField="TARIH" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
    </TfrxMasterData>
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="15,11812" Left="0" Top="287,24428" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarSTOKKODU" Left="89,37013" Top="0" Width="98,26778" Height="15,11812" DataField="STOKKODU" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Detayları.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="lemDetaylarCINSI" Left="191,41744" Top="0" Width="260,78757" Height="15,11812" DataField="CINSI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="41,91342" Top="0" Width="41,57483" Height="15,11812" DataField="MIKTARI" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarFIYATI" Left="503,01608" Top="0" Width="52,91342" Height="15,11812" DataField="FIYATI" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarISKONTOTOPLAMI" Left="604,7248" Top="0" Width="83,14966" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62;]"/>
    </TfrxDetailData>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="143,62214" Left="0" Top="362,83488" Width="793,7013">
      <TfrxMemoView Name="Memo4" Left="604,7248" Top="5" Width="83,14966" Height="15,11812" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo5" Left="504,11843" Top="5" Width="94,48825" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Ara Toplam"/>
      <TfrxMemoView Name="Memo10" Left="504,11843" Top="23,57483" Width="94,48825" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Toplam İndirim"/>
      <TfrxMemoView Name="Memo11" Left="604,7248" Top="23,57483" Width="83,14966" Height="15,11812" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Başlığı.&#34;ALTISKONTO1&#34;&#62; + &#60;İşlem Başlığı.&#34;ALTISKONTO2&#34;&#62; + &#60;İşlem Başlığı.&#34;SATIRISKONTOSU&#34;&#62;]"/>
      <TfrxLineView Name="Line1" Left="453,5436" Top="3,77953" Width="234,33086" Height="0" Color="0" Diagonal="True"/>
      <TfrxMemoView Name="Memo12" Left="504,11843" Top="41,57483" Width="94,48825" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Fatura Tutarı"/>
      <TfrxMemoView Name="Memo13" Left="604,7248" Top="41,57483" Width="83,14966" Height="15,11812" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Başlığı.&#34;TUTARI&#34;&#62; - &#60;İşlem Başlığı.&#34;KDV&#34;&#62;]"/>
      <TfrxMemoView Name="Memo14" Left="504,11843" Top="60,47248" Width="94,48825" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="KDV"/>
      <TfrxMemoView Name="Memo15" Left="604,7248" Top="60,47248" Width="83,14966" Height="15,11812" DataField="KDV" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;KDV&#34;]"/>
      <TfrxMemoView Name="Memo16" Left="604,7248" Top="79,37013" Width="83,14966" Height="15,11812" DataField="TUTARI" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="##0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;TUTARI&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="504,11843" Top="79,37013" Width="94,48825" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Fatura Toplamı"/>
      <TfrxMemoView Name="Memo18" Left="109,60637" Top="7,55906" Width="343,93723" Height="71,81107" OnBeforePrint="Memo18OnBeforePrint" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo19" Left="113,3859" Top="79,37013" Width="343,93723" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Yalnız [YaziIle]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
