﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" DoublePass="true" ReportInfo.Created="09/27/2013 16:01:23" ReportInfo.Modified="05/18/2015 10:51:11" ReportInfo.CreatorVersion="1.6.57.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    
    private void PageHeader1_AfterData(object sender, EventArgs e)
    {
      //Print the User
      if (Report.GetColumnValue(&quot;trans.User&quot;).ToString().Length == 0)
        txtUser.Text = String.Empty;
    }
    
    
    
    
  }
}
</ScriptText>
  <Dictionary>
    <MySqlDataConnection Name="Connection" ConnectionString="rijcmlqomabmqtwD7y3BaVO988XrjoBefSoHBX+xGSDpo0d+ot8yrzL17EhRvx7tW87ZuxDTsXprPmiOj80ATh2Aow+2w==">
      <TableDataSource Name="suppliers" DataType="System.Int32" PropName="clients" Enabled="true" TableName="suppliers" SelectCommand="SELECT * FROM suppliers WHERE ID = 1">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="BillingAddress" DataType="System.String"/>
        <Column Name="ContactNo" DataType="System.String"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="BankingDetails" DataType="System.String"/>
        <Column Name="TaxOnInvoice" DataType="System.String"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="LastCashPurchaseDate" DataType="System.DateTime"/>
        <Column Name="LastCashPurchaseReturnDate" DataType="System.DateTime"/>
        <Column Name="LastAccountPurchaseDate" DataType="System.DateTime"/>
        <Column Name="LastDebitNoteDate" DataType="System.DateTime"/>
        <Column Name="LastPaymentDate" DataType="System.DateTime"/>
        <Column Name="LastJournalDate" DataType="System.DateTime"/>
        <Column Name="TotalDue" DataType="System.Decimal"/>
      </TableDataSource>
      <TableDataSource Name="companies" DataType="System.Int32" Enabled="true" TableName="companies" SelectCommand="select * from companies where ID = 4">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="Address" DataType="System.String"/>
        <Column Name="RegNo" DataType="System.String"/>
        <Column Name="VATno" DataType="System.String"/>
        <Column Name="ContactNo" DataType="System.String"/>
        <Column Name="AltNo" DataType="System.String"/>
        <Column Name="FaxNo" DataType="System.String"/>
        <Column Name="CellNo" DataType="System.String"/>
        <Column Name="LogoPath" DataType="System.String"/>
        <Column Name="InvoiceSize" DataType="System.String"/>
        <Column Name="InvoiceStylePath" DataType="System.String"/>
        <Column Name="VATrate" DataType="System.String"/>
        <Column Name="BankingDetails" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="programs_config" DataType="System.Int32" Enabled="true" TableName="programs_config">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="PaymentMethods" DataType="System.String"/>
        <Column Name="InvSlipNote" DataType="System.String"/>
        <Column Name="InvCustomLabel1" DataType="System.String"/>
        <Column Name="InvCustomLabel2" DataType="System.String"/>
        <Column Name="InvCustomLabel3" DataType="System.String"/>
        <Column Name="InvCustomLabel4" DataType="System.String"/>
        <Column Name="InvCustomLabel5" DataType="System.String"/>
        <Column Name="InvCustomLabel6" DataType="System.String"/>
        <Column Name="InvShowRetailPriceExcl" DataType="System.Byte"/>
        <Column Name="SellingUnderCostOption" DataType="System.String"/>
        <Column Name="DefaultInvoiceType" DataType="System.String"/>
        <Column Name="AfterAddingItemToGridDo" DataType="System.String"/>
        <Column Name="QuotationSlipNote" DataType="System.String"/>
        <Column Name="PrintTo_CashInvoice" DataType="System.String"/>
        <Column Name="PrintTo_Refund" DataType="System.String"/>
        <Column Name="PrintTo_Payout" DataType="System.String"/>
        <Column Name="PrintTo_AccInvoice" DataType="System.String"/>
        <Column Name="PrintTo_CreditNote" DataType="System.String"/>
        <Column Name="PrintTo_Receipt" DataType="System.String"/>
        <Column Name="PrintTo_Journal" DataType="System.String"/>
        <Column Name="PrintTo_Quotation" DataType="System.String"/>
        <Column Name="Copies_CashInvoice" DataType="System.UInt32"/>
        <Column Name="Copies_Refund" DataType="System.UInt32"/>
        <Column Name="Copies_Payout" DataType="System.UInt32"/>
        <Column Name="Copies_AccInvoice" DataType="System.UInt32"/>
        <Column Name="Copies_CreditNote" DataType="System.UInt32"/>
        <Column Name="Copies_Receipt" DataType="System.UInt32"/>
        <Column Name="Copies_Journal" DataType="System.UInt32"/>
        <Column Name="Copies_Quotation" DataType="System.UInt32"/>
        <Column Name="SlipSize_CashInvoice" DataType="System.String"/>
        <Column Name="SlipSize_Refund" DataType="System.String"/>
        <Column Name="SlipSize_Payout" DataType="System.String"/>
        <Column Name="SlipSize_AccInvoice" DataType="System.String"/>
        <Column Name="SlipSize_CreditNote" DataType="System.String"/>
        <Column Name="SlipSize_Receipt" DataType="System.String"/>
        <Column Name="SlipSize_Journal" DataType="System.String"/>
        <Column Name="SlipSize_Quotation" DataType="System.String"/>
        <Column Name="AfterTransDo1_CashInvoice" DataType="System.String"/>
        <Column Name="AfterTransDo1_Refund" DataType="System.String"/>
        <Column Name="AfterTransDo1_Payout" DataType="System.String"/>
        <Column Name="AfterTransDo1_AccInvoice" DataType="System.String"/>
        <Column Name="AfterTransDo1_CreditNote" DataType="System.String"/>
        <Column Name="AfterTransDo1_Receipt" DataType="System.String"/>
        <Column Name="AfterTransDo1_Journal" DataType="System.String"/>
        <Column Name="AfterTransDo1_Quotation" DataType="System.String"/>
        <Column Name="AfterTransDo2_CashInvoice" DataType="System.String"/>
        <Column Name="AfterTransDo2_Refund" DataType="System.String"/>
        <Column Name="AfterTransDo2_Payout" DataType="System.String"/>
        <Column Name="AfterTransDo2_AccInvoice" DataType="System.String"/>
        <Column Name="AfterTransDo2_CreditNote" DataType="System.String"/>
        <Column Name="AfterTransDo2_Receipt" DataType="System.String"/>
        <Column Name="AfterTransDo2_Journal" DataType="System.String"/>
        <Column Name="AfterTransDo2_Quotation" DataType="System.String"/>
        <Column Name="EmailAccount" DataType="System.String"/>
        <Column Name="EmailAddress" DataType="System.String"/>
        <Column Name="EmailUserName" DataType="System.String"/>
        <Column Name="EmailPassword" DataType="System.String"/>
        <Column Name="EmailSMTPAddress" DataType="System.String"/>
        <Column Name="EmailSMTPPort" DataType="System.String"/>
        <Column Name="PayOutReasons" DataType="System.String"/>
        <Column Name="CashDrawerType" DataType="System.String"/>
        <Column Name="CashDrawerComPort" DataType="System.Int32"/>
        <Column Name="CashDrawerKickerCode1" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode2" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode3" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode4" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode5" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode6" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode7" DataType="System.UInt32"/>
        <Column Name="CashDrawerKickerCode8" DataType="System.UInt32"/>
        <Column Name="CashDrawerSlipPrinter" DataType="System.String"/>
        <Column Name="DefaultPurchaseType" DataType="System.String"/>
        <Column Name="Copies_CashPurchase" DataType="System.UInt32"/>
        <Column Name="Copies_CashPurchaseReturn" DataType="System.UInt32"/>
        <Column Name="Copies_AccPurchase" DataType="System.UInt32"/>
        <Column Name="Copies_DebitNote" DataType="System.UInt32"/>
        <Column Name="Copies_Payment" DataType="System.UInt32"/>
        <Column Name="Copies_CreditorJournal" DataType="System.UInt32"/>
        <Column Name="Copies_PurchaseOrder" DataType="System.UInt32"/>
        <Column Name="AfterAddingItemToGridDo_Purchases" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel1" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel2" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel3" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel4" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel5" DataType="System.String"/>
        <Column Name="PurchaseCustomLabel6" DataType="System.String"/>
        <Column Name="PrintTo_CashPurchase" DataType="System.String"/>
        <Column Name="PrintTo_CashPurchaseReturn" DataType="System.String"/>
        <Column Name="PrintTo_AccPurchase" DataType="System.String"/>
        <Column Name="PrintTo_DebitNote" DataType="System.String"/>
        <Column Name="PrintTo_Payment" DataType="System.String"/>
        <Column Name="PrintTo_CreditorJournal" DataType="System.String"/>
        <Column Name="PrintTo_PurchaseOrder" DataType="System.String"/>
        <Column Name="SlipSize_CashPurchase" DataType="System.String"/>
        <Column Name="SlipSize_CashPurchaseReturn" DataType="System.String"/>
        <Column Name="SlipSize_AccPurchase" DataType="System.String"/>
        <Column Name="SlipSize_DebitNote" DataType="System.String"/>
        <Column Name="SlipSize_Payment" DataType="System.String"/>
        <Column Name="SlipSize_CreditorJournal" DataType="System.String"/>
        <Column Name="SlipSize_PurchaseOrder" DataType="System.String"/>
        <Column Name="AfterTransDo1_CashPurchase" DataType="System.String"/>
        <Column Name="AfterTransDo1_CashPurchaseReturn" DataType="System.String"/>
        <Column Name="AfterTransDo1_AccPurchase" DataType="System.String"/>
        <Column Name="AfterTransDo1_DebitNote" DataType="System.String"/>
        <Column Name="AfterTransDo1_Payment" DataType="System.String"/>
        <Column Name="AfterTransDo1_CreditorJournal" DataType="System.String"/>
        <Column Name="AfterTransDo1_PurchaseOrder" DataType="System.String"/>
        <Column Name="AfterTransDo2_CashPurchase" DataType="System.String"/>
        <Column Name="AfterTransDo2_CashPurchaseReturn" DataType="System.String"/>
        <Column Name="AfterTransDo2_AccPurchase" DataType="System.String"/>
        <Column Name="AfterTransDo2_DebitNote" DataType="System.String"/>
        <Column Name="AfterTransDo2_Payment" DataType="System.String"/>
        <Column Name="AfterTransDo2_CreditorJournal" DataType="System.String"/>
        <Column Name="AfterTransDo2_PurchaseOrder" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="trans" DataType="System.Int32" PropName="cash_sales" Enabled="true" TableName="trans" SelectCommand="select * from creditor_journals">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="TransID" DataType="System.UInt32"/>
        <Column Name="Amount" DataType="System.Decimal"/>
        <Column Name="Reason" DataType="System.String"/>
        <Column Name="StatementNote" DataType="System.String"/>
        <Column Name="TotalPaid" DataType="System.Decimal"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="SupplierName" DataType="System.String"/>
        <Column Name="User" DataType="System.String"/>
        <Column Name="RelPaymentIDs" DataType="System.String"/>
      </TableDataSource>
    </MySqlDataConnection>
    <Relation Name="sales_sales_items" ParentDataSource="null" ChildDataSource="null" ParentColumns="ID" ChildColumns="SalesID" Enabled="true"/>
    <Relation Name="sales_companies" ParentDataSource="null" ChildDataSource="null" ParentColumns="CompanyID" ChildColumns="ID" Enabled="true"/>
    <Parameter Name="CompanyID" DataType="System.Int32"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="110" PaperHeight="1000" LeftMargin="3" RightMargin="3" FirstPageSource="15" OtherPagesSource="15">
    <PageHeaderBand Name="PageHeader1" Width="393.12" Height="406.35" CanGrow="true" CanShrink="true" AfterDataEvent="PageHeader1_AfterData">
      <TextObject Name="Text3" Left="18.9" Top="311.85" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" Text="[trans.SupplierName]" Font="Courier New, 8pt"/>
      <TextObject Name="Text2" Top="47.25" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Date: [trans.Date]" Format="Custom" Format.Format="yyyy-MM-dd HH:mm" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text14" Top="103.95" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.Name]" HorzAlign="Center" WordWrap="false" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray" Clip="false"/>
      <TextObject Name="txtTrans" Top="9.45" Width="321.3" Height="18.9" Border.Shadow="true" Border.ShadowColor="Transparent" CanGrow="true" CanShrink="true" Text="Creditor Journal" HorzAlign="Center" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text20" Top="292.95" Width="151.2" Height="18.9" CanGrow="true" CanShrink="true" Text="Journal For:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="txtUser" Top="66.15" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="User: [trans.User]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text44" Top="198.45" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Reg. No: [companies.RegNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text45" Top="236.25" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Vat No: [companies.VATno]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text46" Top="255.15" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Alt. No: [companies.AltNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text52" Top="274.05" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Email: [companies.Email]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text55" Top="217.35" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Tel. No: [companies.ContactNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="txtInvoiceNumber" Top="28.35" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="# [trans.TransID]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text1" Top="122.85" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text17" Text="[companies.Address]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text4" Left="18.9" Top="330.75" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text9" Text="[suppliers.BillingAddress]" Font="Courier New, 8pt"/>
      <TextObject Name="Text9" Left="18.9" Top="349.65" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text16" Font="Courier New, 8pt"/>
      <TextObject Name="Text16" Left="18.9" Top="368.55" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text21" Font="Courier New, 8pt"/>
      <TextObject Name="Text21" Left="18.9" Top="387.45" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" Font="Courier New, 8pt"/>
      <TextObject Name="Text17" Top="141.75" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text72" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text72" Top="160.65" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text73" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text73" Top="179.55" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text110" Top="85.05" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text=" " Font="Courier New, 8pt"/>
      <ChildBand Name="Child4" Top="410.35" Width="393.12" Height="56.7">
        <TextObject Name="Text63" Top="37.8" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="Text15" Left="236.25" Top="18.9" Width="103.95" Height="18.9" Text="Total" HorzAlign="Right" Font="Courier New, 8pt"/>
        <TextObject Name="Text10" Top="18.9" Width="226.8" Height="18.9" Text="Reason" Font="Courier New, 8pt"/>
        <TextObject Name="Text65" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
      </ChildBand>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="471.05" Width="393.12" Height="37.8" CanGrow="true" CanShrink="true" KeepTogether="true" KeepDetail="true">
      <TextObject Name="Text24" Left="236.25" Width="103.95" Height="18.9" Text="[trans.Amount]" HideZeros="true" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text71" Width="226.8" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text111" Text="[trans.Reason]" Font="Courier New, 8pt"/>
      <TextObject Name="Text111" Top="18.9" Width="226.8" Height="18.9" CanGrow="true" CanShrink="true" Font="Courier New, 8pt"/>
    </DataBand>
    <DataBand Name="Data2" Top="512.85" Width="393.12" Height="207.9" CanGrow="true" CanShrink="true">
      <TextObject Name="Text64" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
      <TextObject Name="Text5" Left="198.45" Top="18.9" Width="141.75" Height="18.9" Text="[trans.Amount]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text29" Left="56.7" Top="18.9" Width="94.5" Height="18.9" Text="Total:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text74" Left="198.45" Top="56.7" Width="141.75" Height="18.9" Text="[suppliers.TotalDue]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text75" Left="56.7" Top="56.7" Width="94.5" Height="18.9" Text="Total Due:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text67" Top="189" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
      <TextObject Name="Text68" Top="75.6" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
    </DataBand>
  </ReportPage>
</Report>
