<?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="42384,6751433681" ReportOptions.Description.Text="" ReportOptions.LastChange="42385,5477690509" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;  cariQ.SQL.Clear;&#13;&#10;  cariQ.SQL.Add('Select * from TBLCARI WHERE KARTNO = ' + IntToStr(&#60;CARIKARTNO&#62;));&#13;&#10;&#13;&#10;  BABSQ.SQL.Clear;                                                         &#13;&#10;  BABSQ.SQL.Add('Declare @CARIID Int');&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('Set @CARIID = ' + IntToStr(&#60;CARIKARTNO&#62;));&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('Declare @BABSTable Table(');&#13;&#10;  BABSQ.SQL.Add('  ALACAK DECIMAL(18, 4),');&#13;&#10;  BABSQ.SQL.Add('  BORC DECIMAL(18, 4)');&#13;&#10;  BABSQ.SQL.Add(')');&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('Declare @BABSOzetTable Table(');&#13;&#10;  BABSQ.SQL.Add('  ALACAK DECIMAL(18, 4),');&#13;&#10;  BABSQ.SQL.Add('  BORC DECIMAL(18, 4),');&#13;&#10;  BABSQ.SQL.Add('  ALACAKSAYISI INT,');&#13;&#10;  BABSQ.SQL.Add('  BORCSAYISI INT');&#13;&#10;  BABSQ.SQL.Add(')');&#13;&#10;  BABSQ.SQL.Add('  ');&#13;&#10;  BABSQ.SQL.Add('INSERT INTO @BABSTable(ALACAK, BORC)');&#13;&#10;  BABSQ.SQL.Add('Select ');&#13;&#10;  BABSQ.SQL.Add('  CASE WHEN ROUND(ALACAK, 2) &#62; 0.00 THEN ROUND(ALACAK - KDV, 2) * KUR ELSE 0 END AS ALACAK,');&#13;&#10;  BABSQ.SQL.Add('  CASE WHEN ROUND(BORC, 2) &#62; 0.00 THEN ROUND(BORC - KDV, 2) * KUR ELSE 0 END AS BORC');&#13;&#10;  BABSQ.SQL.Add('from CARIDOKUM');&#13;&#10;  BABSQ.SQL.Add('WHERE ISLEMTIPI IN(2,3,4,5,24,25,54,55,63,64,172,173,175,176)');&#13;&#10;  BABSQ.SQL.Add('AND CARIID = @CARIID');&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('INSERT INTO @BABSOzetTable(ALACAK, BORC, ALACAKSAYISI, BORCSAYISI)');&#13;&#10;  BABSQ.SQL.Add('Select ');&#13;&#10;  BABSQ.SQL.Add('  SUM(ALACAK), SUM(BORC), ');&#13;&#10;  BABSQ.SQL.Add('  (Select Count(*) From  @BABSTable WHERE ALACAK &#62; 0),');&#13;&#10;  BABSQ.SQL.Add('  (Select Count(*) From  @BABSTable WHERE BORC &#62; 0)');&#13;&#10;  BABSQ.SQL.Add('from @BABSTable');&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('Select * from @BABSOzetTable ');&#13;&#10;  BABSQ.SQL.Add('');&#13;&#10;  BABSQ.SQL.Add('Select ');&#13;&#10;  BABSQ.SQL.Add('  ROUND(SUM(CASE WHEN ALACAK &#60;&#62; 0.0000 THEN ALACAK - KDV ELSE 0 END) * KUR, 2) AS ALACAKLI, ');&#13;&#10;  BABSQ.SQL.Add('  ROUND(SUM(CASE WHEN BORC &#60;&#62; 0.0000 THEN BORC - KDV ELSE 0 END) * KUR, 2) AS BORCLU ');&#13;&#10;  BABSQ.SQL.Add('  from CARIDOKUM WHERE ISLEMTIPI IN(2,3,4,5,24,25,54,55,63,64,172,173,175,176) ');&#13;&#10;  BABSQ.SQL.Add('  AND CARIID = @CARIID');&#13;&#10;  BABSQ.SQL.Add('  GROUP BY KUR');&#13;&#10;  BABSQ.SQL.Add('');      &#13;&#10;end.">
  <Datasets>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
    <item DataSet="BABSQ" DataSetName="BA - BS"/>
  </Datasets>
  <Variables>
    <item Name="CARIKARTNO" Value="1"/>
    <item Name="AY" Value="1"/>
    <item Name="YIL" Value="2016"/>
    <item Name="AYADI" Value="'OCAK'"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI                                                 " PropData="05704C65667402740470546F7002280A506172616D65746572730100"/>
    <TfrxFDQuery Name="BABSQ" UserName="BA - BS" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Declare @CARIID Int&#13;&#10;&#13;&#10;Set @CARIID = 10&#13;&#10;&#13;&#10;Declare @BABSTable Table(&#13;&#10;  ALACAK DECIMAL(18, 4),&#13;&#10;  BORC DECIMAL(18, 4)&#13;&#10;)&#13;&#10;&#13;&#10;Declare @BABSOZetTable Table(&#13;&#10;  ALACAK DECIMAL(18, 4),&#13;&#10;  BORC DECIMAL(18, 4),&#13;&#10;  ALACAKSAYISI INT,&#13;&#10;  BORCSAYISI INT&#13;&#10;)&#13;&#10;  &#13;&#10;INSERT INTO @BABSTable(ALACAK, BORC)&#13;&#10;Select &#13;&#10;  CASE WHEN ROUND(ALACAK, 2) &#62; 0.00 THEN ROUND(ALACAK - KDV, 2) * KUR ELSE 0 END AS ALACAK,&#13;&#10;  CASE WHEN ROUND(BORC, 2) &#62; 0.00 THEN ROUND(BORC - KDV, 2) * KUR ELSE 0 END AS BORC&#13;&#10;from CARIDOKUM&#13;&#10;WHERE ISLEMTIPI IN(2,3,4,5,24,25,54,55,63,64,172,173,175,176)&#13;&#10;AND CARIID = @CARIID&#13;&#10;&#13;&#10;INSERT INTO @BABSOZetTable(ALACAK, BORC, ALACAKSAYISI, BORCSAYISI)&#13;&#10;Select &#13;&#10;  SUM(ALACAK), SUM(BORC), &#13;&#10;  (Select Count(*) From  @BABSTable WHERE ALACAK &#62; 0),&#13;&#10;  (Select Count(*) From  @BABSTable WHERE BORC &#62; 0)&#13;&#10;from @BABSTable&#13;&#10;&#13;&#10;Select * from @BABSOZetTable &#13;&#10;&#13;&#10;Select &#13;&#10;  ROUND(SUM(CASE WHEN ALACAK &#60;&#62; 0.0000 THEN ALACAK - KDV ELSE 0 END) * KUR, 2) AS ALACAKLI, &#13;&#10;  ROUND(SUM(CASE WHEN BORC &#60;&#62; 0.0000 THEN BORC - KDV ELSE 0 END) * KUR, 2) AS BORCLU &#13;&#10;  from CARIDOKUM WHERE ISLEMTIPI IN(2,3,4,5,24,25,54,55,63,64,172,173,175,176) &#13;&#10;  AND CARIID = @CARIID&#13;&#10;  GROUP BY KUR&#13;&#10;  " PropData="05704C65667402740470546F70039C000A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="725,66976" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="2,11812" Top="4,33859" Width="714,33117" Height="37,7953" Font.Charset="1" Font.Color="-16777208" Font.Height="-21" Font.Name="tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="BA - BS MUTABAKAT FORMU"/>
      <TfrxShapeView Name="Shape1" Left="3,77953" Top="52,91342" Width="710,55164" Height="124,72449"/>
      <TfrxMemoView Name="Memo2" Left="7,55906" Top="64,25201" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="FİRMA ÜNVANI"/>
      <TfrxMemoView Name="Memo3" Left="7,55906" Top="86,92913386" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="VERGİ BİLGİSİ"/>
      <TfrxMemoView Name="Memo4" Left="7,55906" Top="109,60629921" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="TELEFON"/>
      <TfrxMemoView Name="Memo5" Left="7,55906" Top="132,28346457" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="FAKS"/>
      <TfrxMemoView Name="Memo6" Left="7,55906" Top="154,96062992" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="EMAİL"/>
      <TfrxMemoView Name="Memo7" Left="624,38621" Top="30,23624" Width="86,92919" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo8" Left="154,96073" Top="64,25201" Width="551,81138" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text="FİRMA ADI"/>
      <TfrxMemoView Name="Memo9" Left="154,96073" Top="86,92913386" Width="551,81138" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text="VERGİ DAİRESİ NOSU"/>
      <TfrxMemoView Name="Memo10" Left="154,96073" Top="109,60629921" Width="551,81138" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text="TELEFON"/>
      <TfrxMemoView Name="Memo11" Left="154,96073" Top="132,28346457" Width="551,81138" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text="FAKS"/>
      <TfrxMemoView Name="Memo12" Left="154,96073" Top="154,96073" Width="551,81138" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text="EMAİL"/>
      <TfrxMemoView Name="Memo13" Left="141,3859" Top="64,25201" Width="7,55906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text=":"/>
      <TfrxMemoView Name="Memo14" Left="141,3859" Top="86,92913386" Width="7,55906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text=":"/>
      <TfrxMemoView Name="Memo15" Left="141,3859" Top="109,60629921" Width="7,55906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text=":"/>
      <TfrxMemoView Name="Memo16" Left="141,3859" Top="132,28346457" Width="7,55906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text=":"/>
      <TfrxMemoView Name="Memo17" Left="141,3859" Top="154,96062992" Width="7,55906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tahoma" Font.Style="1" ParentFont="False" Text=":"/>
      <TfrxMemoView Name="Memo18" Left="7,55906" Top="192,53556" Width="94,48825" Height="26,45671" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="Sayın İlgili;"/>
      <TfrxMemoView Name="Memo19" Left="7,55906" Top="230,55133" Width="699,21305" Height="45,35436" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" HAlign="haBlock" ParentFont="False" Text="Aşağıda belirtilen aylarda BA ve BS formları için fatura tutarına (KDV Hariç), fatura adedine ve vergi numarasına mutabakat ihtiyacı duyulmuştur. Kayıtlarımızda görülen bilgiler aşağıdaki gibidir."/>
      <TfrxMemoView Name="Memo20" Left="7,55906" Top="295,92146" Width="699,21305" Height="56,69295" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" HAlign="haBlock" ParentFont="False" Text="Mutabık iseniz lütfen kaşeleyerek geri gönderiniz. Mutabık değil iseniz; firmanız kayıtlarında görülen değerleri acilen tarafımıza cari hesap ekstresi ile birlikte fakslamanızı veya e-mail yoluyla göndermenizi rica eder, iyi çalışmalar dileriz."/>
      <TfrxMemoView Name="Memo21" Left="7,55906" Top="378,61441" Width="113,3859" Height="26,45671" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" HAlign="haBlock" ParentFont="False" Text="Saygılarımızla."/>
      <TfrxShapeView Name="Shape2" Left="0" Top="449,76407" Width="718,1107" Height="68,03154"/>
      <TfrxMemoView Name="Memo22" Left="11,33859" Top="457,32313" Width="238,11039" Height="22,67718" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Cari Ünvanı"/>
      <TfrxMemoView Name="Memo23" Left="359,05535" Top="457,32313" Width="211,65368" Height="22,67718" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Vergi Dairesi"/>
      <TfrxMemoView Name="Memo24" Left="585,82715" Top="457,32313" Width="113,3859" Height="22,67718" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Vergi Nosu"/>
      <TfrxMemoView Name="CariKartVERGIDAIRESI" Left="359,05535" Top="487,55937" Width="211,65368" Height="18,89765" DataField="VERGIDAIRESI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;VERGIDAIRESI&#34;]"/>
      <TfrxMemoView Name="CariKartVERGINO" Left="585,82715" Top="487,55937" Width="120,94496" Height="18,89765" DataField="VERGINO" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;VERGINO&#34;]"/>
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="11,33859" Top="487,55937" Width="343,93710795" Height="18,89765" DataField="FIRMAUNVANI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="Memo25" Left="0" Top="566,9295" Width="156,85042787" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="1" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="AYLAR"/>
      <TfrxMemoView Name="Memo26" Left="156,85838" Top="566,9295" Width="117,16535677" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="1" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="BA TUTARI"/>
      <TfrxMemoView Name="Memo27" Left="274,01576512" Top="566,9295" Width="162,51979" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="1" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="BA FATURA ADEDI"/>
      <TfrxMemoView Name="Memo28" Left="436,53545016" Top="566,9295" Width="117,16535677" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="1" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="BS TUTARI"/>
      <TfrxMemoView Name="Memo29" Left="553,7007874" Top="566,9295" Width="162,51979" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="1" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="BS FATURA ADEDI"/>
      <TfrxMemoView Name="Memo30" Left="0" Top="592,94527" Width="156,85042787" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="0" Frame.Typ="15" GapX="10" ParentFont="False" VAlign="vaCenter" Text="[AYADI] [YIL]"/>
      <TfrxMemoView Name="Memo31" Left="156,85838" Top="592,94527" Width="117,16535677" Height="26,45669291" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="0" Frame.Typ="15" GapX="10" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[BA - BS.&#34;BORC&#34;]"/>
      <TfrxMemoView Name="Memo32" Left="274,01576512" Top="592,94527" Width="162,51979" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="0" Frame.Typ="15" GapX="10" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[BA - BS.&#34;BORCSAYISI&#34;]"/>
      <TfrxMemoView Name="Memo33" Left="436,53545016" Top="592,94527" Width="117,16535677" Height="26,45669291" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="0" Frame.Typ="15" GapX="10" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[BA - BS.&#34;ALACAK&#34;]"/>
      <TfrxMemoView Name="Memo34" Left="553,7007874" Top="592,94527" Width="162,51979" Height="26,45669291" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Tahoma" Font.Style="0" Frame.Typ="15" GapX="10" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[BA - BS.&#34;ALACAKSAYISI&#34;]"/>
    </TfrxReportTitle>
  </TfrxReportPage>
</TfrxReport>
