From e57142c818fd98df32de2085d0caa8724ae12430 Mon Sep 17 00:00:00 2001
From: root
 <root@prod-erp-indoteknikcom.asia-southeast2-a.c.project-indoteknik-com.internal>
Date: Fri, 30 May 2025 10:38:36 +0700
Subject: add custom report collective

---
 .../custom_reports/Customer Comision.jrxml         | 571 +++++++++++++++------
 1 file changed, 402 insertions(+), 169 deletions(-)

(limited to 'jasper_reports/custom_reports/Customer Comision.jrxml')

diff --git a/jasper_reports/custom_reports/Customer Comision.jrxml b/jasper_reports/custom_reports/Customer Comision.jrxml
index 820a595..df975b9 100644
--- a/jasper_reports/custom_reports/Customer Comision.jrxml	
+++ b/jasper_reports/custom_reports/Customer Comision.jrxml	
@@ -1,289 +1,522 @@
 <?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="Customer Comision" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="267dd142-45c8-4e58-bdae-72f60761b287">
-	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Customer Comision"/>
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="cccuki.jrdax"/>
 	<property name="ODOO_RELATIONS">
 		<![CDATA[['commision_lines']]]>
 	</property>
 	<queryString language="XPath">
 		<![CDATA[]]>
 	</queryString>
-	<field name="Document No" class="java.lang.String">
+	<field name="Partner" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_ids/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Partner-partner_ids/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="INVOICE NO" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Group_Invoice_Number-grouped_invoice_number"/>
+		<fieldDescription><![CDATA[/data/record/Group_Invoice_Number-grouped_invoice_number]]></fieldDescription>
+	</field>
+	<field name="SO NO" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Group_SO_Number-grouped_so_number"/>
+		<fieldDescription><![CDATA[/data/record/Group_SO_Number-grouped_so_number]]></fieldDescription>
+	</field>
+	<field name="Nominal" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/>
+		<fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription>
+	</field>
+	<field name="Terbilang" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount_Text-commision_amt_text"/>
+		<fieldDescription><![CDATA[/data/record/Commision_Amount_Text-commision_amt_text]]></fieldDescription>
+	</field>
+	<field name="Bank" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bank-bank_name"/>
+		<fieldDescription><![CDATA[/data/record/Bank-bank_name]]></fieldDescription>
+	</field>
+	<field name="Account No" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Account_No-bank_account"/>
+		<fieldDescription><![CDATA[/data/record/Account_No-bank_account]]></fieldDescription>
+	</field>
+	<field name="Account Name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Account_Name-account_name"/>
+		<fieldDescription><![CDATA[/data/record/Account_Name-account_name]]></fieldDescription>
+	</field>
+	<field name="Keterangan" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Keterangan-note_transfer"/>
+		<fieldDescription><![CDATA[/data/record/Keterangan-note_transfer]]></fieldDescription>
+	</field>
+	<field name="Approved_By-approved_by" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Approved_By-approved_by"/>
+		<fieldDescription><![CDATA[/data/record/Approved_By-approved_by]]></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="Partner Name" class="java.lang.String">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_ids/Name-name"/>
-		<fieldDescription><![CDATA[/data/record/Partner-partner_ids/Name-name]]></fieldDescription>
+	<field name="Date_Approved_Accounting-date_approved_accounting" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Accounting-date_approved_accounting"/>
+		<fieldDescription><![CDATA[/data/record/Date_Approved_Accounting-date_approved_accounting]]></fieldDescription>
+	</field>
+	<field name="Date_Approved_Marketing-date_approved_marketing" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Marketing-date_approved_marketing"/>
+		<fieldDescription><![CDATA[/data/record/Date_Approved_Marketing-date_approved_marketing]]></fieldDescription>
 	</field>
-	<field name="Partner Name Line" class="java.lang.String">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Customer-partner_id/Name-name"/>
-		<fieldDescription><![CDATA[/data/record/Lines-commision_lines/Customer-partner_id/Name-name]]></fieldDescription>
+	<field name="Date_Approved_Pimpinan-date_approved_pimpinan" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Pimpinan-date_approved_pimpinan"/>
+		<fieldDescription><![CDATA[/data/record/Date_Approved_Pimpinan-date_approved_pimpinan]]></fieldDescription>
 	</field>
