<?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="\\Asus\İrsalİye" PrintOptions.PrintOnSheet="0" PrintOptions.ShowDialog="False" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="41379" ReportOptions.Description.Text="" ReportOptions.LastChange="42902,6582132986" ScriptLanguage="PascalScript" ScriptText.Text="Var&#13;&#10;  NakliYekun: Real;&#13;&#10;&#13;&#10;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 MasterData1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  NakliYekun:= NakliYekun + &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure PageHeader1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  Memo2.Visible:= &#60;Page&#62; &#62; 1;&#13;&#10;  Memo11.Visible:= Memo2.Visible;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure Memo11OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  Memo11.Text:= FormatFloat('#,#0.#0', NakliYekun - &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;);&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  NakliYekun:= 0;&#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="10"/>
    <item Name="KARTNO" Value="10"/>
    <item Name="CARIID" Value="4"/>
    <item Name="TARIH" Value="16.06.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 TBLSATIRSBASLIK 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="05704C65667402240470546F7002740A506172616D657465727301010642204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B42656C67654E6F262336323B220000"/>
    <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 TBLSATIRSHAREKET 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="05704C65667402240470546F7003CC000A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <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="05704C65667402240470546F7002100A506172616D65746572730101145F000000204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B434152494944262333343B262336323B220000"/>
    <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 TBLSATIRSHAREKET &#13;&#10;WHERE FATURAID = :KARTNO &#13;&#10;GROUP BY KDV" PropData="05704C65667402240470546F70033C010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="140" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="" OnBeforePrint="SAYFAOnBeforePrint">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="268,34663" Width="793,7013" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" Left="43,7953" Top="3,77953" Width="309,92146" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" WordBreak="True" WordWrap="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="374,17347" Top="3,77953" Width="49,13389" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="423,30736" Top="3,77953" Width="56,69295" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="514,01608" Top="3,77953" Width="56,69295" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="631,18151" Top="3,77953" Width="105,82684" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[&#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="188,97637795" Left="0" Top="18,89765" Width="793,7013" OnBeforePrint="PageHeader1OnBeforePrint">
      <TfrxMemoView Name="Memo6" Left="646,29963" Top="76,5906" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Date] ">
        <Formats>
          <item FormatStr="dd.mm.yyyy" Kind="fkDateTime"/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo7" Left="646,41775" Top="99,26778" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="hh:nn" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Time]"/>
      <TfrxMemoView Name="Memo8" Left="646,29963" Top="124,28355" Width="204,09462" 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" VAlign="vaCenter" Text="[İşlem Başlığı.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="37,57483" Top="82,26778" Width="257,00804" Height="49,13389" AllowHTMLTags="True" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="43,7953" Top="165,51979" Width="309,92146" Height="15,11812" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" WordBreak="True" WordWrap="False" VAlign="vaCenter" Text="Nakli Yekun"/>
      <TfrxMemoView Name="Memo11" Left="631,18151" Top="167,51979" Width="105,82684" Height="15,11812" OnBeforePrint="Memo11OnBeforePrint" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text=""/>
    </TfrxPageHeader>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="98,26771654" Left="0" Top="351,49629" Width="793,7013">
      <TfrxMemoView Name="KDVGruplarKDVMATRAHI" Left="79,37013" Top="6" Width="336,37817" Height="86,92919" 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="Memo5" Left="631,18151" Top="32,45669535" 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="Memo9" Left="631,18151" Top="55,1338607" 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="Memo15" Left="631,18151" Top="9,77953" 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;,MasterData1) - (&#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="Memo18" Left="532,91373" Top="9,77953" 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="532,91373" Top="32,45669535" 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="532,91373" Top="55,1338607" 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>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="45,35436" Left="0" Top="472,44125" Width="793,7013"/>
  </TfrxReportPage>
</TfrxReport>
