<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.4.6" 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="42837,5928611343" 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;procedure GroupFooter1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;end;&#13;&#10;&#13;&#10;procedure ColumnFooter1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;   if Engine.CurY &#60; Engine.PageHeight - reportSummary1.Height - 125 Then&#13;&#10;     columnFooter1.Height:= Engine.PageHeight - Engine.CurY - reportSummary1.Height - 125;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure Memo3OnBeforePrint(Sender: TfrxComponent);&#13;&#10;Var&#13;&#10;  S: String;&#13;&#10;begin&#13;&#10;  seriNoQ.First;&#13;&#10;  S:= '';&#13;&#10;  while not seriNoQ.EOF Do&#13;&#10;  Begin&#13;&#10;    if S = '' Then&#13;&#10;      S:= &#60;Seri Noları.&#34;SERINO&#34;&#62;&#13;&#10;    Else&#13;&#10;      S:= S + ', ' + &#60;Seri Noları.&#34;SERINO&#34;&#62;;&#13;&#10;    seriNoQ.Next;&#13;&#10;  End;&#13;&#10;  Memo3.Text:= 'Seri No: ' + S;&#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ı"/>
    <item DataSet="seriNoQ" DataSetName="Seri Noları"/>
  </Datasets>
  <Variables>
    <item Name="BELGENO" Value="1"/>
    <item Name="KARTNO" Value="1"/>
    <item Name="CARIID" Value="6"/>
    <item Name="TARIH" Value="12.04.2017"/>
  </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="05704C65667402640470546F7003C8000A506172616D657465727301010641204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <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 &#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="05704C65667402640470546F700320010A506172616D657465727301010641204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <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="05704C65667402640470546F7002640A506172616D657465727301010641204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B434152494944262336323B220000"/>
    <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"/>
    <TfrxFDQuery Name="seriNoQ" UserName="Seri Noları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10; SERINO                 &#13;&#10;FROM TBLSERINO &#13;&#10;WHERE MODULID = 12 AND KARTNO = :KARTNO " PropData="05704C65667403CC000470546F7002600A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="215,9" PaperHeight="279,4" PaperSize="1" 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="298,58287" Width="816,000527" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" Left="177,19697" Top="2,11023378" Width="313,70099" Height="18,89765" DataField="CINSI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Times New Roman" Font.Style="0" ParentFont="False" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="583,9295" Top="2,11023378" Width="52,91342" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Times New Roman" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Detayları.&#34;MIKTARI&#34;] [İşlem Detayları.&#34;BIRIMADI&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="lemDetaylarFIYATI" Left="495,67749" Top="2,11023378" Width="60,47248" 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="Times New Roman" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;KUR&#34;&#62;]"/>
      <TfrxMemoView Name="Memo4" Left="646,29963" Top="2,11023378" 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="Times New Roman" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; *&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;KUR&#34;&#62; ]"/>
      <TfrxMemoView Name="Memo11" Left="90,70872" Top="2,11023378" Width="83,14966" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Times New Roman" Font.Style="0" ParentFont="False" Text="[İşlem Detayları.&#34;STOKKODU&#34;]"/>
    </TfrxDetailData>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="257,00804" Left="0" Top="18,89765" Width="816,000527" ColumnWidth="0" ColumnGap="0" DataSet="baslikQ" DataSetName="İşlem Başlığı" RowCount="0">
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="142,84261" Top="106,72449" Width="347,71676" Height="41,57483" StretchMode="smActualHeight" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Times New Roman" Font.Style="1" ParentFont="False" Text="[Cari Kart.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="CariKartVERGINO" Left="331,03958" Top="196,31509" 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" ParentFont="False" Text="[Cari Kart.&#34;VERGINO&#34;]"/>
      <TfrxMemoView Name="CariKartADRES" Left="139,84261" Top="147,29932" Width="347,71676" 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="650,5201" Top="205,87415" 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="650,5201" Top="151,1812" 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="Memo2" Left="650,5201" Top="180,41744" 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="159,96073" Top="196,31509" 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;]"/>
    </TfrxMasterData>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="181,72449" Left="0" Top="404,40971" Width="816,000527">
      <TfrxMemoView Name="Memo9" Left="129" Top="118,60630409" Width="430,63018" Height="22,67718" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[TLYaziIle(&#60;İşlem Başlığı.&#34;TUTARI&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo7" Left="646,29963" Top="30,89762803" Width="79,37013" 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="646,29963" Top="90,50391504" Width="79,37013" 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="Memo6" Left="646,29963" Top="70,82674969" Width="79,37013" 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="Memo15" Left="646,29963" Top="50,70864433" Width="79,37013" 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;MIKTARI&#34;&#62; *&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;KUR&#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="KDVGruplarKDVMATRAHI" Left="90,70872" Top="22,67718" Width="483,07143" Height="51,48825" OnBeforePrint="KDVGruplarKDVMATRAHIOnBeforePrint" DataSet="KDVQ" DataSetName="KDV Grupları" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo5" Left="646,29963" Top="11,22046268" Width="79,37013" 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;MIKTARI&#34;&#62; *&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;KUR&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo3" Left="86,92919" Top="79,37013" Width="544,25232" Height="34,01577" OnBeforePrint="Memo3OnBeforePrint" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Seri No YAzacak"/>
    </TfrxReportSummary>
    <TfrxColumnFooter Name="ColumnFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="0,338589999999999" Left="0" Top="381,73253" Width="816,000527" OnBeforePrint="ColumnFooter1OnBeforePrint"/>
  </TfrxReportPage>
</TfrxReport>