-	<field name="Invoice Name" class="java.lang.String">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name"/>
-		<fieldDescription><![CDATA[/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name]]></fieldDescription>
+	<field name="Date_Approved_Sales-date_approved_sales" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Sales-date_approved_sales"/>
+		<fieldDescription><![CDATA[/data/record/Date_Approved_Sales-date_approved_sales]]></fieldDescription>
 	</field>
-	<field name="DPP" class="java.math.BigDecimal">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/DPP-dpp"/>
-		<fieldDescription><![CDATA[/data/record/Lines-commision_lines/DPP-dpp]]></fieldDescription>
+	<field name="Position_Accounting-position_accounting" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Accounting-position_accounting"/>
+		<fieldDescription><![CDATA[/data/record/Position_Accounting-position_accounting]]></fieldDescription>
 	</field>
-	<field name="Total Margin" class="java.math.BigDecimal">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Total_Margin-total_percent_margin"/>
-		<fieldDescription><![CDATA[/data/record/Lines-commision_lines/Total_Margin-total_percent_margin]]></fieldDescription>
+	<field name="Position_Marketing-position_marketing" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Marketing-position_marketing"/>
+		<fieldDescription><![CDATA[/data/record/Position_Marketing-position_marketing]]></fieldDescription>
 	</field>
-	<field name="Status Invoice" class="java.lang.String">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/InvStatus-state"/>
-		<fieldDescription><![CDATA[/data/record/Lines-commision_lines/InvStatus-state]]></fieldDescription>
+	<field name="Position_Pimpinan-position_pimpinan" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Pimpinan-position_pimpinan"/>
+		<fieldDescription><![CDATA[/data/record/Position_Pimpinan-position_pimpinan]]></fieldDescription>
 	</field>
-	<field name="Date From" class="java.sql.Date">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_From-date_from"/>
-		<fieldDescription><![CDATA[/data/record/Date_From-date_from]]></fieldDescription>
+	<field name="Position_Sales-position_sales" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Sales-position_sales"/>
+		<fieldDescription><![CDATA[/data/record/Position_Sales-position_sales]]></fieldDescription>
 	</field>
-	<field name="Date To" class="java.sql.Date">
-		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_To-date_to"/>
-		<fieldDescription><![CDATA[/data/record/Date_To-date_to]]></fieldDescription>
+	<field name="Display_Name-display_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales-sales_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Sales-sales_id/Display_Name-display_name]]></fieldDescription>
 	</field>
-	<field name="Total DPP" class="java.math.BigDecimal">
+	<field name="Created_on-create_date" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_on-create_date"/>
+		<fieldDescription><![CDATA[/data/record/Created_on-create_date]]></fieldDescription>
+	</field>
+	<field name="Notes_Finnance-note_finnance" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Notes_Finnance-note_finnance"/>
+		<fieldDescription><![CDATA[/data/record/Notes_Finnance-note_finnance]]></fieldDescription>
+	</field>
+	<field name="Total_DPP-total_dpp" class="java.lang.String">
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total_DPP-total_dpp"/>
 		<fieldDescription><![CDATA[/data/record/Total_DPP-total_dpp]]></fieldDescription>
 	</field>
-	<field name="Commision Amount" class="java.math.BigDecimal">
+	<field name="Commision_Amount-commision_amt" class="java.math.BigDecimal">
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/>
 		<fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription>
 	</field>
-	<field name="Commision %" class="java.math.BigDecimal">
+	<field name="Commision__-commision_percent" class="java.lang.String">
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision__-commision_percent"/>
 		<fieldDescription><![CDATA[/data/record/Commision__-commision_percent]]></fieldDescription>
 	</field>
