change breceipt

1 files changed, 403 insertions, 364 deletions

diff --git a/jasper_reports/custom_reports/BReceipt.jrxml b/jasper_reports/custom_reports/BReceipt.jrxml
index bfae5d4..6b4d5df 100644
--- a/jasper_reports/custom_reports/BReceipt.jrxml
+++ b/jasper_reports/custom_reports/BReceipt.jrxml
@@ -1,364 +1,403 @@
-<?xml version="1.0" encoding="UTF-8"?>

-<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e  -->

-<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="BReceipt" pageWidth="612" pageHeight="792" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0ef21191-c59e-4de3-b220-ffbdeea78af3">

-	<property name="template.engine" value="tabular_template"/>

-	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Bill Receipt"/>

-	<property name="ODOO_RELATIONS">

-		<![CDATA[['bill_line']]]>

-	</property>

-	<queryString language="XPath">

-		<![CDATA[]]>

-	</queryString>

-	<field name="Document_Date-document_date" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_Date-document_date"/>

-		<fieldDescription><![CDATA[/data/record/Document_Date-document_date]]></fieldDescription>

-	</field>

-	<field name="Display_Name-display_name" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Display_Name-display_name"/>

-		<fieldDescription><![CDATA[/data/record/Display_Name-display_name]]></fieldDescription>

-	</field>

-	<field name="Document_No-number" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_No-number"/>

-		<fieldDescription><![CDATA[/data/record/Document_No-number]]></fieldDescription>

-	</field>

-	<field name="Reference-reference" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Reference-reference"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Reference-reference]]></fieldDescription>

-	</field>

-	<field name="Name-name" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Vendor-vendor_id/Name-name"/>

-		<fieldDescription><![CDATA[/data/record/Vendor-vendor_id/Name-name]]></fieldDescription>

-	</field>

-	<field name="ID-id" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/PO-po_id/ID-id"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/PO-po_id/ID-id]]></fieldDescription>

-	</field>

-	<field name="ID-id_1" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Sale_Order-sale_order_id/ID-id"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Sale_Order-sale_order_id/ID-id]]></fieldDescription>

-	</field>

-	<field name="Name-name_1" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Purchase_Rep-user_id/Name-name"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Purchase_Rep-user_id/Name-name]]></fieldDescription>

-	</field>

-	<field name="Total-amount_total" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Total-amount_total"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Total-amount_total]]></fieldDescription>

-	</field>

-	<field name="Payment_Terms-name" class="java.lang.String">

-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Payment_Terms-payment_term_id/Payment_Terms-name"/>

-		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Payment_Terms-payment_term_id/Payment_Terms-name]]></fieldDescription>

-	</field>

-	<variable name="Document_Date-document_date1" class="java.lang.Integer" calculation="Count">

-		<variableExpression><![CDATA[$F{Document_Date-document_date}]]></variableExpression>

-	</variable>

-	<variable name="Document_No-number1" class="java.lang.Integer" resetType="Page" calculation="Count">

-		<variableExpression><![CDATA[$F{Document_No-number}]]></variableExpression>

-	</variable>

-	<title>

-		<band height="158" splitType="Stretch">

-			<staticText>

-				<reportElement x="0" y="0" width="280" height="70" uuid="eea2399d-73cb-47d9-a575-cddc40ef8819"/>

-				<text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG

-Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16

-Penjaringan, Kec. Penjaringan, Jakarta

-JK 14440

-Indonesia]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="420" y="0" width="140" height="90" uuid="27894341-4205-46fc-966d-32b07de3e981"/>

-				<box>

-					<topPen lineWidth="0.5"/>

-					<leftPen lineWidth="0.5"/>

-					<bottomPen lineWidth="0.5"/>

-					<rightPen lineWidth="0.5"/>

-				</box>

-				<textElement textAlignment="Center" verticalAlignment="Top">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Note:

-Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto untuk dikirimkan ke kami melalui email finance@indoteknik.co.id atau melalui WA di +62 857-1697-0374]]></text>

-			</staticText>

-		</band>

-	</title>

-	<pageFooter>

-		<band height="120" splitType="Stretch">

