<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Name="" Version="3.18" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="2047" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" ReportOptions.CreateDate="39431.5088194444" ReportOptions.Description.Text="" ReportOptions.LastChange="40622.5956781597" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;&#13;&#10;var&#13;&#10;c:currency;&#13;&#10;&#13;&#10;procedure DialogPage1OnShow(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure MasterData1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;if ((&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;)*(&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100)))&#60;&#62;0 then&#13;&#10;C:=((&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;)*(&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))-(&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;)*&#60;BDEQuery1.&#34;COSTUS&#34;&#62;*&#60;BDEQuery1.&#34;CURRVALLC&#34;&#62;)*100/((&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))*(&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;))&#13;&#10;else&#13;&#10;c:=0;&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="044C656674021003546F70026008446174617365747301010C2C00000020446174615365743D224244455175657279312220446174615365744E616D653D224244455175657279312200010C2C00000020446174615365743D224244455175657279332220446174615365744E616D653D224244455175657279332200010C2C00000020446174615365743D224244455461626C65312220446174615365744E616D653D224244455461626C65312200010C2C00000020446174615365743D224244455461626C65342220446174615365744E616D653D224244455461626C65342200010C3500000020446174615365743D226D6F64756C652E667278636F6D70616E792220446174615365744E616D653D22667278636F6D70616E792200010C3800000020446174615365743D226672785573657244617461536574312220446174615365744E616D653D22667278557365724461746153657431220000095661726961626C65730100055374796C650100">
  <TfrxReportPage Name="Page1" PaperWidth="215.9" PaperHeight="279.4" PaperSize="1" LeftMargin="3" RightMargin="3" TopMargin="3" BottomMargin="3" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="" OnBeforePrint="Page1OnBeforePrint">
    <TfrxMasterData Name="MasterData1" Height="15.11811024" Left="0" Top="313.70099" Width="793.323347" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="BDEQuery1" DataSetName="BDEQuery1" RowCount="0">
      <TfrxMemoView Name="Memo3" Left="442.20501" Top="0" Width="60.47248" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[BDEQuery1.&#34;stqty&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="506.45702" Top="0" Width="60.47248" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="-1" Highlight.Font.Height="-11" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="255" Highlight.Condition="value&#60;=1" ParentFont="False" Text="[BDEQuery1.&#34;PRICE&#34;]"/>
      <TfrxMemoView Name="Memo11" Left="574.48856" Top="0" Width="37.7953" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="-1" Highlight.Font.Height="-11" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="255" Highlight.Condition="value&#60;0" ParentFont="False" Text="[&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;]"/>
      <TfrxMemoView Name="Memo17" Left="612.28386" Top="0" Width="60.47248" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="-1" Highlight.Font.Height="-11" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="255" Highlight.Condition="value&#60;&#60;BDEQuery1.&#34;PRICE&#34;&#62;" ParentFont="False" Text="[&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100)]"/>
      <TfrxMemoView Name="Memo30" Left="559.37044" Top="0" Width="0" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;BDEQuery1.&#34;COSTUS&#34;&#62;*&#60;BDEQuery1.&#34;CURRVALLC&#34;&#62;]"/>
      <TfrxMemoView Name="Memo35" Left="668.97681" Top="0" Width="56.69295" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[(&#60;BDEQuery1.&#34;Credit&#34;&#62;-&#60;BDEQuery1.&#34;Debit&#34;&#62;)*(&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))]"/>
      <TfrxMemoView Name="Memo36" Left="680.3154" Top="0" Width="0" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[(&#60;BDEQuery1.&#34;credit&#34;&#62;-&#60;BDEQuery1.&#34;debit&#34;&#62;)*(&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))-(&#60;BDEQuery1.&#34;credit&#34;&#62;-&#60;BDEQuery1.&#34;debit&#34;&#62;)*&#60;BDEQuery1.&#34;COSTUS&#34;&#62;*&#60;BDEQuery1.&#34;CURRVALLC&#34;&#62;]"/>
      <TfrxMemoView Name="Memo37" Left="733.22882" Top="0" Width="37.7953" Height="15.11811024" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.1n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="-1" Highlight.Font.Height="-11" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="255" Highlight.Condition="value&#60;=0" ParentFont="False" Text="[C] %"/>
      <TfrxMemoView Name="Memo38" Left="90.70872" Top="0" Width="340.1577" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[BDEQuery1.&#34;DESCR1&#34;]"/>
      <TfrxMemoView Name="Memo39" Left="15.11812" Top="0" Width="75.5906" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[BDEQuery1.&#34;ITEM&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" Height="30.23624" Left="0" Top="638.74057" Width="793.323347">
      <TfrxMemoView Name="Memo23" Left="668.97681" Top="3.77953000000002" Width="75.5906" Height="18.89765" HAlign="haRight" Text="[Page#]"/>
    </TfrxPageFooter>
    <TfrxReportTitle Name="ReportTitle1" Height="124.72449" Left="0" Top="18.89765" Width="793.323347">
      <TfrxMemoView Name="Memo14" Left="325.03958" Top="11.33859" Width="340.1577" Height="37.7953" CharSpacing="2" Font.Charset="1" Font.Color="-2147483627" Font.Height="-21" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Relatorio De Venda Em Kz"/>
      <TfrxPictureView Name="Picture1" Left="7.55906" Top="7.55906" Width="257.00804" Height="68.03154" DataField="LOGO" DataSet="module.frxcompany" DataSetName="frxcompany"/>
    </TfrxReportTitle>
    <TfrxBDETable Name="BDETable1" UserName="BDETable1" CloseDataSource="True" FieldAliases.Text="" Master="BDEQuery1" MasterFields="ID=CATEGORY" TableName="DETDESCR" DatabaseName="master" SessionName="mys"/>
    <TfrxReportSummary Name="ReportSummary1" Height="136.06308" Left="0" Top="480.00031" Width="793.323347" Stretched="True">
      <TfrxMemoView Name="Memo44" Left="423.30736" Top="7.55905999999999" Width="154.96073" Height="15.11812" Color="15987699" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" Text="Total "/>
      <TfrxMemoView Name="Memo45" Left="578.26809" Top="7.55905999999999" Width="98.26778" Height="15.11812" Color="15987699" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="14" HAlign="haCenter" ParentFont="False" Text="[sum((&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))*(&#60;BDEQuery1.&#34;credit&#34;&#62;-&#60;BDEQuery1.&#34;debit&#34;&#62;))]"/>
      <TfrxSubreport Name="Subreport1" Align="baWidth" Left="0" Top="34.01577" Width="793.323347" Height="34.01577" Page="Page2" PrintOnParent="True"/>
      <TfrxMemoView Name="Memo12" Left="3.77953" Top="3.77953" Width="154.96073" Height="18.89765" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Selected Ware Houses:"/>
    </TfrxReportSummary>
    <TfrxBDEQuery Name="BDEQuery1" UserName="BDEQuery1" CloseDataSource="True" FieldAliases.Text="job=JOB&#13;&#10;item=ITEM&#13;&#10;descr1=DESCR1&#13;&#10;stqty=stqty&#13;&#10;category=CATEGORY&#13;&#10;discount=DISCOUNT&#13;&#10;costus=COSTUS&#13;&#10;price=PRICE&#13;&#10;currvallc=CURRVALLC&#13;&#10;debit=DEBIT&#13;&#10;credit=CREDIT" SQL.Text="select job,item,stock.descr1,max(stock.qty) as stqty,stock.category as category,discount,costus,price,currvallc,sum(debitqty) as debit,sum(creditqty) as credit from items,stock&#13;&#10;where stock.item=items.item  and (ftype=1 or ftype=2)   and (debitqty+creditqty)&#60;&#62;0&#13;&#10; and site in (select id from allstock where mycheck=1)&#13;&#10;&#13;&#10; group by job,stock.category,item,stock.descr1,price,discount,costus,currvallc&#13;&#10; order by job,stock.category,item,stock.descr1" SessionName="mys" PropData="0A506172616D65746572730100"/>
    <TfrxGroupHeader Name="GroupHeader1" Height="41.57483" Left="0" Top="204.09462" Width="793.323347" Condition="BDEQuery1.&#34;JOB&#34;">
      <TfrxMemoView Name="Memo1" Left="15.11812" Top="3.77952999999999" Width="75.59055118" Height="18.89765" Color="15987699" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Venda a"/>
      <TfrxMemoView Name="Memo2" Left="90.70872" Top="3.77953" Width="185.19697" Height="18.89765" Color="15987699" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[BDETable4.&#34;JOB&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="438.42548" Top="22.67718" Width="60.47248" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Existencia"/>
      <TfrxMemoView Name="Memo15" Left="506.45702" Top="22.67718" Width="60.47248" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Preco Act."/>
      <TfrxMemoView Name="Memo16" Left="574.48856" Top="22.67718" Width="37.7953" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Venda"/>
      <TfrxMemoView Name="Memo18" Left="612.28386" Top="22.67718" Width="60.47248" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Preco"/>
      <TfrxMemoView Name="Memo19" Left="559.37044" Top="22.67718" Width="0" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Custo"/>
      <TfrxMemoView Name="Memo20" Left="672.75634" Top="22.67718" Width="56.69295" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Total"/>
      <TfrxMemoView Name="Memo21" Left="680.3154" Top="22.67718" Width="0" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Lucro"/>
      <TfrxMemoView Name="Memo31" Left="733.22882" Top="22.67718" Width="37.7953" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="%"/>
      <TfrxLineView Name="Line6" Left="340.1577" Top="37.7953" Width="430.86642" Height="0" Frame.Typ="4"/>
    </TfrxGroupHeader>
    <TfrxBDETable Name="BDETable4" UserName="BDETable4" CloseDataSource="True" FieldAliases.Text="" Master="BDEQuery1" MasterFields="ID=JOB" TableName="job" DatabaseName="master" SessionName="mys"/>
    <TfrxGroupFooter Name="GroupFooter1" Height="22.67718" Left="0" Top="351.49629" Width="793.323347">
      <TfrxMemoView Name="Memo33" Left="423.30736" Top="3.77953" Width="154.96073" Height="15.11812" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" Text="Total de [BDETable1.&#34;DESCR&#34;]"/>
      <TfrxMemoView Name="Memo34" Left="578.26809" Top="3.77953" Width="98.26778" Height="15.11812" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="14" HAlign="haCenter" ParentFont="False" Text="[sum((&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))*(&#60;BDEQuery1.&#34;credit&#34;&#62;-&#60;BDEQuery1.&#34;debit&#34;&#62;))]"/>
    </TfrxGroupFooter>
    <TfrxGroupHeader Name="GroupHeader2" Height="22.67718" Left="0" Top="268.34663" Width="793.323347" Condition="&#60;BDEQuery1.&#34;CATEGORY&#34;&#62;">
      <TfrxMemoView Name="Memo32" Left="15.11812" Top="3.77953" Width="325.03958" Height="15.11811024" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" ParentFont="False" Text="[BDETable1.&#34;DESCR&#34;]"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter2" Height="22.67718" Left="0" Top="396.85065" Width="793.323347">
      <TfrxMemoView Name="Memo41" Left="423.30736" Top="3.77953000000002" Width="154.96073" Height="15.11812" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" Text="Total de [BDETable4.&#34;JOB&#34;]"/>
      <TfrxMemoView Name="Memo42" Left="578.26809" Top="3.77953000000002" Width="98.26778" Height="15.11812" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-2147483640" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="14" HAlign="haCenter" ParentFont="False" Text="[sum((&#60;BDEQuery1.&#34;PRICE&#34;&#62;-(&#60;BDEQuery1.&#34;PRICE&#34;&#62;*&#60;BDEQuery1.&#34;DISCOUNT&#34;&#62;/100))*(&#60;BDEQuery1.&#34;credit&#34;&#62;-&#60;BDEQuery1.&#34;debit&#34;&#62;))]"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
  <TfrxReportPage Name="Page2" PaperWidth="215.9" PaperHeight="279.4" PaperSize="1" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="19.59" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxBDEQuery Name="BDEQuery3" UserName="BDEQuery3" CloseDataSource="True" FieldAliases.Text="" SQL.Text="select * from allstock where mycheck=1" SessionName="mys" PropData="0A506172616D65746572730100"/>
    <TfrxMasterData Name="MasterData3" Height="18.89765" Left="0" Top="18.89765" Width="740.409927" Columns="15" ColumnWidth="49.1338582677165" ColumnGap="0" DataSet="BDEQuery3" DataSetName="BDEQuery3" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo9" Left="0" Top="0" Width="48.755937" Height="18.89765" DataField="ID" DataSet="BDEQuery3" DataSetName="BDEQuery3" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" Text="[BDEQuery3.&#34;ID&#34;]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