-	<variable name="DPP" class="java.math.BigDecimal" incrementType="Column">
-		<variableExpression><![CDATA[$F{DPP}]]></variableExpression>
-	</variable>
-	<variable name="Total_Margin" class="java.math.BigDecimal" incrementType="Column">
-		<variableExpression><![CDATA[$F{Total Margin}]]></variableExpression>
-	</variable>
-	<variable name="Commision_%" class="java.math.BigDecimal" incrementType="Column">
-		<variableExpression><![CDATA[$F{Commision %}]]></variableExpression>
-	</variable>
-	<variable name="Commision_Amount" class="java.math.BigDecimal" incrementType="Column">
-		<variableExpression><![CDATA[$F{Commision Amount}]]></variableExpression>
-	</variable>
-	<variable name="Total DPP" class="java.math.BigDecimal" incrementType="Column">
-		<variableExpression><![CDATA[$F{Total DPP}]]></variableExpression>
-	</variable>
+	<field name="Commision_Amount-commision_amt_1" class="java.lang.Float">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/>
+		<fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription>
+	</field>
+	<field name="Commision_Amount-commision_amt_2" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/>
+		<fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription>
+	</field>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
 	<title>
-		<band height="204" splitType="Stretch">
+		<band height="90" splitType="Stretch">
+			<image>
+				<reportElement x="0" y="1" width="151" height="49" uuid="c596ef6c-086a-4136-a96d-7e0ba6a369ca"/>
+				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression>
+			</image>
+			<staticText>
+				<reportElement x="131" y="55" width="293" height="30" uuid="fb2717c3-16e5-498b-a9a4-658c12e80cce">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="1.75"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="14" isBold="true"/>
+				</textElement>
+				<text><![CDATA[PENGAJUAN KOMISI EKSTERNAL]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="418" y="32" width="157" height="25" uuid="23a30f84-be11-43dc-8469-6e5a3affbd50"/>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="14" isBold="true"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Document_No-number}]]></textFieldExpression>
+			</textField>
 			<textField>
-				<reportElement x="151" y="0" width="253" height="50" uuid="ad497d39-25aa-4e99-888a-6e3221d070e4"/>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression>
+				<reportElement x="418" y="12" width="157" height="20" uuid="f5142e3c-8a9b-49b0-a3d6-250480d08d06"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression>
+			</textField>
+			<textField pattern="MMM d, yyyy h:mm:ss a">
+				<reportElement x="418" y="58" width="157" height="30" uuid="2d713832-ad16-4ab5-977b-c473950aa3e7"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Created_on-create_date}]]></textFieldExpression>
 			</textField>
 			<staticText>
-				<reportElement x="1" y="55" width="100" height="30" uuid="3e8e85ed-c77c-4377-80b4-f8817995f545">
+				<reportElement x="418" y="-18" width="157" height="30" uuid="0d135bef-745f-4466-9d6d-682350dacd30">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Partner Name ]]></text>
+				<text><![CDATA[Diajukan Oleh Sales:]]></text>
 			</staticText>
-			<textField>
-				<reportElement x="105" y="55" width="455" height="30" uuid="d859b5fd-d805-4c86-a1c7-617fa72a3a25">
+		</band>
+	</title>
+	<columnHeader>
+		<band height="679">
+			<staticText>
+				<reportElement x="6" y="31" width="100" height="57" uuid="84e40804-8a4c-45b7-989d-a494f7bab127">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Partner Name}]]></textFieldExpression>
-			</textField>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[No. SO]]></text>
+			</staticText>
 			<staticText>
-				<reportElement x="1" y="90" width="100" height="30" uuid="850d8de0-d90d-4d7b-a6cf-c7279c1d49da">
+				<reportElement x="6" y="1" width="100" height="30" uuid="2ebffff5-278d-4d33-a990-e0e250c49025">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Date From ]]></text>
+				<text><![CDATA[Nama Penerima]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="360" y="91" width="66" height="30" uuid="5f75f83a-e4bf-441d-94dd-4bb0a6b98ef6">
+				<reportElement x="6" y="88" width="100" height="58" uuid="555a644d-6776-467f-96a3-054353bc29a1">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Date To]]></text>
+				<text><![CDATA[No. Invoice]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="1" y="127" width="100" height="30" uuid="ee030619-4aa4-4c1b-bf18-94b8a4b77578">
+				<reportElement x="5" y="146" width="100" height="30" uuid="e267a3de-4e3f-4efa-97c3-dd08cad87556">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Commision % ]]></text>
+				<text><![CDATA[Keterangan :]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="0" y="167" width="100" height="30" uuid="9a60a3ae-72dc-4a06-84be-3ecf879bc7be">
+				<reportElement x="20" y="176" width="225" height="30" uuid="99d2f90f-bb3c-452a-a137-9d1319ae3847">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Commision Amount ]]></text>
+				<text><![CDATA[PT. Indoteknik Dotcom Gemilang]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="360" y="164" width="66" height="30" uuid="e1c94634-0398-4d98-843e-8e2a3286b427">
+				<reportElement x="6" y="206" width="154" height="30" uuid="03195972-9b6f-4759-abe1-3a828c4c89bc">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<textElement textAlignment="Left" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="12" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Total DPP ]]></text>
+				<text><![CDATA[Jumlah yang penerimaan ]]></text>
 			</staticText>