-			<staticText>

-				<reportElement x="10" y="20" width="550" height="30" uuid="ad309ac6-49c2-4bb5-92d4-b8c6ebdae45d"/>

-				<textElement textAlignment="Center" verticalAlignment="Top">

-					<font size="16" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Tanda Terima Faktur]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="10" y="50" width="70" height="30" uuid="9dd4033f-6bd8-4a21-9878-0efea86d5319"/>

-				<textElement textAlignment="Left" verticalAlignment="Top">

-					<font isBold="true"/>

-				</textElement>

-				<text><![CDATA[Tagihan Ke : ]]></text>

-			</staticText>

-			<textField>

-				<reportElement x="80" y="50" width="290" height="30" uuid="9cbe5f9a-872c-4873-8a0b-a9362be36fbd"/>

-				<textElement textAlignment="Left" verticalAlignment="Top">

-					<font isBold="true"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression>

-			</textField>

-			<staticText>

-				<reportElement x="370" y="50" width="70" height="30" uuid="ebecd4d4-5d22-4440-a03f-b537eb827a1b"/>

-				<textElement textAlignment="Right" verticalAlignment="Top"/>

-				<text><![CDATA[Document No : ]]></text>

-			</staticText>

-			<textField>

-				<reportElement x="440" y="50" width="120" height="30" uuid="e5dff282-236e-4d2e-a4f0-70b4032d3d5d"/>

-				<textElement textAlignment="Right" verticalAlignment="Top"/>

-				<textFieldExpression><![CDATA[$V{Document_No-number1}]]></textFieldExpression>

-			</textField>

-			<staticText>

-				<reportElement x="10" y="80" width="20" height="20" uuid="54590dc5-e189-478a-a9fe-54a51a1a677d"/>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[No]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="30" y="80" width="90" height="20" uuid="f8b62d4c-b666-46d2-a82d-968eb240d43e">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[PO]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="120" y="80" width="70" height="20" uuid="1edac1ae-e5dc-4ace-bed1-12c2eb6d48c0">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Sale Order]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="190" y="80" width="110" height="20" uuid="3ebf70db-4cbc-4066-a790-9a05a8814d90">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Purchase Rep]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="300" y="80" width="110" height="20" uuid="48512b06-2905-4712-9e2e-5b2852063990">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Payment Terms]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="410" y="80" width="60" height="20" uuid="4e2aa7d8-cce6-459e-bfd4-248205eaf918">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Reference]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="470" y="80" width="90" height="20" uuid="76069fa8-c70c-4469-8d34-b023aea7e091">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement textAlignment="Right" verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Total]]></text>

-			</staticText>

-			<textField>

-				<reportElement x="10" y="100" width="20" height="20" uuid="c10fc01a-4011-4e12-a42b-9f63b97a8b28"/>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>

-			</textField>

-			<textField>

-				<reportElement x="30" y="100" width="90" height="20" uuid="2e560eaa-2226-4237-b988-af97a890811f">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{ID-id}]]></textFieldExpression>

-			</textField>

-			<textField pattern="MMM d, yyyy">

-				<reportElement x="120" y="100" width="70" height="20" uuid="3c5f4ac1-0854-42d7-9705-f8fbaaead0b8">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{ID-id_1}]]></textFieldExpression>

-			</textField>

-			<textField>

-				<reportElement x="190" y="100" width="110" height="20" uuid="edf6a029-40ee-485e-8b43-425a80c77267">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement textAlignment="Left" verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression>

-			</textField>

-			<textField>

-				<reportElement x="300" y="100" width="110" height="20" uuid="60a9c6ec-2c9f-4787-954d-b09957cf2b93">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Payment_Terms-name}]]></textFieldExpression>

-			</textField>

-			<textField pattern="MMM d, yyyy">

-				<reportElement x="410" y="100" width="60" height="20" uuid="d6c2f88b-5cc9-46a6-bf88-fca4ce6bd995">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Reference-reference}]]></textFieldExpression>

-			</textField>

-			<textField pattern="#,#00.00#;(#,#00.00#-)">

