<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.6.final using JasperReports Library version 6.20.6-5c96b6aa8a39ac1dc6b6bea4b81168e16dd39231  -->
<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="Shipment Lines A5" language="groovy" isFloatColumnFooter="true" pageWidth="370" pageHeight="595" whenNoDataType="AllSectionsNoDetail" columnWidth="370" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="5b0c2a7e-3d4f-4c8a-9e1b-7a2f6d0c4e91">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="iDempiere Production"/>
	<template><![CDATA["styles.jrtx"]]></template>
	<parameter name="RECORD_ID" class="java.lang.Integer" isForPrompting="false">
		<defaultValueExpression><![CDATA[1036057]]></defaultValueExpression>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT
    il.line,
    il.m_inoutline_id,
    il.m_product_id,
    iol.c_charge_id,
    COALESCE(il.qtyentered, il.movementqty)          AS qty,
    il.uomsymbol,
    COALESCE(p.value, il.productvalue)               AS productvalue,
    NULLIF(btrim(il.upc), '')                        AS upc,
    NULLIF(btrim(p.sku), '')                         AS sku,
    NULLIF(btrim(p.mpn), '')                         AS mpn,
    COALESCE(pt.name, ct.name, ch.name, il.name)     AS name,
    NULLIF(btrim(iol.description), '')               AS description,
    COALESCE(NULLIF(btrim(pt.documentnote), ''),
             NULLIF(btrim(il.documentnote), ''))     AS documentnote,
    il.m_locator_value,
    il.m_inout_id                                    AS record_id
FROM m_inout_line_v il
JOIN m_inoutline iol       ON iol.m_inoutline_id = il.m_inoutline_id
LEFT JOIN m_product p      ON p.m_product_id = il.m_product_id
LEFT JOIN m_product_trl pt ON pt.m_product_id = p.m_product_id AND pt.ad_language = 'de_DE'
LEFT JOIN c_charge ch      ON ch.c_charge_id = iol.c_charge_id
LEFT JOIN c_charge_trl ct  ON ct.c_charge_id = ch.c_charge_id AND ct.ad_language = 'de_DE'
WHERE il.m_inout_id = $P{RECORD_ID}
  AND iol.isdescription = 'N'
  AND (il.m_product_id IS NOT NULL OR iol.c_charge_id IS NOT NULL)
