src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
author Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Mon, 18 Nov 2019 12:47:40 +0100
changeset 36814 5a1554f3b7a1
parent 26741 d2bbde0c3d66
permissions -rw-r--r--
Related to issue 42295: Avoid API change in CancelAndReplaceUtils
<?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="ReportTaxInvoicePurchaseForeign" pageWidth="535" pageHeight="842" columnWidth="535" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="ca5c867b-f5e6-4ea7-a416-fb91ed037816">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="9"/>
	<style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18">
		<box leftPadding="5"/>
	</style>
	<style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14">
		<box leftPadding="5"/>
	</style>
	<style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle">
		<box leftPadding="5"/>
	</style>
	<style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle">
		<box leftPadding="5">
			<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
			<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
		</box>
	</style>
	<style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="12">
		<box leftPadding="5"/>
	</style>
	<style name="GroupHeader_Gray" mode="Opaque" backcolor="#999999"/>
	<style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="9">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
			<style mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="9"/>
		</conditionalStyle>
	</style>
	<style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/>
	<parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/>
	<parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false"/>
	<parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false"/>
	<parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["'1000000'"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_ORG" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["'0','1000000'"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_TITLE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["REPORT TITLE"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["Purchase Foreign"]]></defaultValueExpression>
	</parameter>
	<parameter name="aux_client" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[$P{USER_CLIENT}.equals("") ? "" : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
	</parameter>
	<parameter name="aux_org" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[$P{USER_ORG}.equals("") ? "" : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
	</parameter>
	<parameter name="cCountryId" class="java.lang.String">
		<defaultValueExpression><![CDATA["100"]]></defaultValueExpression>
	</parameter>
	<parameter name="parDateFrom" class="java.util.Date"/>
	<parameter name="parDateTo" class="java.util.Date"/>
	<parameter name="ReportData" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="PURCHASE" class="java.lang.String" isForPrompting="false"/>
	<parameter name="DETAIL" class="java.lang.String" isForPrompting="false"/>
	<parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/>
	<parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/>
	<parameter name="PARAM_CURRENCY" class="java.lang.String">
		<defaultValueExpression><![CDATA["102"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT C_INVOICE.ISSOTRX AS SALES, 'N' AS NATIONAL, COALESCE(C_INVOICE.POREFERENCE, C_INVOICE.DOCUMENTNO) AS REFERENCE, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME AS BPARTNER, LTRIM(RTRIM(C_TAX.NAME, ' '), ' ') AS TAXNAME,
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT_RATE(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID, ICR.RATE))
      ELSE (C_CURRENCY_CONVERT_RATE(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID, ICR.RATE)) END) AS TAXBASEAMT,
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT_RATE(C_INVOICETAX.TAXAMT, C_INVOICE.C_CURRENCY_ID, $P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID, ICR.RATE))
      ELSE (C_CURRENCY_CONVERT_RATE(C_INVOICETAX.TAXAMT, C_INVOICE.C_CURRENCY_ID, $P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID, ICR.RATE)) END) AS TAXAMT, '' AS ADTREEID,C_CURRENCY_SYMBOL($P{PARAM_CURRENCY}, 0, 'Y') AS CURRENCY,'' AS SUM_AMOUNT,'' AS Tax_BASE
      FROM C_TAX, C_INVOICETAX, C_INVOICE
        LEFT JOIN C_CONVERSION_RATE_DOCUMENT ICR ON C_INVOICE.C_INVOICE_ID = ICR.C_INVOICE_ID,
        C_BPARTNER_LOCATION, C_LOCATION, C_BPARTNER, C_DOCTYPE
      WHERE C_TAX.C_TAX_ID=C_INVOICETAX.C_TAX_ID
      AND C_INVOICETAX.C_INVOICE_ID=C_INVOICE.C_INVOICE_ID
      AND C_INVOICE.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
      AND C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID
      AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
      AND C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
      AND C_INVOICE.PROCESSED = 'Y'
      AND C_INVOICE.ISACTIVE = 'Y'
      AND C_INVOICE.ISSOTRX = 'N'
      AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
      AND C_INVOICE.DATEINVOICED < $P{parDateTo}
      AND C_LOCATION.C_COUNTRY_ID <> $P{cCountryId}
      AND 1=1 $P!{aux_client}
      AND 1=1 $P!{aux_org}
      AND 1=1
      GROUP BY COALESCE(C_INVOICE.POREFERENCE, C_INVOICE.DOCUMENTNO), C_TAX.NAME, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
      HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
      ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED, COALESCE(C_INVOICE.POREFERENCE,  C_INVOICE.DOCUMENTNO)]]>
	</queryString>
	<field name="SALES" class="java.lang.String"/>
	<field name="NATIONAL" class="java.lang.String"/>
	<field name="REFERENCE" class="java.lang.String"/>
	<field name="DATEINVOICED" class="java.sql.Timestamp"/>
	<field name="BPARTNER" class="java.lang.String"/>
	<field name="TAXNAME" class="java.lang.String"/>
	<field name="TAXBASEAMT" class="java.math.BigDecimal"/>
	<field name="TAXAMT" class="java.math.BigDecimal"/>
	<field name="ADTREEID" class="java.lang.String"/>
	<field name="CURRENCY" class="java.lang.String"/>
	<field name="SUM_AMOUNT" class="java.lang.String"/>
	<field name="Tax_BASE" class="java.lang.String"/>
	<variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
		<variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
	</variable>
	<variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
		<variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
	</variable>
	<group name="TAXNAME">
		<groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
		<groupHeader>
			<band height="43" splitType="Stretch">
				<staticText>
					<reportElement key="staticText" style="GroupHeader_DarkGray" x="1" y="0" width="100" height="20" uuid="e26b249a-5dca-4709-a093-03e22d98bea3"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement>
						<font pdfFontName="Helvetica"/>
					</textElement>
					<text><![CDATA[Tax type]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="GroupHeader_DarkGray" x="101" y="0" width="433" height="20" uuid="9e9fa3eb-5e99-438c-b6b0-c35b6889c5cc"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement>
						<font pdfFontName="Helvetica"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{TAXNAME}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-2" stretchType="RelativeToBandHeight" x="0" y="1" width="1" height="42" forecolor="#555555" uuid="1506911f-7c0f-44ce-bacd-c993a86cdb9f"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-3" stretchType="RelativeToBandHeight" x="534" y="1" width="1" height="42" forecolor="#555555" uuid="6dffc841-3d8f-4079-9db4-2b3ca093b19b"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="10" y="27" width="90" height="16" uuid="2122db8a-fdf4-40e2-9e1b-45c56fd3aee0">
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
					</reportElement>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<text><![CDATA[Invoice]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="100" y="27" width="70" height="16" uuid="c14cdc48-387f-4125-8fb9-642a2bd84a55">
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
					</reportElement>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<text><![CDATA[Date]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="170" y="27" width="170" height="16" uuid="275428a5-ca6f-4f23-a7f3-35b9ccbdb9bc">
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
					</reportElement>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<text><![CDATA[Business Partner]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="340" y="27" width="90" height="16" uuid="b793792c-4bbb-4d2e-96e0-ec94150d7765"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Taxable base]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="430" y="27" width="90" height="16" uuid="3fa39a1c-4bf4-4a80-97af-3d82ba9d7b69"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Amount]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="27" splitType="Stretch">
				<line>
					<reportElement key="line-32" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="22" forecolor="#555555" uuid="f9811817-3980-4ce9-b595-58e7e30e229b"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-33" stretchType="RelativeToBandHeight" x="534" y="0" width="1" height="22" forecolor="#555555" uuid="843b480d-173e-4a68-97e6-f9cf47f39c61"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-34" x="0" y="22" width="535" height="1" forecolor="#555555" uuid="42d89b54-a689-4d2c-97ce-a43e04bbe2c0"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="staticText-4" style="default" x="10" y="1" width="90" height="16" uuid="b632f6c9-8f83-4743-bdb2-7bed07d5c25d"/>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement textAlignment="Right">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<text><![CDATA[Total:]]></text>
				</staticText>
				<line>
					<reportElement key="line-37" x="10" y="0" width="510" height="1" forecolor="#666666" uuid="49d0bbe2-29fb-4742-94ea-4b76f414cf41"/>
					<graphicElement>
						<pen lineWidth="0.25" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<textField isBlankWhenNull="false">
					<reportElement key="textField-14" style="Total_Field" x="100" y="1" width="240" height="16" uuid="aa2971fc-673e-450a-a828-2fe59754f2a3"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="false">
					<reportElement key="textField-17" style="Total_Field" x="430" y="1" width="90" height="16" uuid="2dadab0f-45f5-46f5-99b1-47cc4e76d50e"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right"/>
					<textFieldExpression><![CDATA[($V{sumImport}!=null)?$P{NUMBERFORMAT}.format($V{sumImport})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="false">
					<reportElement key="textField-18" style="Total_Field" x="340" y="1" width="90" height="16" uuid="a28b91e1-2806-45b6-80ff-b608329a7c0b"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[($V{sumTaxBaseAmt}!=null)?$P{NUMBERFORMAT}.format($V{sumTaxBaseAmt})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Subtitle" x="2" y="0" width="533" height="20" uuid="dabf7bb4-4ce2-4aa8-ab97-8fba55aaee57"/>
				<box leftPadding="5">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textFieldExpression><![CDATA[$P{PURCHASE}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="14" splitType="Stretch">
			<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
			<line>
				<reportElement key="line-16" stretchType="RelativeToBandHeight" x="534" y="0" width="1" height="14" forecolor="#555555" uuid="97edf324-b7ea-4f83-8df3-dab57db465d2"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<line>
				<reportElement key="line-17" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="14" forecolor="#555555" uuid="c4b6b0dd-e5de-43d2-96ec-c7c9586ab49f"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField-9" style="Detail_Line" stretchType="RelativeToBandHeight" x="10" y="0" width="90" height="14" uuid="7cdba18e-9fff-462e-a680-98495b172192"/>
				<box leftPadding="5" rightPadding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{REFERENCE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField-10" style="Detail_Line" stretchType="RelativeToBandHeight" x="100" y="0" width="70" height="14" uuid="19711e69-9b59-4d6e-87e9-9cbb93e00e93"/>
				<box leftPadding="5" rightPadding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField-11" style="Detail_Line" stretchType="RelativeToBandHeight" x="170" y="0" width="170" height="14" uuid="a1b2c98f-196c-4b9e-9060-0c569aef9214"/>
				<box leftPadding="5" rightPadding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{BPARTNER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-12" style="Detail_Line" stretchType="RelativeToBandHeight" x="340" y="0" width="90" height="14" uuid="b6d2cb13-154a-4f1d-ac5d-f199862988f5"/>
				<box leftPadding="5" rightPadding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-13" style="Detail_Line" stretchType="RelativeToBandHeight" x="430" y="0" width="90" height="14" uuid="0a93250c-66e7-4afa-ade0-4b07bcf02e9b"/>
				<box leftPadding="5" rightPadding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>