<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.4.11" 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="43845" ReportOptions.Description.Text="" ReportOptions.LastChange="43845,6297641088" ScriptLanguage="PascalScript" ScriptText.Text="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>
  <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 IN(1,2,3)                                                                                                 " MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="120" Top="164"/>
    <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" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="120" Top="252">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;KARTNO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI  WHERE KARTNO = :CARIID" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="120" Top="64">
      <Parameters>
        <item Name="CARIID" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;CARIID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <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" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="120" Top="364">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;KARTNO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="222,99227" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="Memo21" AllowVectorExport="True" Left="83,14966" 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" Frame.Typ="0" ParentFont="False" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="Memo22" AllowVectorExport="True" Left="-3,97338412172488E-15" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="Memo23" AllowVectorExport="True" Left="321,26005" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;KDV&#34;]"/>
      <TfrxMemoView Name="Memo24" AllowVectorExport="True" Left="366,61441" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;ISKONTO1&#34;]"/>
      <TfrxMemoView Name="Memo25" AllowVectorExport="True" Left="408,18924" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;ISKONTO2&#34;]"/>
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="495,11843" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo27" AllowVectorExport="True" Left="589,60668" 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" Frame.Typ="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" Frame.Typ="0" Height="3,77953" Left="0" Top="170,07885" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="baslikQ" DataSetName="İşlem Başlığı" RowCount="0" StartNewPage="True"/>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="90,70872" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo43" AllowVectorExport="True" Left="13" Top="34,28355" Width="309,92146" Height="18,89765" StretchMode="smActualHeight" DataField="FIRMAUNVANI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="Memo41" AllowVectorExport="True" Left="340,14997" Top="33,29932" 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" Frame.Typ="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo42" AllowVectorExport="True" Left="449,89796" Top="32,09462" Width="147,40167" Height="18,89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" DisplayFormat.FormatStr="hh:mm am/pm, mmmm dd, yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo40" AllowVectorExport="True" Left="11,33859" Top="13,57483" Width="309,92146" Height="18,89765" DataField="FIRMAADI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAADI&#34;]"/>
    </TfrxPageHeader>
    <TfrxGroupFooter Name="GroupFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="147,40167" Left="0" Top="268,34663" Width="718,1107">
      <TfrxMemoView Name="Memo33" AllowVectorExport="True" Left="56,69295" Top="11,33859" 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" Frame.Typ="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo35" AllowVectorExport="True" Left="506,45702" Top="15,11811268" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Toplam : "/>
      <TfrxMemoView Name="Memo28" AllowVectorExport="True" Left="604,7248" Top="15,11811268" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo36" AllowVectorExport="True" Left="506,45702" Top="37,79527803" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="İskonto : "/>
      <TfrxMemoView Name="Memo30" AllowVectorExport="True" Left="604,7248" Top="37,79527803" 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" Frame.Typ="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="Memo37" AllowVectorExport="True" Left="506,45702" Top="60,47244339" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Ara Toplam : "/>
      <TfrxMemoView Name="Memo34" AllowVectorExport="True" Left="604,7248" Top="60,47244339" 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" Frame.Typ="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="Memo38" AllowVectorExport="True" Left="506,45702" Top="83,14960874" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="KDV : "/>
      <TfrxMemoView Name="Memo29" AllowVectorExport="True" Left="604,7248" Top="83,14960874" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;KDV&#34;]"/>
      <TfrxMemoView Name="Memo32" AllowVectorExport="True" Left="11,33859" Top="105,82677409" Width="521,57514" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Yalnız : [TLYaziIle(&#60;İşlem Başlığı.&#34;TUTARI&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo39" AllowVectorExport="True" Left="506,45702" Top="105,82677409" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Genel Toplam : "/>
      <TfrxMemoView Name="Memo31" AllowVectorExport="True" Left="604,7248" Top="105,82677409" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;TUTARI&#34;]"/>
    </TfrxGroupFooter>
    <TfrxGroupHeader Name="GroupHeader2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="3,77953" Left="0" Top="196,53556" Width="718,1107" Condition="İşlem Başlığı.&#34;KARTNO&#34;"/>
  </TfrxReportPage>
</TfrxReport>
