<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Customer Invoice" pageWidth="612" pageHeight="792" columnWidth="597" leftMargin="10" rightMargin="5" topMargin="10" bottomMargin="5">
	<property name="com.jasperassistant.designer.GridHeight" value="12"/>
	<property name="com.jasperassistant.designer.GridWidth" value="12"/>
	<property name="com.jasperassistant.designer.HGuides" value="0"/>
	<property name="com.jasperassistant.designer.DataSource" value="genral_ledger"/>
	<property name="com.jasperassistant.designer.SnapToGrid" value="false"/>
	<property name="com.jasperassistant.designer.Units" value="Inches"/>
	<property name="com.jasperassistant.designer.Grid" value="false"/>
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="105"/>
	<reportFont name="Report_Font" isDefault="false" fontName="Courier New" size="9" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<parameter name="as_sitecode" class="java.lang.String" isForPrompting="false"/>
	<parameter name="as_inv_fr" class="java.lang.String" isForPrompting="false"/>
	<parameter name="as_inv_to" class="java.lang.String" isForPrompting="false"/>
	<parameter name="as_cust_fr" class="java.lang.String" isForPrompting="false"/>
	<parameter name="as_cust_to" class="java.lang.String" isForPrompting="false"/>
	<parameter name="as_invdate_fr" class="java.util.Date"/>
	<parameter name="as_invdate_to" class="java.util.Date"/>
	<queryString>
		<![CDATA[SELECT
	SITE.DESCR AS SITE_DESCR,
	SITE.ADD1 AS SITE_ADD1,
	SITE.ADD2 AS SITE_ADD2,
	SITE.ADD3 AS SITE_ADD3,
	SITE.CITY AS SITE_CITY,
	SITE.STATE_CODE AS SITE_STATE_CODE,
	SITE.PIN AS SITE_PIN,
	SITE.TELE1 AS SITE_TELE1,
	SITE.FAX AS SITE_FAX,
	INVOICE.INVOICE_ID AS INVOICE_INVOICE_ID,
        INVOICE.TRAN_DATE AS INVOICE_TRAN_DATE,
        INVOICE.SALE_ORDER AS INVOICE_SALE_ORDER,
        INVOICE.INV_TYPE AS INVOICE_INV_TYPE,
        INVOICE.CUST_CODE__BIL AS INVOICE_CUST_CODE__BIL,
        INVOICE.REMARKS AS INVOICE_REMARKS,
        INVOICE.FRT_AMT AS INVOICE_FRT_AMT,
        INVOICE.INV_AMT AS INVOICE_INV_AMT,
	C1.CUST_TYPE AS CUSTOMER_CUST_TYPE,
	C1.CUST_CODE AS SOLD_CUST_CODE,
        C1.CUST_NAME AS SOLD_CUST_NAME,
        C1.ADDR1 AS SOLD_ADDR1,
        C1.ADDR2 AS SOLD_ADDR2,
        C1.ADDR3 AS SOLD_ADDR3,
        C1.CITY AS SOLD_CITY,
        C1.STATE_CODE AS SOLD_STATE_CODE,
        C1.PIN AS SOLD_PIN,
        C1.COUNT_CODE AS SOLD_COUNT_CODE,
	C2.CUST_CODE AS SHIP_CUST_CODE,
        C2.CUST_NAME AS SHIP_CUST_NAME,
        C2.ADDR1 AS SHIP_ADDR1,
        C2.ADDR2 AS SHIP_ADDR2,
        C2.ADDR3 AS SHIP_ADDR3,
        C2.CITY AS SHIP_CITY,
        C2.STATE_CODE AS SHIP_STATE_CODE,
        C2.PIN AS SHIP_PIN,
        C2.COUNT_CODE AS SHIP_COUNT_CODE,
	SORDER.CUST_PORD AS SORDER_CUST_PORD,
	nvl(trim(SORDER.SALES_PERS__1||' '||SORDER.SALES_PERS__2),'No Broker') AS SORDER_SALES_PERS,
	CRTERM.DESCR AS CRTER_DESCR,
	DESPATCH.TRAN_CODE AS DESPATCH_TRAN_CODE,
	(SELECT SHP.STATE_CODE FROM SITE SHP WHERE SHP.SITE_CODE = SORDER.SITE_CODE__SHIP) AS SHP_STATE_CODE,
	(SELECT NVL(I.DISC_BILLBACK_AMT_HDR,0) FROM INVOICE I, RECEIVABLES R WHERE I.INVOICE_ID = INVOICE.INVOICE_ID AND I.INVOICE_ID = R.REF_NO AND INVOICE.TRAN_DATE <= R.DISCOUNT_DT ) AS CASH_DISC,
	(SELECT SUM(QTY_DESP * (IT.RATE - ((IT.DISC_SCHEM_BILLBACK_AMT + IT.DISC_SCHEM_OFFINV_AMT)/SO.QTY_DESP))) FROM INVOICE_TRACE IT,SORDITEM SO  WHERE
 IT.SORD_NO = SO.SALE_ORDER AND  IT.SORD_LINE_NO = SO.LINE_NO
 AND IT.INVOICE_ID = INVOICE.INVOICE_ID) AS SUB_TOT

FROM INVOICE, SITE, SORDER, CUSTOMER C1, CUSTOMER C2, CRTERM, DESPATCH

WHERE

         ( INVOICE.SITE_CODE = SITE.SITE_CODE ) and
	 ( INVOICE.SALE_ORDER = SORDER.SALE_ORDER ) and
	( SORDER.CUST_CODE__DLV = C2.CUST_CODE ) and
	( INVOICE.CUST_CODE__BIL = C1.CUST_CODE ) and
         ( INVOICE.CR_TERM = CRTERM.CR_TERM ) and
	( INVOICE.DESP_ID = DESPATCH.DESP_ID ) and
	 ( INVOICE.SITE_CODE =  '$P!{as_sitecode}') AND
         ( INVOICE.INVOICE_ID >= '$P!{as_inv_fr}') AND
         ( INVOICE.INVOICE_ID <= '$P!{as_inv_to}') AND
          ( INVOICE.TRAN_DATE >= $P{as_invdate_fr}) AND
         ( INVOICE.TRAN_DATE <= $P{as_invdate_to}) AND
         ( INVOICE.CUST_CODE >= '$P!{as_cust_fr}') AND
         ( INVOICE.CUST_CODE <= '$P!{as_cust_to}') AND
         ( INVOICE.CONFIRMED = 'Y'   ) and
	( CASE WHEN INVOICE.INVOICE_ID IS NULL THEN 1 ELSE 0 END  =0 )
ORDER BY INVOICE.INVOICE_ID]]>
	</queryString>
	<field name="SITE_DESCR" class="java.lang.String"/>
	<field name="SITE_ADD1" class="java.lang.String"/>
	<field name="SITE_ADD2" class="java.lang.String"/>
	<field name="SITE_ADD3" class="java.lang.String"/>
	<field name="SITE_CITY" class="java.lang.String"/>
	<field name="SITE_STATE_CODE" class="java.lang.String"/>
	<field name="SITE_PIN" class="java.lang.String"/>
	<field name="SITE_TELE1" class="java.lang.String"/>
	<field name="SITE_FAX" class="java.lang.String"/>
	<field name="INVOICE_INVOICE_ID" class="java.lang.String"/>
	<field name="INVOICE_TRAN_DATE" class="java.util.Date"/>
	<field name="INVOICE_SALE_ORDER" class="java.lang.String"/>
	<field name="SOLD_CUST_CODE" class="java.lang.String"/>
	<field name="SOLD_CUST_NAME" class="java.lang.String"/>
	<field name="SOLD_ADDR1" class="java.lang.String"/>
	<field name="SOLD_ADDR2" class="java.lang.String"/>
	<field name="SOLD_ADDR3" class="java.lang.String"/>
	<field name="SOLD_CITY" class="java.lang.String"/>
	<field name="SOLD_STATE_CODE" class="java.lang.String"/>
	<field name="SOLD_PIN" class="java.lang.String"/>
	<field name="SOLD_COUNT_CODE" class="java.lang.String"/>
	<field name="SHIP_CUST_CODE" class="java.lang.String"/>
	<field name="SHIP_CUST_NAME" class="java.lang.String"/>
	<field name="SHIP_ADDR1" class="java.lang.String"/>
	<field name="SHIP_ADDR2" class="java.lang.String"/>
	<field name="SHIP_ADDR3" class="java.lang.String"/>
	<field name="SHIP_CITY" class="java.lang.String"/>
	<field name="SHIP_STATE_CODE" class="java.lang.String"/>
	<field name="SHIP_PIN" class="java.lang.String"/>
	<field name="SHIP_COUNT_CODE" class="java.lang.String"/>
	<field name="SORDER_CUST_PORD" class="java.lang.String"/>
	<field name="CRTER_DESCR" class="java.lang.String"/>
	<field name="DESPATCH_TRAN_CODE" class="java.lang.String"/>
	<field name="INVOICE_INV_TYPE" class="java.lang.String"/>
	<field name="INVOICE_CUST_CODE__BIL" class="java.lang.String"/>
	<field name="CUSTOMER_CUST_TYPE" class="java.lang.String"/>
	<field name="SHP_STATE_CODE" class="java.lang.String"/>
	<field name="INVOICE_REMARKS" class="java.lang.String"/>
	<field name="INVOICE_FRT_AMT" class="java.lang.Double"/>
	<field name="INVOICE_INV_AMT" class="java.lang.Double"/>
	<field name="SUB_TOT" class="java.lang.Double"/>
	<field name="CASH_DISC" class="java.lang.Double"/>
	<field name="SORDER_SALES_PERS" class="java.lang.String"/>
	<variable name="c_addr_sold_to" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull( $F{SOLD_CUST_CODE} )? "" :  ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_CUST_CODE} ) )  + (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_CUST_NAME}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_CUST_NAME} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_ADDR1}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_ADDR1} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_ADDR2}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_ADDR2} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_ADDR3}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_ADDR3} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_CITY}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_CITY} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_STATE_CODE}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_STATE_CODE} ) )  +  (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_COUNT_CODE}  )? "" : "       " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_COUNT_CODE} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SOLD_PIN}  )? "" : "       " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SOLD_PIN} ) ))]]></variableExpression>
	</variable>
	<variable name="c_addr_ship_to" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull( $F{SHIP_CUST_CODE} )? "" :  ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_CUST_CODE} ) )  + (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_CUST_NAME}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_CUST_NAME} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_ADDR1}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_ADDR1} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_ADDR2}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_ADDR2} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_ADDR3}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_ADDR3} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_CITY}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_CITY} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_STATE_CODE}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_STATE_CODE} ) )  +  (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_COUNT_CODE}  )? "" : "       " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_COUNT_CODE} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SHIP_PIN}  )? "" : "       " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIP_PIN} ) ))]]></variableExpression>
	</variable>
	<variable name="compute_1" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_ADD1}  )? "" : "\n\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_ADD1} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_ADD2}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_ADD2} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_ADD3}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_ADD3} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_CITY}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_CITY} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_STATE_CODE}  )? "" : ", " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_STATE_CODE} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_PIN}  )? "" : " " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_PIN} ) )  +  (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_TELE1}  )? "" : "\n" + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_TELE1} ) )+ (ibase.webitm.reports.utility.BaseReportMethods.isNull (  $F{SITE_FAX}  )? "" : "\nFax :  " + ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SITE_FAX} ) ))]]></variableExpression>
	</variable>
	<variable name="compute_2" class="java.lang.Double">
		<variableExpression><![CDATA[new java.lang.Double($F{SUB_TOT}.doubleValue()+ $F{INVOICE_FRT_AMT}.doubleValue())]]></variableExpression>
	</variable>
	<group name="invoice_invoice_id_group" isStartNewPage="true" isResetPageNumber="true">
		<groupExpression><![CDATA[$F{INVOICE_INVOICE_ID}]]></groupExpression>
		<groupHeader>
			<band/>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band height="700">
			<line>
				<reportElement x="22" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="4" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="180" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="224" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="268" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="576" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="309" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="330" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="446" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="396" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="512" y="286" width="1" height="310"/>
			</line>
			<line>
				<reportElement x="4" y="596" width="573" height="1"/>
			</line>
		</band>
	</background>
	<pageHeader>
		<band height="315">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="364" y="114" width="213" height="90">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{c_addr_ship_to}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement mode="Opaque" x="430" y="53" width="96" height="36"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Opaque" x="317" y="8" width="258" height="36"/>
			</rectangle>
			<line>
				<reportElement x="5" y="253" width="570" height="1"/>
			</line>
			<line>
				<reportElement x="67" y="237" width="1" height="37"/>
			</line>
			<line>
				<reportElement x="154" y="237" width="1" height="37"/>
			</line>
			<line>
				<reportElement x="218" y="237" width="1" height="37"/>
			</line>
			<line>
				<reportElement x="285" y="237" width="1" height="37"/>
			</line>
			<line>
				<reportElement x="399" y="237" width="1" height="37"/>
			</line>
			<rectangle>
				<reportElement mode="Transparent" x="4" y="285" width="572" height="27"/>
			</rectangle>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="551" y="238" width="22" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Whs]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="526" y="288" width="42" height="25">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Ext.]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="180" y="288" width="47" height="23">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Qty Ord.]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="431" y="53" width="95" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice / Credit]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="431" y="12" width="70" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice Date]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="361" y="12" width="65" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice #]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="321" y="11" width="36" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Page #]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="6" y="238" width="59" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[A/ R Cust.]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="462" y="238" width="83" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Broker Name]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="4" y="213" width="581" height="19">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Remit Payment To: TARO PHARMACEUTICALS USA, INC., 75 REMITTANCE DR, STE 2503, , CHICAGO, IL, 60675]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="36" y="114" width="32" height="31">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[SOLD TO]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="328" y="114" width="27" height="31">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[SHIP TO]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="23" y="288" width="157" height="22">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Item # / Description]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="7" y="288" width="14" height="20">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[LN]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="341" y="288" width="44" height="23">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[List Price]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="400" y="288" width="45" height="23">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Allow