-			<textField pattern="MMMM d, yyyy">
-				<reportElement x="105" y="90" width="100" height="30" uuid="7b9631c0-b30e-4e5d-9061-768bfe786b8d"/>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Date From}]]></textFieldExpression>
+			<staticText>
+				<reportElement x="6" y="227" width="154" height="30" uuid="c76fb1a8-ad22-413b-8211-bdc793d550ed">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Nominal ]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="6" y="258" width="154" height="30" uuid="5aa87439-2f82-4bb1-812d-0a2964bff8f0">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Terbilang]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="6" y="293" width="154" height="30" uuid="d1604fef-020b-4995-8ccf-709ffb23d3cf">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Keterangan Penerimaan :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="19" y="316" width="225" height="30" uuid="54d1a728-4507-45a8-bd2f-7c18df87f244">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Transfer Via Bank]]></text>
+			</staticText>
+			<ellipse>
+				<reportElement x="29" y="354" width="11" height="10" backcolor="#000000" uuid="654a71b1-2fa9-4e6e-b4c0-589792610243"/>
+			</ellipse>
+			<staticText>
+				<reportElement x="50" y="348" width="130" height="19" uuid="b68e58d0-0963-4c1a-8b8c-48ab389a49aa">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Bank]]></text>
+			</staticText>
+			<ellipse>
+				<reportElement x="29" y="384" width="11" height="10" backcolor="#000000" uuid="d70730c7-a2cc-4ac6-be95-8d50d24ac54a"/>
+			</ellipse>
+			<staticText>
+				<reportElement x="50" y="378" width="130" height="19" uuid="c6774fa3-5aad-4e1f-8582-c0ee2d95fa1f">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Nama Account]]></text>
+			</staticText>
+			<ellipse>
+				<reportElement x="29" y="414" width="11" height="10" backcolor="#000000" uuid="7dc9788f-3a2d-45e4-b16b-204ddda21f7a"/>
+			</ellipse>
+			<staticText>
+				<reportElement x="50" y="406" width="130" height="22" uuid="6a3d8b74-2440-4b69-b957-cfab743f76d6">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[No. Rekening]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="6" y="430" width="154" height="30" uuid="7c69e54b-6885-4957-940f-61837dffb454">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="12" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Keterangan Penerimaan :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="340" y="480" width="170" height="30" uuid="bbaa03e0-bf1f-4949-ac79-a3a00e739f5f">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
+				</reportElement>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Approved By System:]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="106" y="1" width="468" height="30" uuid="6b5b90d1-6d70-492c-b999-2734271b3a39"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Partner}]]></textFieldExpression>
 			</textField>
-			<textField pattern="MMMM d, yyyy">
-				<reportElement x="430" y="91" width="100" height="30" uuid="f066682f-eabd-477e-8895-8455f49d2579"/>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Date To}]]></textFieldExpression>
+			<textField>
+				<reportElement x="106" y="88" width="468" height="58" uuid="8ec34349-c8bf-46f9-9738-b1fc81a8f85a"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[": " + $F{INVOICE NO}]]></textFieldExpression>
 			</textField>
