<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.6.98" DotMatrixReport="False" EngineOptions.UseFileCache="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="39863.6152412384" ReportOptions.Description.Text="" ReportOptions.LastChange="42387.4317017593" ScriptLanguage="BasicScript" ScriptText.Text="dim C                                                  &#13;&#10;&#13;&#10;sub Page1OnBeforePrint(Sender)&#13;&#10;       C = &#60;Balance.&#34;StartBalance&#34;&#62;                       &#13;&#10;end sub&#13;&#10;  &#13;&#10;sub MasterDataOnBeforePrint(Sender)&#13;&#10;       C = C +  &#60;Statement.&#34;DebitOnaccountCurrency&#34;&#62; - &#60;Statement.&#34;CreditOnaccountCurrency&#34;&#62;&#13;&#10;end sub&#13;&#10;&#13;&#10;           " PropData="08446174617365747301010C2000000020446174615365743D2253514C2220446174615365744E616D653D2253514C2200010C2800000020446174615365743D2242616C616E63652220446174615365744E616D653D2242616C616E63652200010C2C00000020446174615365743D225472616E73547970652220446174615365744E616D653D225472616E73547970652200010C2C00000020446174615365743D2253746174656D656E742220446174615365744E616D653D2253746174656D656E742200010C2800000020446174615365743D224163636F756E742220446174615365744E616D653D224163636F756E742200010C2A00000020446174615365743D2243757272656E63792220446174615365744E616D653D2243757272656E63792200010C3600000020446174615365743D2243757272656E7442616C616E63652220446174615365744E616D653D2243757272656E7442616C616E63652200010C3000000020446174615365743D2243757272656E74446174652220446174615365744E616D653D2243757272656E74446174652200010C3200000020446174615365743D224F7267616E69736174696F6E2220446174615365744E616D653D224F7267616E69736174696F6E220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADODatabase Name="DB" LoginPrompt="False" PropData="05704C656674032C010470546F700244"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT  '2010-10-1' As FromDate, '2011-12-31' As ToDate, 2451 As AccountID" CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C656674032B010470546F70038F000A506172616D65746572730100"/>
    <TfrxADOQuery Name="Balance" UserName="Balance" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="&#13;&#10;&#13;&#10;select dbo.[Fn_Balance_Till_Date]( :MyAccountID,:MyFromDate,0) as StartBalance   &#13;&#10;            " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740310010470546F7003D4000A506172616D657465727301010C58000000204E616D653D224D794163636F756E744944222044617461547970653D226674536D616C6C696E74222045787072657373696F6E3D22262336303B53514C2E262333343B4163636F756E744944262333343B262336323B2200010C56000000204E616D653D224D7946726F6D44617465222044617461547970653D2266744461746554696D65222045787072657373696F6E3D22262336303B53514C2E262333343B46726F6D44617465262333343B262336323B220000"/>
    <TfrxADOTable Name="TransType" UserName="TransType" CloseDataSource="True" FieldAliases.Text="" Master="Statement" MasterFields="ID=TransactionTypeID" TableName="dbo.TransType" IndexFieldNames="ID" Database="DB" PropData="05704C6566740380020470546F70039400"/>
    <TfrxADOQuery Name="Statement" UserName="Statement" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT *    &#13;&#10;FROM VwTransactions&#13;&#10;&#13;&#10;where&#13;&#10;Annulled = 0&#13;&#10;And        &#13;&#10;accountid = :AccountID                                                            &#13;&#10;And&#13;&#10;Date Between :FromDate And :ToDate               &#13;&#10;order by   &#13;&#10;date,lineid                                       " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740310020470546F700394000A506172616D657465727301010C56000000204E616D653D224163636F756E744944222044617461547970653D226674536D616C6C696E74222045787072657373696F6E3D22262336303B53514C2E262333343B4163636F756E744944262333343B262336323B2200010C54000000204E616D653D2246726F6D44617465222044617461547970653D2266744461746554696D65222045787072657373696F6E3D22262336303B53514C2E262333343B46726F6D44617465262333343B262336323B2200010C50000000204E616D653D22546F44617465222044617461547970653D2266744461746554696D65222045787072657373696F6E3D22262336303B53514C2E262333343B546F44617465262333343B262336323B220000"/>
    <TfrxADOTable Name="Account" UserName="Account" CloseDataSource="True" FieldAliases.Text="" Master="SQL" MasterFields="ID=AccountID" TableName="Account" IndexFieldNames="ID" Database="DB" PropData="05704C6566740348010470546F7003D400"/>
    <TfrxADOTable Name="Currency" UserName="Currency" CloseDataSource="True" FieldAliases.Text="" Master="Account" MasterFields="ID=CurrencyID" TableName="Currency" IndexFieldNames="ID" Database="DB" PropData="05704C6566740348010470546F70031801"/>
    <TfrxADOQuery Name="CurrentBalance" UserName="CurrentBalance" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select dbo.[Fn_Balance_Till_Date]( :MyAccountID,:MyCurrentDate,1) as MyCurrentBalance&#13;&#10;            " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740380000470546F7003B4000A506172616D657465727301010C58000000204E616D653D224D794163636F756E744944222044617461547970653D226674536D616C6C696E74222045787072657373696F6E3D22262336303B53514C2E262333343B4163636F756E744944262333343B262336323B2200010C5C000000204E616D653D224D7943757272656E7444617465222044617461547970653D22667444617465222045787072657373696F6E3D22262336303B43757272656E74446174652E262333343B434F4C554D4E31262333343B262336323B220000"/>
    <TfrxADOQuery Name="CurrentDate" UserName="CurrentDate" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="ReturnCurrentDate             &#13;&#10;            " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667402440470546F70022C0A506172616D65746572730100"/>
    <TfrxADOTable Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" TableName="dbo.Organisation" Database="DB" PropData="05704C65667403DC000470546F7003A001"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="9" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="" OnBeforePrint="Page1OnBeforePrint">
    <TfrxReportTitle Name="ReportTitle1" Height="237.34663" Left="0" Top="18.89765" Width="1084.72511">
      <TfrxMemoView Name="Memo17" Left="0" Top="183.30708661" Width="1084.72506118" Height="24.56692913" ShowHint="False" Color="13421772" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="TxtStartBalance" Left="844.57472504" Top="213.21274" Width="234.33081118" Height="22.67718" ShowHint="False" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.DropShadow="True" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Balance.&#34;StartBalance&#34;]"/>
      <TfrxPictureView Name="PicLogo" Left="0" Top="0" Width="86.92919" Height="71.81107" ShowHint="False" DataField="LOGO" DataSet="Organisation" DataSetName="Organisation" HightQuality="False"/>
      <TfrxMemoView Name="Memo4" Align="baCenter" Left="164.409555" Top="40.57483" Width="755.906" Height="30.23624" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Elephant" Font.Style="5" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="A C C O U N T     S T A T E M E N T"/>
      <TfrxMemoView Name="Memo5" Left="996.31498504" Top="185.19685039" Width="86.92914118" Height="18.89765" ShowHint="False" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Balance"/>
      <TfrxMemoView Name="Memo6" Left="0" Top="75.59055118" Width="124.72449" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Acc#"/>
      <TfrxMemoView Name="Memo7" Left="0" Top="94.48818898" Width="124.72449" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Ac. Name"/>
      <TfrxMemoView Name="Memo8" Left="0" Top="113.38582677" Width="124.72449" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="From Date"/>
      <TfrxMemoView Name="Memo9" Left="0" Top="132.28346457" Width="124.72449" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="To Date"/>
      <TfrxMemoView Name="SQLFromDate" Left="136.062992125984" Top="113.38582677" Width="377.95275591" Height="18.8976378" ShowHint="False" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[SQL.&#34;FromDate&#34;]"/>
      <TfrxMemoView Name="SQLToDate" Left="136.062992125984" Top="132.28346457" Width="377.95275591" Height="18.8976378" ShowHint="False" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[SQL.&#34;ToDate&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="829.57514" Top="185.19685039" Width="75.59055118" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DEBIT"/>
      <TfrxMemoView Name="Memo11" Left="913.94527" Top="185.19685039" Width="75.59055118" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="CREDIT"/>
      <TfrxMemoView Name="Memo12" Left="49.13385094" Top="185.19685039" Width="37.79527071" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="NUM"/>
      <TfrxMemoView Name="Memo13" Left="0" Top="185.19685039" Width="49.13385339" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DATE"/>
      <TfrxMemoView Name="Memo14" Left="134.92919" Top="185.196850393701" Width="124.72449" Height="18.89765" ShowHint="False" DataSet="TransType" DataSetName="TransType" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="TYPE"/>
      <TfrxMemoView Name="Memo15" Left="685.07874016" Top="185.19685039" Width="136.06295795" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="REFERENCE"/>
      <TfrxMemoView Name="Memo16" Left="264.56692913" Top="185.19685039" Width="408.18899591" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DESCRIPTION"/>
      <TfrxMemoView Name="AccountCode" Left="136.062992125984" Top="75.59055118" Width="158.74026" Height="18.8976378" ShowHint="False" DataField="Code" DataSet="Account" DataSetName="Account" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Account.&#34;Code&#34;]"/>
      <TfrxMemoView Name="AccountName" Left="136.062992125984" Top="94.48818898" Width="480.00031" Height="18.8976378" ShowHint="False" DataSet="Account" DataSetName="Account" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Account.&#34;Name&#34;]  ([Currency.&#34;Code&#34;])"/>
      <TfrxMemoView Name="Memo19" Left="91.92919" Top="185.19685039" Width="37.79527071" Height="18.89765" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="NUM"/>
      <TfrxMemoView Name="Memo22" Left="0" Top="152.96073" Width="124.72449" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Current Balance"/>
      <TfrxMemoView Name="Memo23" Left="136.06299213" Top="152.96073" Width="377.95275591" Height="18.8976378" ShowHint="False" DataSet="Statement" DataSetName="Statement" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[CurrentBalance.&#34;MyCurrentBalance&#34;]"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData" Height="17.00787402" Left="0" Top="317.48052" Width="1084.72511" OnBeforePrint="MasterDataOnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="Statement" DataSetName="Statement" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo21" Left="0" Top="0" Width="1084.72486591" Height="17.007874015748" ShowHint="False" StretchMode="smMaxHeight" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-9" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="15461355" Highlight.Condition="&#60;Line#&#62;mod 2 = 0" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="TxtDebit" Left="833.35467" Top="0.377952760000028" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;DebitOnaccountCurrency&#34;]"/>
      <TfrxMemoView Name="TxtCredit" Left="917.7248" Top="0.377952760000028" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;CreditOnaccountCurrency&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="1000.09451504" Top="0.377952760000028" Width="86.92914118" Height="15.11811024" ShowHint="False" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[C]"/>
      <TfrxMemoView Name="Memo2" Left="52.91338094" Top="0.377952760000028" Width="37.79527071" Height="15.11811024" ShowHint="False" DataField="ID" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;ID&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="0" Top="0.377952760000028" Width="51.0236220472441" Height="15.11811024" ShowHint="False" DataField="Date" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;Date&#34;]"/>
      <TfrxMemoView Name="TransTypeName" Left="138.70872" Top="0.37795275590554" Width="124.72449" Height="15.11811024" ShowHint="False" DataField="Name" DataSet="TransType" DataSetName="TransType" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[TransType.&#34;Name&#34;]"/>
      <TfrxMemoView Name="SQLReference" Left="685.07874016" Top="0.377952760000028" Width="136.06295795" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;Reference&#34;]  [Statement.&#34;Ref2&#34;]  [Statement.&#34;SupInvNum&#34;]   "/>
      <TfrxMemoView Name="Memo18" ShiftMode="smWhenOverlapped" Left="264.56692913" Top="0.377952760000028" Width="408.18899591" Height="15.11811024" ShowHint="False" StretchMode="smMaxHeight" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Statement.&#34;Description&#34;]  [Statement.&#34;Note&#34;]"/>
      <TfrxMemoView Name="Memo20" Left="95.70872" Top="0.37795275590554" Width="37.79527071" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Statement.&#34;DocNum&#34;]"/>
    </TfrxMasterData>
    <TfrxReportSummary Name="ReportSummary1" Height="31.67718" Left="0" Top="396.85065" Width="1084.72511">
      <TfrxMemoView Name="Memo24" Left="757" Top="1.14935000000003" Width="147.59055118" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Arial" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;Statement.&#34;DebitOnaccountCurrency&#34;&#62;,MasterData)]"/>
      <TfrxMemoView Name="Memo25" Left="909" Top="1.14935000000003" Width="83.59055118" Height="15.11811024" ShowHint="False" DataSet="Statement" DataSetName="Statement" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Arial" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;Statement.&#34;CreditOnaccountCurrency&#34;&#62;,MasterData)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
