<?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.CreateDate="41977,7330592708" ReportOptions.Description.Text="" ReportOptions.LastChange="42711,5040280208" ScriptLanguage="PascalScript" ScriptText.Text="procedure KDVGruplarKDVMATRAHIOnBeforePrint(Sender: TfrxComponent);&#13;&#10;Var&#13;&#10;  S: String;&#13;&#10;  M, T: Double;                                &#13;&#10;begin  &#13;&#10;  S:= '';&#13;&#10;  KDVQ.First;&#13;&#10;  while not KDVQ.EOF Do&#13;&#10;  Begin&#13;&#10;    M:= &#60;KDV Grupları.&#34;KDVMATRAHI&#34;&#62;;&#13;&#10;    T:= &#60;KDV Grupları.&#34;KDVTUTARI&#34;&#62;;                   &#13;&#10;    S:= S + '%' + Format('%2d', [Trunc(&#60;KDV Grupları.&#34;KDV&#34;&#62;)]) + &#13;&#10;      '  ( ' + FormatFloat('#,#0.#0', M) + ' ) ' + FormatFloat('#,#0.#0', T) + #13#10;&#13;&#10;    KDVQ.Next;&#13;&#10;  End;&#13;&#10;  KDVGruplarKDVMATRAHI.Text:= S;                               &#13;&#10;end;&#13;&#10;&#13;&#10;procedure reportOnStartReport(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;                                                                                 &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  // ShowMessage('Kart No: ' + IntToStr(&#60;BelgeNo&#62;));  &#13;&#10;end." OnStartReport="reportOnStartReport">
  <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="65"/>
    <item Name="KARTNO" Value="65"/>
    <item Name="CARIID" Value="4"/>
    <item Name="TARIH" Value="7.12.2016"/>
  </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 &#13;&#10;  B.*, P.AD +' '+ P.SOYAD AS PERSONEL,  D.ACIKLAMA AS DEPO &#13;&#10;from TBLSATFATBASLIK B &#13;&#10;LEFT OUTER JOIN TBLPERSONEL P ON B.PERSONELID = P.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLDEPOLAR D ON ISNULL(D.DELETED, 0) = 0 AND B.DEPOID = D.KARTNO  &#13;&#10;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,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO2TOPLAMI,  &#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO3TOPLAMI, Cast(0.000 AS Decimal(18, 4)) AS ISKONTO4TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILFIYAT, &#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILTUTAR, BRUTKDV - H.KDVTUTARI        &#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="05704C65667402640470546F700320010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <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 &#13;&#10;  KDV, ISNULL(SUM(MIKTARI * FIYATI - ISKONTOTOPLAMI), 0) AS KDVMATRAHI, &#13;&#10;  ISNULL(SUM(KDVTUTARI), 0) AS KDVTUTARI  &#13;&#10;FROM TBLSATFATHAREKET &#13;&#10;WHERE FATURAID = :KARTNO &#13;&#10;GROUP BY KDV" PropData="05704C65667402640470546F700390010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="444" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" Left="154,96073" Top="0" Width="230,55133" Height="18,89765" DataField="CINSI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="71,81107" Top="0" Width="60,47248" Height="18,89765" DataField="MIKTARI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="393,07112" Top="0" Width="41,57483" Height="18,89765" DataField="KDV" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;KDV&#34;]"/>
      <TfrxMemoView Name="lemDetaylarISKONTO1" Left="438,42548" Top="0" Width="41,57483" Height="18,89765" DataField="ISKONTO1" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="%g" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;ISKONTO1&#34;]"/>
      <TfrxMemoView Name="lemDetaylarISKONTO2" Left="480,00031" Top="0" Width="41,57483" Height="18,89765" DataField="ISKONTO2" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="%g" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;ISKONTO2&#34;]"/>
      <TfrxMemoView Name="lemDetaylarFIYATI" Left="566,9295" Top="0" Width="60,47248" Height="18,89765" DataField="FIYATI" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.DecimalSeparator="," DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="661,41775" Top="0" Width="79,37013" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.DecimalSeparator="," DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;]"/>
    </TfrxDetailData>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="253,22851" Left="0" Top="172" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="baslikQ" DataSetName="İşlem Başlığı" RowCount="0">
      <TfrxMemoView Name="CariKartFIRMAKODU" Left="68,03154" Top="79,37013" Width="309,92146" Height="18,89765" DataField="FIRMAKODU" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAKODU&#34;]"/>
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="68,03154" Top="102,04731" Width="309,92146" Height="41,57483" StretchMode="smActualHeight" DataField="FIRMAUNVANI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="634,96104" Top="173,85838" Width="79,37013" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="CariKartVERGIDAIRESI" Left="120,94496" Top="192,75603" Width="128,50402" Height="18,89765" DataField="VERGIDAIRESI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;VERGIDAIRESI&#34;]"/>
      <TfrxMemoView Name="CariKartVERGINO" Left="249,44898" Top="192,75603" Width="128,50402" Height="18,89765" DataField="VERGINO" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Cari Kart.&#34;VERGINO&#34;]"/>
      <TfrxMemoView Name="CariKartADRES" Left="68,03154" Top="143,62214" Width="309,92146" Height="41,57483" StretchMode="smActualHeight" DataField="ADRES" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;ADRES&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="634,96104" Top="154,96073" Width="79,37013" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="hh:mm" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="634,96104" Top="136,06308" Width="79,37013" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
    </TfrxMasterData>
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="136,06308" Left="0" Top="16" Width="793,7013"/>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="136,06308" Left="0" Top="488" Width="793,7013">
      <TfrxMemoView Name="Memo5" Left="634,96104" Top="11,33858268" Width="105,82684" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo6" Left="634,96104" Top="79,37007874" Width="105,82684" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;KDV&#34;]"/>
      <TfrxMemoView Name="Memo7" Left="634,96104" Top="34,01574803" Width="105,82684" Height="18,89765" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" 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;]"/>
      <TfrxMemoView Name="Memo8" Left="634,96104" Top="102,04724409" Width="105,82684" Height="18,89765" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;TUTARI&#34;]"/>
      <TfrxMemoView Name="Memo9" Left="11,33859" Top="102,04724409" Width="521,57514" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Yalnız : [TLYaziIle(&#60;İşlem Başlığı.&#34;TUTARI&#34;&#62;)]"/>
      <TfrxMemoView Name="KDVGruplarKDVMATRAHI" Left="56,69295" Top="7,55906" Width="377,953" Height="90,70872" OnBeforePrint="KDVGruplarKDVMATRAHIOnBeforePrint" DataSet="KDVQ" DataSetName="KDV Grupları" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo15" Left="634,96104" Top="56,69291339" Width="105,82684" Height="18,89765" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62;,DetailData1) - (&#60;İşlem Başlığı.&#34;ALTISKONTO1&#34;&#62; + &#60;İşlem Başlığı.&#34;ALTISKONTO2&#34;&#62; + &#60;İşlem Başlığı.&#34;SATIRISKONTOSU&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo16" Left="536,69326" Top="11,33858268" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Toplam : "/>
      <TfrxMemoView Name="Memo17" Left="536,69326" Top="34,01574803" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="İskonto : "/>
      <TfrxMemoView Name="Memo18" Left="536,69326" Top="56,69291339" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Ara Toplam : "/>
      <TfrxMemoView Name="Memo19" Left="536,69326" Top="79,37007874" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="KDV : "/>
      <TfrxMemoView Name="Memo20" Left="536,69326" Top="102,04724409" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Genel Toplam : "/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
