<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<REPORT>
	<TITLE>Sales Report</TITLE>
   <BACKGROUND_COLOR>#FFFFFF</BACKGROUND_COLOR>
   <CSS>phpreports.css</CSS>
   <PAGE BORDER="1" SIZE="2500" CELLSPACING="0" CELLPADDING="5" WIDTH="500">
      <HEADER>
         <ROW>
            <COL COLSPAN="9" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Debtor invoices ordered by aging</COL>
	 </ROW>
<!--
	 <ROW>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Invoice ID</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Biller</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Customer</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Total</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Paid</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Owing</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Date</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Age</COL>
            <COL COLSPAN="1" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD">Aging</COL>
         </ROW>
-->
      </HEADER>		
      <FOOTER>
         <ROW>
            <COL ALIGN="RIGHT" COLSPAN="8" CELLCLASS="PAGE_LAYER">Total Owed</COL>
            <COL ALIGN="LEFT" NUMBERFORMATEX="2" CELLCLASS="PAGE_LAYER" TEXTCLASS="BOLD" TYPE="EXPRESSION">$this->getSum("Owing")</COL>
         </ROW>
      </FOOTER>		
   </PAGE>
	<GROUPS>
      <GROUP NAME="Aginggroup" EXPRESSION="Aging">
         <HEADER>
            <ROW>
               <COL CELLCLASS="GROUP_LAYER">Aging:</COL>
               <COL CELLCLASS="GROUP_LAYER" TEXTCLASS="BOLD" TYPE="EXPRESSION" COLSPAN="8">$header->getValue("Aging")</COL>
            </ROW>
            <ROW>
                                        <COL  CELLCLASS="GROUP_LAYER">inv_id</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Biller</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Customer</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Total</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Paid</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Owing</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Date</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Age</COL>
                                        <COL  CELLCLASS="GROUP_LAYER">Aging</COL>

            </ROW>
         </HEADER>
         <FOOTER>
            <ROW>
               <COL ALIGN="RIGHT" COLSPAN="5" CELLCLASS="GROUP_LAYER">Sum</COL>
               <COL ALIGN="LEFT" CELLCLASS="GROUP_LAYER" TEXTCLASS="BOLD" NUMBERFORMATEX="2" TYPE="EXPRESSION">$this->getSum("Owing")</COL>
            </ROW>
         </FOOTER>


			<FIELDS>
				<ROW>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">inv_id</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Biller</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Customer</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Total</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Paid</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Owing</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Date</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Age</COL>
					<COL TYPE="FIELD" CELLCLASS="GROUP_LAYER">Aging</COL>
				</ROW>
			</FIELDS>
		</GROUP>
	</GROUPS>
</REPORT>