Promo]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="463" y="288" width="34" height="24">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Net]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="72" y="238" width="79" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Cust. P.O. #]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="155" y="238" width="60" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Carrier]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="220" y="238" width="63" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Terms]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="401" y="238" width="53" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Cls Trade]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="310" y="288" width="20" height="22">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[U/M]]></text>
			</staticText>
			<textField pattern="MM/dd/yy" isBlankWhenNull="true">
				<reportElement positionType="Float" x="430" y="29" width="71" height="14">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="9" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{INVOICE_TRAN_DATE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="363" y="29" width="63" height="14">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="9" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_INVOICE_ID}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="70" y="255" width="81" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_CUST_PORD}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="155" y="255" width="60" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESPATCH_TRAN_CODE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="220" y="255" width="63" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CRTER_DESCR}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Page" pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="323" y="29" width="24" height="14">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="75" y="114" width="213" height="90">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{c_addr_sold_to}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement mode="Transparent" x="4" y="236" width="572" height="37"/>
			</rectangle>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="61" y="24" width="245" height="84">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{compute_1}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="505" y="9" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="427" y="9" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="317" y="26" width="258" height="1"/>
			</line>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="508" y="11" width="65" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Order #]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="508" y="29" width="65" height="14">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="9" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_SALE_ORDER}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="357" y="8" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="431" y="71" width="95" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="9" isBold="false"/>
				</textElement>
				<text><![CDATA[Invoice]]></text>
			</staticText>
			<line>
				<reportElement x="430" y="66" width="96" height="1"/>
			</line>
			<line>
				<reportElement x="454" y="237" width="1" height="37"/>
			</line>
			<line>
				<reportElement x="550" y="237" width="1" height="37"/>
			</line>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="221" y="289" width="52" height="23">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Qty.Ship]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="269" y="289" width="41" height="23">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Qty B/O]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="61" y="11" width="245" height="10">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_DESCR}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="536" y="57" width="34" height="14">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="9" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_INV_TYPE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="5" y="255" width="60" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_CUST_CODE__BIL}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="401" y="255" width="53" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CUSTOMER_CUST_TYPE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="551" y="255" width="22" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SHP_STATE_CODE}.trim()]]></textFieldExpression>
			</textField>
			<image scaleImage="RetainShape" hAlign="Center">
				<reportElement x="5" y="11" width="52" height="97"/>
				<imageExpression class="java.lang.String"><![CDATA["//data//jboss-5.1.0.GA//server//default//deploy//ibase.ear//ibase.war//webitm//reports//images//TAROUSA Logo.jpg"]]></imageExpression>
			</image>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="462" y="255" width="83" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_SALES_PERS}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="21">
			<subreport>
				<reportElement positionType="Float" x="4" y="0" width="566" height="10">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="as_inv">
					<subreportParameterExpression><![CDATA[$F{INVOICE_INVOICE_ID}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream("/data/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml/customer_inv_det.jasper")]]></subreportExpression>
			</subreport>
			<subreport>
				<reportElement positionType="Float" x="4" y="11" width="566" height="10">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="as_inv">
					<subreportParameterExpression><![CDATA[$F{INVOICE_INVOICE_ID}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream("/data/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml/customer_inv_scheme.jasper")]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<pageFooter>
		<band height="203">
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="16" y="155" width="260" height="42">
					<printWhenExpression><![CDATA[new Boolean((( ($V{PAGE_NUMBER}).intValue() == ($V{PAGE_NUMBER}).intValue() )?true:false))]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[INQUIRIES RELATED TO THIS INVOICE SHOULD BE
DIRECTED TO ACCOUNTS RECEIVABLE (800) 544 - 1449]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="298" y="155" width="277" height="42">
					<printWhenExpression><![CDATA[new Boolean((( ($V{PAGE_NUMBER}).intValue() == ($V{PAGE_NUMBER}).intValue() )?true:false))]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[NO RETURNS ACCEPTED UNLESS AUTHORIZED IN ADVANCE
ALL CLAIMS TO BE MADE WITHIN 3 DAYS FROM RECEIPT]]></text>
			</staticText>
			<rectangle>
				<reportElement mode="Transparent" x="4" y="27" width="572" height="75"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Opaque" x="24" y="107" width="462" height="36"/>
			</rectangle>
			<line>
				<reportElement x="24" y="123" width="462" height="1"/>
			</line>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="244" y="110" width="54" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Sub Total]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="311" y="110" width="54" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Freight]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="378" y="110" width="84" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice Total]]></text>
			</staticText>
			<line>
				<reportElement x="368" y="107" width="1" height="36"/>
			</line>
			<line>
				<reportElement x="305" y="107" width="1" height="36"/>
			</line>
			<line>
				<reportElement x="243" y="107" width="1" height="36"/>
			</line>
			<staticText>
				<reportElement positionType="Float" mode="Opaque" x="28" y="109" width="215" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Cash Discount Allowed if paid within terms]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="7" y="37" width="563" height="55">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_REMARKS}]]></textFieldExpression>
			</textField>
			<textField pattern="0.00" isBlankWhenNull="true">
				<reportElement positionType="Float" x="311" y="127" width="52" height="12">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{INVOICE_FRT_AMT}]]></textFieldExpression>
			</textField>
			<textField pattern="0.00" isBlankWhenNull="true">
				<reportElement positionType="Float" x="128" y="127" width="87" height="12">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{CASH_DISC}]]></textFieldExpression>
			</textField>
			<textField pattern="0.00" isBlankWhenNull="true">
				<reportElement positionType="Float" x="248" y="127" width="52" height="12">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{SUB_TOT}]]></textFieldExpression>
			</textField>
			<textField pattern="0.00" isBlankWhenNull="true">
				<reportElement positionType="Float" x="379" y="127" width="95" height="12">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{compute_2}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