ORDER BY il.line, il.m_inoutline_id]]>
	</queryString>
	<field name="line" class="java.math.BigDecimal"/>
	<field name="m_inoutline_id" class="java.lang.Integer"/>
	<field name="m_product_id" class="java.lang.Integer"/>
	<field name="c_charge_id" class="java.lang.Integer"/>
	<field name="qty" class="java.math.BigDecimal"/>
	<field name="uomsymbol" class="java.lang.String"/>
	<field name="productvalue" class="java.lang.String"/>
	<field name="upc" class="java.lang.String"/>
	<field name="sku" class="java.lang.String"/>
	<field name="mpn" class="java.lang.String"/>
	<field name="name" class="java.lang.String"/>
	<field name="description" class="java.lang.String"/>
	<field name="documentnote" class="java.lang.String"/>
	<field name="m_locator_value" class="java.lang.String"/>
	<field name="record_id" class="java.lang.Integer"/>
	<columnHeader>
		<band height="14" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="1" width="20" height="11" uuid="a1f3c2d4-0001-4a5b-8c6d-1e2f3a4b5c01"/>
				<textElement textAlignment="Right"><font fontName="SansSerif" size="8" isBold="true"/></textElement>
				<text><![CDATA[Pos]]></text>
			</staticText>
			<staticText>
				<reportElement x="262" y="1" width="38" height="11" uuid="a1f3c2d4-0002-4a5b-8c6d-1e2f3a4b5c02"/>
				<textElement textAlignment="Right"><font fontName="SansSerif" size="8" isBold="true"/></textElement>
				<text><![CDATA[Menge]]></text>
			</staticText>
			<staticText>
				<reportElement x="24" y="1" width="80" height="11" uuid="a1f3c2d4-0003-4a5b-8c6d-1e2f3a4b5c03"/>
				<textElement textAlignment="Left"><font fontName="SansSerif" size="8" isBold="true"/></textElement>
				<text><![CDATA[Artikel-Nr.]]></text>
			</staticText>
			<staticText>
				<reportElement x="108" y="1" width="150" height="11" uuid="a1f3c2d4-0004-4a5b-8c6d-1e2f3a4b5c04"/>
				<textElement textAlignment="Left"><font fontName="SansSerif" size="8" isBold="true"/></textElement>
				<text><![CDATA[Bezeichnung]]></text>
			</staticText>
			<staticText>
				<reportElement x="304" y="1" width="66" height="11" uuid="a1f3c2d4-0005-4a5b-8c6d-1e2f3a4b5c05"/>
				<textElement textAlignment="Right"><font fontName="SansSerif" size="8" isBold="true"/></textElement>
				<text><![CDATA[Lagerort]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="13" width="370" height="1" uuid="a1f3c2d4-0006-4a5b-8c6d-1e2f3a4b5c06"/>
				<graphicElement><pen lineWidth="2.0"/></graphicElement>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="38" splitType="Prevent">
			<rectangle>
				<reportElement stretchType="ContainerHeight" mode="Opaque" x="0" y="0" width="370" height="38" backcolor="#EFEFEF" uuid="b2e4d3c5-0011-4b6c-9d7e-2f3a4b5c6d11">
					<printWhenExpression><![CDATA[$V{REPORT_COUNT} % 2 == 0]]></printWhenExpression>
				</reportElement>
				<graphicElement><pen lineWidth="0.0"/></graphicElement>
			</rectangle>
			<textField pattern="#0" isBlankWhenNull="true">
				<reportElement style="Report Monospace Font" x="0" y="1" width="20" height="11" uuid="b2e4d3c5-0001-4b6c-9d7e-2f3a4b5c6d01"/>
				<textElement textAlignment="Right"><font fontName="SansSerif" size="8"/></textElement>
				<textFieldExpression><![CDATA[$F{line}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement style="Report Monospace Font" x="262" y="0" width="38" height="15" uuid="b2e4d3c5-0002-4b6c-9d7e-2f3a4b5c6d02">
					<printWhenExpression><![CDATA[$F{m_product_id} != null]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Top" markup="styled"><font fontName="SansSerif" size="7"/></textElement>
				<textFieldExpression><![CDATA[$F{qty} == null ? "" : ("<style size=\"12\" isBold=\"true\">" + new java.text.DecimalFormat("#,##0.###", new java.text.DecimalFormatSymbols(new java.util.Locale("de","DE"))).format($F{qty}) + "</style>" + ($F{uomsymbol} == null ? "" : " " + $F{uomsymbol}.replace("&", "&amp;").replace("<", "&lt;")))]]></textFieldExpression>
			</textField>
			<textField textAdjust="CutText" isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="24" y="1" width="80" height="36" uuid="b2e4d3c5-0003-4b6c-9d7e-2f3a4b5c6d03"/>
				<textElement textAlignment="Left" markup="styled"><font fontName="SansSerif" size="8"/></textElement>
				<textFieldExpression><![CDATA[({ String v, String ean, String sku, String mpn ->
    def esc = { String t -> t == null ? null : t.replace("&", "&amp;").replace("<", "&lt;").replace(">", "&gt;") }
    def lines = []
    if (v != null) lines << esc(v)
    if (ean != null) lines << "<style size=\"7\" forecolor=\"#606060\">EAN " + esc(ean) + "</style>"
    if (sku != null) lines << "<style size=\"7\" forecolor=\"#606060\">SKU " + esc(sku) + "</style>"
    if (mpn != null) lines << "<style size=\"7\" forecolor=\"#606060\">MPN " + esc(mpn) + "</style>"
    lines.isEmpty() ? null : lines.join("\n")
})($F{productvalue}, $F{upc}, $F{sku}, $F{mpn})]]></textFieldExpression>
			</textField>
			<textField textAdjust="CutText" isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="108" y="1" width="150" height="36" uuid="b2e4d3c5-0004-4b6c-9d7e-2f3a4b5c6d04"/>
				<textElement textAlignment="Left" markup="styled"><font fontName="SansSerif" size="8"/></textElement>
				<textFieldExpression><![CDATA[({ String n, String note, String d ->
    def esc = { String t -> t == null ? null : t.replace("&", "&amp;").replace("<", "&lt;").replace(">", "&gt;") }
    def parts = []
    if (n != null) parts << esc(n)
    if (note != null) parts << "<style size=\"7\" isItalic=\"true\">" + esc(note) + "</style>"
    if (d != null && !d.equals(n)) parts << "<style size=\"7\" isItalic=\"true\">" + esc(d) + "</style>"
    parts.isEmpty() ? null : parts.join("\n")
})($F{name}, $F{documentnote}, $F{description})]]></textFieldExpression>
			</textField>
			<textField textAdjust="CutText" isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="304" y="1" width="66" height="36" uuid="b2e4d3c5-0005-4b6c-9d7e-2f3a4b5c6d05"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"><font fontName="SansSerif" size="8"/></textElement>
				<textFieldExpression><![CDATA[$F{m_locator_value}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="4" splitType="Stretch">
			<line>
				<reportElement x="0" y="1" width="370" height="1" uuid="c3f5e4d6-0001-4c7d-8e9f-3a4b5c6d7e01"/>
			</line>
		</band>
	</columnFooter>
</jasperReport>