-				<reportElement x="470" y="100" width="90" height="20" uuid="799dc26d-3ed0-4e02-869d-2ef4050edc0b">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>

-				</reportElement>

-				<box>

-					<bottomPen lineWidth="0.5"/>

-				</box>

-				<textElement textAlignment="Right" verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Total-amount_total}]]></textFieldExpression>

-			</textField>

-		</band>

-	</pageFooter>

-	<summary>

-		<band height="200" splitType="Stretch">

-			<property name="local_mesure_unitheight" value="pixel"/>

-			<property name="com.jaspersoft.studio.unit.height" value="px"/>

-			<staticText>

-				<reportElement x="0" y="46" width="199" height="130" uuid="db925767-ec91-4de8-9e94-2ad98f0621cd"/>

-				<box>

-					<topPen lineWidth="0.0"/>

-					<leftPen lineWidth="0.0"/>

-					<bottomPen lineWidth="0.0"/>

-					<rightPen lineWidth="0.0"/>

-				</box>

-				<textElement textAlignment="Left" verticalAlignment="Top">

-					<font size="10"/>

-				</textElement>

-				<text><![CDATA[Pembayaran melalui Transfer ke :

-

-BCA

-PT. Indoteknik Dotcom Gemilang

-8870-4000-81

-

-Mandiri

-PT. Indoteknik Dotcom Gemilang

-155-0067-6869-75]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="480" y="58" width="90" height="107" uuid="582f1520-d98a-43c9-bb85-7cd2ba8c1353"/>

-				<text><![CDATA[Yang menerima,

-

-

-

-

-(                          )

-     Nama Jelas]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="258" y="70" width="110" height="19" uuid="b5650435-c486-4f5e-a3ee-98b990616f55"/>

-				<text><![CDATA[Yang menyerahkan,

-

-

-

-

-]]></text>

-			</staticText>

-			<image>

-				<reportElement x="250" y="90" width="126" height="59" uuid="da6eab8d-ec7e-4a61-8df1-c97c9dd264db"/>

-				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/1892527"]]></imageExpression>

-			</image>

-			<staticText>

-				<reportElement x="270" y="149" width="82" height="20" uuid="9bfa507d-c5cf-4243-9105-15e2e88ea006"/>

-				<textElement textAlignment="Center"/>

-				<text><![CDATA[Widya Riyanti]]></text>

-			</staticText>

-			<staticText>

-				<reportElement x="10" y="10" width="460" height="20" uuid="7c10712f-3e92-4c8f-ae48-8decc1b9c7f4">

-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>

-				</reportElement>

-				<box>

-					<leftPen lineWidth="0.0"/>

-					<bottomPen lineWidth="0.0"/>

-					<rightPen lineWidth="0.0"/>

-				</box>

-				<textElement textAlignment="Right" verticalAlignment="Middle">

-					<font size="8" isBold="true"/>

-				</textElement>

-				<text><![CDATA[Total]]></text>

-			</staticText>

-			<textField pattern="#,#00.###;(#,#00.###-)">

-				<reportElement x="470" y="10" width="90" height="20" uuid="c32830b3-6d75-4ab4-ae42-02f81612236e"/>

-				<box>

-					<leftPen lineWidth="0.0"/>

-					<bottomPen lineWidth="0.0"/>

-					<rightPen lineWidth="0.0"/>

-				</box>

-				<textElement textAlignment="Right" verticalAlignment="Middle">

-					<font size="8"/>

-				</textElement>

-				<textFieldExpression><![CDATA[$F{Total-amount_total}]]></textFieldExpression>

-			</textField>

-		</band>

-	</summary>

-</jasperReport>

+<?xml version="1.0" encoding="UTF-8"?>
+<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e  -->
+<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="BillReceipt" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="720bbad4-adde-4374-87d8-52060d7fa3c7">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="new bill receipt"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['bill_line']]]>
+	</property>
+	<queryString language="XPath">
+		<![CDATA[]]>
+	</queryString>
+	<field name="Total_Amount-total_amt" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Total_Amount-total_amt"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Total_Amount-total_amt]]></fieldDescription>
+	</field>
+	<field name="Open_Amount-open_amt" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Open_Amount-open_amt"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Open_Amount-open_amt]]></fieldDescription>
+	</field>
+	<field name="Reference-ref" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Reference-ref"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Reference-ref]]></fieldDescription>
+	</field>
+	<field name="Invoice_Bill_Date-invoice_date" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date]]></fieldDescription>
+	</field>
+	<field name="Due_Date-invoice_date_due" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Due_Date-invoice_date_due"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Due_Date-invoice_date_due]]></fieldDescription>
+	</field>
+	<field name="Outstanding_Amount-outstanding_amount" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount]]></fieldDescription>
+	</field>
+	<field name="Number-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Number-name"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Number-name]]></fieldDescription>
+	</field>
+	<field name="Name-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Customer-partner_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Customer-partner_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="Total-amount_total" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Total-amount_total"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Total-amount_total]]></fieldDescription>
+	</field>
+	<field name="eFaktur_Number-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Faktur_Pajak-efaktur_id/eFaktur_Number-name"/>
+		<fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Faktur_Pajak-efaktur_id/eFaktur_Number-name]]></fieldDescription>
+	</field>
+	<field name="Name-name_1" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Vendor-partner_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Vendor-partner_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="Document_No-number" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_No-number"/>
+		<fieldDescription><![CDATA[/data/record/Document_No-number]]></fieldDescription>
+	</field>
+	<variable name="total" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Total_Amount-total_amt})]]></variableExpression>
+	</variable>
+	<variable name="grand_total" class="java.math.BigDecimal" calculation="Sum">
+		<variableExpression><![CDATA[$V{total}]]></variableExpression>
+	</variable>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="140" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="280" height="70" uuid="a8a7304c-4b3e-49e1-b120-a5482251cfbf"/>
+				<text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG
+Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16
+Penjaringan, Kec. Penjaringan, Jakarta
+JK 14440
+Indonesia]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="80" width="550" height="30" uuid="e40afd9c-a77c-43cc-bbda-2e4651a833cc"/>
+				<textElement textAlignment="Center" verticalAlignment="Top">
+					<font size="16" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Tanda Tukar Faktur]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="110" width="550" height="30" uuid="5a989cb1-5c5d-449f-bc25-ca27fd30e4dd"/>
+				<textElement textAlignment="Center" verticalAlignment="Top">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text>
+			</staticText>
+		</band>
+	</title>
+	<pageHeader>
+		<band height="30" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="70" height="30" uuid="1f1275e3-7af0-4c59-88d9-26d4b35588ae"/>
+				<textElement textAlignment="Left" verticalAlignment="Top">
+					<font isBold="true"/>
+				</textElement>
+				<text><![CDATA[Tagihan Ke : ]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="70" y="0" width="290" height="30" uuid="04c27126-9fe1-4408-8dbf-cfced8e02aca"/>
+				<textElement textAlignment="Left" verticalAlignment="Top">
+					<font isBold="true"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="360" y="0" width="70" height="30" uuid="7fc8428e-9d84-46bc-a596-d2b1b1b2d911"/>
+				<textElement textAlignment="Right" verticalAlignment="Top"/>
+				<text><![CDATA[Document No : ]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="430" y="0" width="120" height="30" uuid="39b75cc4-fa56-4c67-9896-ee9eafbbc638"/>
+				<textElement textAlignment="Right" verticalAlignment="Top"/>
+				<textFieldExpression><![CDATA[$F{Document_No-number}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageHeader>
+	<columnHeader>
+		<band height="20" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="20" height="20" uuid="c3f04a2c-0071-4f3a-9027-fbba4d0fc428"/>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[No]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="20" y="0" width="90" height="20" uuid="bb1978fb-f5ab-4c6e-9967-9164b8406d8a">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Invoice]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="110" y="0" width="70" height="20" uuid="c07c62fa-9d20-4f87-98ee-9765952b1e6d">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Invoice Date]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="180" y="0" width="110" height="20" uuid="fd89030d-6c15-45d1-9b22-1801e7b46d69">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Faktur]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="290" y="0" width="110" height="20" uuid="4b8b5ced-c7d1-4553-add0-a96f016d9204">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Reference]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="460" y="0" width="90" height="20" uuid="4b55a424-baaa-4c60-90a6-fb87db30dc88">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Total]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="400" y="0" width="60" height="20" uuid="ae0915e4-83a8-4945-9ce1-d560303bf41c">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Due]]></text>
+			</staticText>
+		</band>
+	</columnHeader>
+	<detail>
+		<band height="20" splitType="Stretch">
+			<textField>
+				<reportElement x="0" y="0" width="20" height="20" uuid="630906d2-6d59-4224-ba90-fdc6e07dec7b"/>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="20" y="0" width="90" height="20" uuid="0a33350c-f826-4f92-b409-7f2b1eea58c6">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Number-name}]]></textFieldExpression>
+			</textField>
+			<textField pattern="MMM d, yyyy">
+				<reportElement x="110" y="0" width="70" height="20" uuid="b9715916-74c1-4892-8883-b681f7baf4cb">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Invoice_Bill_Date-invoice_date}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="180" y="0" width="110" height="20" uuid="4830ecbf-9739-4431-b0b8-3f1feb3b1f4d">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{eFaktur_Number-name}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="290" y="0" width="110" height="20" uuid="8c5d0138-c176-487d-9d12-1cb2b77a6609">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Reference-ref}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,#00.00#;(#,#00.00#-)">
+				<reportElement x="460" y="0" width="90" height="20" uuid="5d81a73c-3e98-45c0-a541-e5c299e2b8cd">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{total}]]></textFieldExpression>
+			</textField>
+			<textField pattern="MMM d, yyyy">
+				<reportElement x="400" y="0" width="60" height="20" uuid="ce215c7b-d245-4bbd-9f91-01a07b09c8e7">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Due_Date-invoice_date_due}]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<pageFooter>
+		<band height="10" splitType="Stretch">
+			<textField evaluationTime="Report">
+				<reportElement x="520" y="0" width="30" height="10" uuid="b4e2c64a-ca50-4b8e-b38e-5ff236c9cf4f"/>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="501" y="0" width="19" height="10" uuid="0c34157a-cc68-4789-aef9-957a96ab8a97"/>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[dari]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="471" y="0" width="30" height="10" uuid="9deade00-e339-411d-9187-5e18dbba9d24"/>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="432" y="0" width="39" height="10" uuid="aefef729-4eae-4f92-9c66-30a7a53f55d0"/>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Halaman]]></text>
+			</staticText>
+		</band>
+	</pageFooter>
+	<summary>
+		<band height="160" splitType="Stretch">
+			<textField pattern="#,#00.###;(#,#00.###-)">
+				<reportElement x="460" y="0" width="90" height="20" uuid="12f22b10-d8f4-4f94-b2d0-993fda701e9e"/>
+				<box>
+					<pen lineWidth="1.0"/>
+					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{grand_total}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="400" y="0" width="60" height="20" uuid="4a2c174b-a7a3-4620-8bd3-6dd57eee600d">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="0.5"/>
+					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Total]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="390" y="31" width="90" height="107" uuid="a5d971ef-fa8e-4ced-b7b9-cf3861e26a2d"/>
+				<text><![CDATA[Yang menerima,
+
+
+
+
+(                          )
+     Nama Jelas]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="80" y="31" width="110" height="19" uuid="2d02021f-ffd3-4694-917d-0bf584038278"/>
+				<text><![CDATA[Yang menyerahkan,
+
+
+
+
+]]></text>
+			</staticText>
+			<image>
+				<reportElement x="72" y="50" width="126" height="59" uuid="7ddbd82e-5e16-4e91-8220-26b35cef48db"/>
+				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2011786"]]></imageExpression>
+			</image>
+			<staticText>
+				<reportElement x="72" y="110" width="126" height="40" uuid="526748bf-97a4-470e-a0a9-4530098f3048"/>
+				<textElement textAlignment="Center"/>
+				<text><![CDATA[( 	                      )
+Nama Jelas]]></text>
+			</staticText>
+		</band>
+	</summary>
+</jasperReport>