diff options
Diffstat (limited to 'jasper_reports/custom_reports/Journal_Entries.jrxml')
| -rw-r--r-- | jasper_reports/custom_reports/Journal_Entries.jrxml | 180 |
1 files changed, 180 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/Journal_Entries.jrxml b/jasper_reports/custom_reports/Journal_Entries.jrxml new file mode 100644 index 0000000..1466d87 --- /dev/null +++ b/jasper_reports/custom_reports/Journal_Entries.jrxml @@ -0,0 +1,180 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<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="Journal_Entries" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="854acef6-eb08-4fac-888a-f2a2ad7ebcbc"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Account Move"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['line_ids']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Number-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Number-name"/> + <fieldDescription><![CDATA[/data/record/Number-name]]></fieldDescription> + </field> + <field name="Reference-ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Reference-ref"/> + <fieldDescription><![CDATA[/data/record/Reference-ref]]></fieldDescription> + </field> + <field name="label_line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Label-name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Label-name]]></fieldDescription> + </field> + <field name="display_name_line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Display_Name-display_name]]></fieldDescription> + </field> + <field name="display_name_partner" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Debit-debit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Debit-debit"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Debit-debit]]></fieldDescription> + </field> + <field name="Credit-credit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Credit-credit"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Credit-credit]]></fieldDescription> + </field> + <field name="Quantity-quantity" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Quantity-quantity"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Quantity-quantity]]></fieldDescription> + </field> + <variable name="debit" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Debit-debit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Debit-debit})]]></variableExpression> + </variable> + <variable name="credit" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Credit-credit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Credit-credit})]]></variableExpression> + </variable> + <variable name="qty" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Quantity-quantity}.equals("")?new BigDecimal("0"):new BigDecimal($F{Quantity-quantity})]]></variableExpression> + </variable> + <variable name="total_debit" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$V{debit}]]></variableExpression> + </variable> + <variable name="total_credit" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$V{credit}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="70" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="550" height="70" uuid="29a55e19-4078-41c5-a2fb-2a3ceceb3dfa"/> + <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> + </band> + </title> + <pageHeader> + <band height="30" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="550" height="30" forecolor="#2105F2" uuid="76b1b8a3-1bd7-4e23-8882-2e440811e56f"/> + <textElement> + <font size="14"/> + </textElement> + <textFieldExpression><![CDATA[$F{Number-name}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="20" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="280" height="20" uuid="b3eef15d-1163-4ccd-aa88-13a6fa569dce"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2bb9801f-c69f-4473-a023-d94a92db34d4"/> + </reportElement> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[Description]]></text> + </staticText> + <staticText> + <reportElement x="350" y="0" width="100" height="20" uuid="fc5562bc-f6fb-4cc2-ab6b-3ba02c99b96c"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5e9d9201-62b1-4880-a4d4-0b3753fcaebf"/> + </reportElement> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <text><![CDATA[Debit]]></text> + </staticText> + <staticText> + <reportElement x="450" y="0" width="100" height="20" uuid="546e7ad9-a211-48dc-b5a0-1662630b1e94"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a36100ad-7b82-4cf8-9d26-a72c2aa4b9bc"/> + </reportElement> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <text><![CDATA[Credit]]></text> + </staticText> + <staticText> + <reportElement x="280" y="0" width="70" height="20" uuid="60bcdaba-60ef-4ead-a503-94336d3a43a1"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5e9d9201-62b1-4880-a4d4-0b3753fcaebf"/> + </reportElement> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <text><![CDATA[Debit]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="30" splitType="Stretch"> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="350" y="0" width="100" height="30" uuid="8e4d064c-63fb-4a17-9d85-09fa779e058a"/> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{debit}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="450" y="0" width="100" height="30" uuid="e0d06b19-013a-45be-aa2f-5a0655231da5"/> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{credit}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="280" y="0" width="70" height="30" uuid="06327ba4-6483-4655-a70a-093c40adcf97"/> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{qty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="0" width="280" height="30" uuid="45307df6-d313-4147-b216-905f47c91539"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f8348c97-3314-4f6a-8aca-f57a496fcca6"/> + </reportElement> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{label_line}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="30" splitType="Stretch"> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="350" y="0" width="100" height="30" uuid="ba1b84a4-c1e0-4d02-a0db-e9313e4d2ecc"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{total_debit}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="450" y="0" width="100" height="30" uuid="9a350fee-cfee-4b63-9bae-ec388e8ddbc2"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{total_credit}]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> |