Modified PostgreSQL post script in order to include C_DEBT_PAYMENT_GENERATE modification tules
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="ReportTaxInvoiceSale"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="535"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="0"
rightMargin="0"
topMargin="0"
bottomMargin="0"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<style
name="default"
isDefault="false"
vAlign="Middle"
fontName="Bitstream Vera Sans"
fontSize="10"
/>
<style
name="Report_Title"
isDefault="false"
leftPadding="5"
fontName="Bitstream Vera Sans"
fontSize="18"
/>
<style
name="Report_Subtitle"
isDefault="false"
forecolor="#555555"
leftPadding="5"
fontName="Bitstream Vera Sans"
fontSize="14"
/>
<style
name="Total_Field"
isDefault="false"
mode="Opaque"
forecolor="#000000"
backcolor="#CCCCCC"
vAlign="Middle"
leftPadding="5"
/>
<style
name="Detail_Header"
isDefault="false"
mode="Opaque"
forecolor="#FFFFFF"
backcolor="#555555"
vAlign="Middle"
leftBorder="1Point"
leftBorderColor="#FFFFFF"
leftPadding="5"
rightBorder="1Point"
rightBorderColor="#FFFFFF"
/>
<style
name="GroupHeader_DarkGray"
isDefault="false"
mode="Opaque"
forecolor="#FFFFFF"
backcolor="#555555"
vAlign="Middle"
leftPadding="5"
fontName="Bitstream Vera Sans"
fontSize="14"
/>
<style
name="GroupHeader_Gray"
isDefault="false"
mode="Opaque"
backcolor="#999999"
/>
<style
name="Detail_Line"
isDefault="false"
fontName="Bitstream Vera Sans"
fontSize="9"
>
<conditionalStyle>
<conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
<style
name="Detail_Line"
isDefault="false"
mode="Opaque"
backcolor="#CCCCCC"
fontName="Bitstream Vera Sans"
fontSize="9"
/>
</conditionalStyle>
</style>
<style
name="Total_Gray"
isDefault="false"
mode="Opaque"
forecolor="#000000"
backcolor="#CCCCCC"
/>
<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
</parameter>
<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
</parameter>
<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["(0, 1000000)"]]></defaultValueExpression>
</parameter>
<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
</parameter>
<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["Sale"]]></defaultValueExpression>
</parameter>
<parameter name="aux_client" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
</parameter>
<parameter name="aux_org" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
</parameter>
<parameter name="cCountryId" isForPrompting="true" class="java.lang.Integer">
<defaultValueExpression ><![CDATA[new Integer(100)]]></defaultValueExpression>
</parameter>
<parameter name="parDateFrom" isForPrompting="true" class="java.util.Date"/>
<parameter name="parDateTo" isForPrompting="true" class="java.util.Date"/>
<parameter name="ReportData" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
</parameter>
<parameter name="SALE" isForPrompting="false" class="java.lang.String"/>
<parameter name="DETAIL" isForPrompting="false" class="java.lang.String"/>
<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
<queryString><![CDATA[SELECT C_INVOICE.ISSOTRX AS SALES, 'Y' AS NATIONAL, C_INVOICE.DOCUMENTNO AS DOCUMENTNO, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME AS BPARTNER, LTRIM(RTRIM(C_TAX.NAME, ' '), ' ') AS TAXNAME,
SUM(C_INVOICETAX.TAXBASEAMT) AS TAXBASEAMT, SUM(C_INVOICETAX.TAXAMT) AS TAXAMT, '' AS ADTREEID
FROM C_TAX, C_INVOICETAX, C_INVOICE, C_BPARTNER_LOCATION, C_LOCATION, C_BPARTNER
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.PROCESSED = 'Y'
AND C_INVOICE.ISACTIVE = 'Y'
AND C_INVOICE.ISSOTRX = 'Y'
AND C_LOCATION.C_COUNTRY_ID = $P{cCountryId}
AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
AND C_INVOICE.DATEINVOICED < $P{parDateTo}
AND 1=1 $P!{aux_client}
AND 1=1 $P!{aux_org}
AND 1=1
GROUP BY C_INVOICE.DOCUMENTNO, C_INVOICE.DATEINVOICED, C_TAX.NAME, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED]]></queryString>
<field name="SALES" class="java.lang.String"/>
<field name="NATIONAL" class="java.lang.String"/>
<field name="DOCUMENTNO" 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"/>
<variable name="sumTaxBaseAmt" class="java.lang.Float" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
<variableExpression><![CDATA[new Float($F{TAXBASEAMT}.floatValue())]]></variableExpression>
</variable>
<variable name="sumImport" class="java.lang.Float" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
<variableExpression><![CDATA[new Float($F{TAXAMT}.floatValue())]]></variableExpression>
</variable>
<group name="TAXNAME" >
<groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
<groupHeader>
<band height="44" isSplitAllowed="true" >
<staticText>
<reportElement
style="GroupHeader_DarkGray"
x="1"
y="0"
width="100"
height="20"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font pdfFontName="Helvetica"/>
</textElement>
<text><![CDATA[Tax Type]]></text>
</staticText>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="GroupHeader_DarkGray"
x="101"
y="0"
width="433"
height="20"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font pdfFontName="Helvetica"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
x="0"
y="1"
width="0"
height="43"
forecolor="#555555"
key="line-2"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<line direction="TopDown">
<reportElement
x="534"
y="1"
width="0"
height="43"
forecolor="#555555"
key="line-3"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<staticText>
<reportElement
style="Detail_Header"
x="10"
y="28"
width="90"
height="16"
key="element-90">
<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
</reportElement>
<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<text><![CDATA[Invoice]]></text>
</staticText>
<staticText>
<reportElement
style="Detail_Header"
x="100"
y="28"
width="80"
height="16"
key="element-90">
<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
</reportElement>
<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<text><![CDATA[Date]]></text>
</staticText>
<staticText>
<reportElement
style="Detail_Header"
x="180"
y="28"
width="200"
height="16"
key="element-90">
<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
</reportElement>
<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<text><![CDATA[Business Partner]]></text>
</staticText>
<staticText>
<reportElement
style="Detail_Header"
x="380"
y="28"
width="60"
height="16"
key="element-90"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right">
<font/>
</textElement>
<text><![CDATA[Taxable Base]]></text>
</staticText>
<staticText>
<reportElement
style="Detail_Header"
x="440"
y="28"
width="80"
height="16"
key="element-90"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right">
<font/>
</textElement>
<text><![CDATA[Amount]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band height="25" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="0"
height="20"
forecolor="#555555"
key="line-32"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<line direction="TopDown">
<reportElement
x="534"
y="0"
width="0"
height="20"
forecolor="#555555"
key="line-33"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<line direction="TopDown">
<reportElement
x="0"
y="20"
width="535"
height="0"
forecolor="#555555"
key="line-34"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
<staticText>
<reportElement
style="default"
x="10"
y="1"
width="90"
height="16"
key="staticText-4"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right">
<font fontName="Bitstream Vera Sans"/>
</textElement>
<text><![CDATA[Total:]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Total_Field"
x="100"
y="1"
width="280"
height="16"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Total_Field"
x="380"
y="1"
width="60"
height="16"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.Float"><![CDATA[$V{sumTaxBaseAmt}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Total_Field"
x="440"
y="1"
width="80"
height="16"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.Float"><![CDATA[$V{sumImport}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
x="10"
y="0"
width="510"
height="0"
forecolor="#666666"
key="line-37"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</line>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Report_Subtitle"
x="0"
y="0"
width="535"
height="20"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
<line direction="TopDown">
<reportElement
x="534"
y="0"
width="0"
height="14"
forecolor="#555555"
key="line-16"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="0"
height="14"
forecolor="#555555"
key="line-17"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
</line>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Detail_Line"
x="10"
y="0"
width="90"
height="14"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Detail_Line"
x="100"
y="0"
width="80"
height="14"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Detail_Line"
x="180"
y="0"
width="200"
height="14"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Detail_Line"
x="380"
y="0"
width="60"
height="14"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT}):new String(" ")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
style="Detail_Line"
x="440"
y="0"
width="80"
height="14"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="Thin" rightBorderColor="#666666" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT}):new String(" ")]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>