-			<textField pattern="#,#00.00#;(#,#00.00#-)">
-				<reportElement x="430" y="164" width="124" height="30" uuid="6983367e-a6f1-409f-be98-3cfa7f6f77b3"/>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Total DPP}]]></textFieldExpression>
+			<textField>
+				<reportElement x="106" y="31" width="468" height="58" uuid="328c0a2f-7ca8-41b8-ab7e-f740e2a7aaa9"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[": " + $F{SO NO}]]></textFieldExpression>
 			</textField>
-			<textField pattern="#,#00.00#;(#,#00.00#-)">
-				<reportElement x="105" y="162" width="164" height="30" uuid="8c626b25-555a-4681-b491-0ab1d0321cde"/>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[ $F{Commision Amount}]]></textFieldExpression>
+			<textField>
+				<reportElement x="160" y="258" width="415" height="30" uuid="ab9ced78-6663-4ea7-9ed7-20181a05f64d"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Terbilang}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="105" y="127" width="100" height="30" uuid="e2ebe3a4-f126-440b-b057-96126ad5098e"/>
-				<textElement textAlignment="Left" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Commision %} + " %"]]></textFieldExpression>
+				<reportElement x="180" y="348" width="394" height="19" uuid="fd758a7a-c789-4373-ab74-648d2d8c18c3"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Bank}]]></textFieldExpression>
 			</textField>
-		</band>
-	</title>
-	<columnHeader>
-		<band height="30" splitType="Stretch">
-			<staticText>
-				<reportElement x="0" y="0" width="156" height="30" uuid="17571371-537e-4cb7-a11c-db822e33e074">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/>
-				</reportElement>
+			<textField>
+				<reportElement x="180" y="406" width="394" height="22" uuid="559cfb4b-8348-465e-9136-d103de29a366"/>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="1.0"/>
 				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Account No}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="180" y="378" width="394" height="19" uuid="40d0fbb2-7089-4c58-ab1d-988120be4109"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Account Name}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="160" y="430" width="414" height="30" uuid="476f2174-e622-4246-b5ad-f16610aa55c9"/>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[": " + $F{Keterangan}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="470" y="630" width="84" height="20" uuid="177c1bf7-1e57-4a7d-9008-684efeaf3a80"/>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[Customer]]></text>
-			</staticText>
+				<textFieldExpression><![CDATA[$F{Date_Approved_Accounting-date_approved_accounting}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="347" y="630" width="84" height="20" uuid="9c70e307-2abd-4bb9-8f0e-895ea9c7afa2"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Date_Approved_Marketing-date_approved_marketing}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="470" y="531" width="84" height="20" uuid="40f198dd-6ad4-4c8a-b161-61df3730f692"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Date_Approved_Pimpinan-date_approved_pimpinan}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="347" y="531" width="84" height="20" uuid="a5d9a20d-330b-4269-9048-ac756f3959be"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Date_Approved_Sales-date_approved_sales}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="470" y="650" width="84" height="20" uuid="d7ab58c7-3853-4ef4-9da9-8170eae41343"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Position_Accounting-position_accounting}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="347" y="650" width="84" height="20" uuid="f45ed865-8398-4520-b79d-a394a935d71f"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Position_Marketing-position_marketing}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="347" y="551" width="84" height="20" uuid="4445689c-e1fb-4290-ad5c-6f340c5253cd"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Position_Sales-position_sales}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="470" y="551" width="84" height="20" uuid="5862a49e-aeb2-4c46-9155-2562a90eaf66"/>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Position_Pimpinan-position_pimpinan}]]></textFieldExpression>
+			</textField>
 			<staticText>
-				<reportElement x="156" y="0" width="160" height="30" uuid="2adc8d84-e0bd-4ce2-bc82-9b80178a78e6">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/>
+				<reportElement x="347" y="510" width="84" height="20" uuid="6f80b179-970d-489a-95cf-7ea7fc826af1">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="1.75"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="9" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Invoice]]></text>
+				<text><![CDATA[Novita Mayasari]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="316" y="0" width="64" height="30" uuid="4bde0bed-2421-4557-a45f-5a665f2ba080">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/>
+				<reportElement x="470" y="510" width="84" height="20" uuid="2606b5d5-8479-464d-ae32-85baa2857309">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="1.75"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="9" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Status Invoice]]></text>
+				<text><![CDATA[Akbar Prabawa]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="380" y="0" width="75" height="30" uuid="9a00a7e1-900b-4d6b-bdeb-3b7f0f7e6a5d">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="70d6c4bd-60d2-4606-b48b-2c2f9e15ff92"/>
+				<reportElement x="347" y="610" width="84" height="20" uuid="3dd59c77-0427-43d8-a838-c0e29b40cbce">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="1.75"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="9" isBold="true"/>
 				</textElement>
-				<text><![CDATA[DPP]]></text>
+				<text><![CDATA[Stefanus Darren]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="455" y="0" width="100" height="30" uuid="f4a50d94-89b5-4f23-818d-fadcc0f34092">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0917b22c-3856-447c-ac45-689148535ef7"/>
+				<reportElement x="470" y="610" width="84" height="20" uuid="ee4f1a9c-9318-48b7-8bf0-4c8ad9478809">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="1.75"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font isBold="true"/>
+					<font size="9" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Total Margin]]></text>
+				<text><![CDATA[Tania Aji Asri]]></text>
 			</staticText>
-		</band>
-	</columnHeader>
-	<detail>
-		<band height="43" splitType="Stretch">
 			<textField>
-				<reportElement x="0" y="0" width="156" height="42" uuid="20886f7d-e695-42f4-8274-7e7424c74a6f">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/>
-				</reportElement>
-				<box>
-					<bottomPen lineWidth="0.75"/>
-				</box>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Partner Name Line}]]></textFieldExpression>
+				<reportElement x="1" y="510" width="308" height="168" uuid="34d3e4b9-8e14-4d72-9277-df79b4ca7e88"/>
+				<textFieldExpression><![CDATA[$F{Notes_Finnance-note_finnance}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="156" y="0" width="160" height="42" uuid="1153f0c3-8080-4f61-8fb7-21d743546826">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/>
+			<staticText>
+				<reportElement x="1" y="480" width="100" height="30" uuid="ad926945-9613-40ae-a17e-642359cb8b79">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
 				<box>
-					<bottomPen lineWidth="0.75"/>
+					<bottomPen lineWidth="0.0"/>
 				</box>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Invoice Name}]]></textFieldExpression>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="11" isBold="true" isUnderline="false"/>
+				</textElement>
+				<text><![CDATA[Note Finance :]]></text>
+			</staticText>
+			<textField pattern="#,#00.00#;#,#00.00#-">
+				<reportElement x="180" y="227" width="394" height="30" uuid="50e6f714-8b62-44e9-b2a5-df3876138c7e"/>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Commision_Amount-commision_amt_2}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="316" y="0" width="64" height="42" uuid="c702275c-c708-4f27-9f81-fb40ccaefa7f">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/>
+			<staticText>
+				<reportElement x="160" y="227" width="20" height="30" uuid="6215e691-9bbf-4f3f-a875-dee58d252f33">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/>
 				</reportElement>
-				<box>
-					<bottomPen lineWidth="0.75"/>
-				</box>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{Status Invoice}]]></textFieldExpression>
-			</textField>
-			<textField pattern="#,#00.00#;(#,#00.00#-)">
-				<reportElement x="380" y="0" width="75" height="42" uuid="f55b5f39-7f6e-4d42-8cfb-bdb990b4991e"/>
-				<box>
-					<bottomPen lineWidth="0.75"/>
-				</box>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$V{DPP}]]></textFieldExpression>
-			</textField>
-			<textField>
-				<reportElement x="455" y="0" width="100" height="42" uuid="fb2ba136-db4c-4c37-ab43-9616acf30398"/>
-				<box>
-					<bottomPen lineWidth="0.75"/>
-				</box>
-				<textElement textAlignment="Center" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$V{Total_Margin}]]></textFieldExpression>
-			</textField>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="10" isBold="false"/>
+				</textElement>
+				<text><![CDATA[: Rp ]]></text>
+			</staticText>
 		</band>
-	</detail>
-	<summary>
-		<band height="75" splitType="Stretch"/>
-	</summary>
+	</columnHeader>
 </jasperReport>
-- 
cgit v1.2.3