<?xml version="1.0" encoding="UTF-8"?>
<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="inventorylistdetail" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" resourceBundle="inventory_messages" uuid="ff5bda04-279a-4cd2-9b9b-caaab90f5b0a">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<queryString>
		<![CDATA[SELECT 
                'All' AS ALLLOCATION,  
                locations.id AS LOCATIONID,  
                locations.NAME AS LOCATIONNAME,  
                categories.id AS CATEGORYID,   
                categories.NAME AS CATEGORYNAME,  
                products.NAME AS PRODUCT_NAME, 
                products.pricebuy AS PRECIO_COMPRA, 
                stockcurrent.UNITS,  
                taxes.rate AS IMPUESTO, 
                round(products.pricesell*(1+taxes.rate)) AS PRECIO_VENTA, 
                stockcurrent.UNITS*round(products.pricesell*(1+taxes.rate)) AS VALOR_EN_INVENTARIO,
                round(products.pricesell*(1+taxes.rate))- round(products.pricebuy) as PROFIT,
                round((round(products.pricesell*(1+taxes.rate))/ round(products.pricebuy)-1)*100,2) as MARGEN, 
                stockcurrent.UNITS*products.pricebuy AS TOTAL_PRECIO_COMPRA, 
                stockcurrent.UNITS*round(products.pricesell*(1+taxes.rate)) AS TOTAL_VALOR_EN_INVENTARIO, 
                stockcurrent.UNITS*(round(products.pricesell*(1+taxes.rate))- round(products.pricebuy)) as TOTAL_PROFIT
            FROM stockcurrent   
                JOIN locations ON stockcurrent.LOCATION = locations.ID  
                JOIN products ON stockcurrent.PRODUCT = products.ID  
                JOIN categories ON products.CATEGORY = categories.ID   
                    LEFT OUTER JOIN stocklevel ON stockcurrent.LOCATION = stocklevel.LOCATION AND stockcurrent.PRODUCT = stocklevel.PRODUCT  
            	    LEFT OUTER JOIN attributesetinstance ON stockcurrent.ATTRIBUTESETINSTANCE_ID = attributesetinstance.ID  
		inner join taxes on taxes.id = products.taxcat  
            WHERE stockcurrent.UNITS > 0 
            ORDER BY LOCATIONNAME, CATEGORYNAME, PRODUCT_NAME]]>
	</queryString>
	<field name="ALLLOCATION" class="java.lang.String"/>
	<field name="LOCATIONID" class="java.lang.String"/>
	<field name="LOCATIONNAME" class="java.lang.String"/>
	<field name="CATEGORYID" class="java.lang.String"/>
	<field name="CATEGORYNAME" class="java.lang.String"/>
	<field name="PRODUCT_NAME" class="java.lang.String"/>
	<field name="PRECIO_COMPRA" class="java.lang.Double"/>
	<field name="UNITS" class="java.lang.Double"/>
	<field name="IMPUESTO" class="java.lang.Double"/>
	<field name="PRECIO_VENTA" class="java.lang.Double"/>
	<field name="PROFIT" class="java.lang.Double"/>
	<field name="MARGEN" class="java.lang.Double"/>
	<field name="TOTAL_PRECIO_COMPRA" class="java.lang.Double"/>
	<field name="TOTAL_VALOR_EN_INVENTARIO" class="java.lang.Double"/>
	<field name="TOTAL_PROFIT" class="java.lang.Double"/>
	<variable name="SUMPRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMPRECIO_VENTA" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_VENTA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMPROFIT" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMTOTAL_PRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMTOTAL_VALOR_EN_INVENTARIO" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_VALOR_EN_INVENTARIO}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMTOTAL_PROFIT" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="AVGMARGEN" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Average">
		<variableExpression><![CDATA[$F{MARGEN}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLPRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLPRECIO_VENTA" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_VENTA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLPROFIT" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLTOTAL_PRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLTOTAL_VALOR_EN_INVENTARIO" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_VALOR_EN_INVENTARIO}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLTOTAL_PROFIT" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="AVGALLMARGEN" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Average">
		<variableExpression><![CDATA[$F{MARGEN}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCPRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCPRECIO_VENTA" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{PRECIO_VENTA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCPROFIT" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCTOTAL_PRECIO_COMPRA" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PRECIO_COMPRA}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCTOTAL_VALOR_EN_INVENTARIO" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_VALOR_EN_INVENTARIO}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCTOTAL_PROFIT" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_PROFIT}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="AVGLOCMARGEN" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Average">
		<variableExpression><![CDATA[$F{MARGEN}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="UNITSTOTALWAREHOUSE" class="java.lang.Double" resetType="None" calculation="Sum">
		<variableExpression><![CDATA[$F{UNITS}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMUNITS" class="java.lang.Double" resetType="Group" resetGroup="byCategory" calculation="Sum">
		<variableExpression><![CDATA[$F{UNITS}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMALLUNITS" class="java.lang.Double" resetType="Group" resetGroup="byAllLotations" calculation="Sum">
		<variableExpression><![CDATA[$F{UNITS}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<variable name="SUMLOCUNITS" class="java.lang.Double" resetType="Group" resetGroup="byLocation" calculation="Sum">
		<variableExpression><![CDATA[$F{UNITS}]]></variableExpression>
		<initialValueExpression><![CDATA[new Double(0.0)]]></initialValueExpression>
	</variable>
	<group name="byAllLotations">
		<groupExpression><![CDATA[$F{ALLLOCATION}]]></groupExpression>
		<groupFooter>
			<band height="50">
				<line>
					<reportElement key="line-3" mode="Opaque" x="4" y="7" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="3d39a4e9-6bbc-47f9-951c-55a9d8d0e15f"/>
					<graphicElement fill="Solid">
						<pen lineWidth="5.0" lineStyle="Double"/>
					</graphicElement>
				</line>
				<textField>
					<reportElement x="0" y="13" width="145" height="13" uuid="5fffa24c-4a7c-476c-b2a0-0044059004a2"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA["Total sucursales"]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="223" y="13" width="82" height="14" uuid="f66e9663-fdab-4f97-8edd-e6cb088f17d5"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLPRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="305" y="13" width="70" height="14" uuid="97d8af57-d1c6-49e5-b900-3dd314f32e32"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLPRECIO_VENTA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="530" y="13" width="74" height="14" uuid="82112962-a396-4129-ac5c-4802274982a5"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLTOTAL_PRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="454" y="13" width="74" height="14" uuid="7df4fc29-7519-4f05-baea-3c9b7d7ee7a7"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{AVGALLMARGEN})+" %"]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="376" y="13" width="70" height="14" uuid="302c648a-4add-4050-a985-88598b1cc0cf"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLPROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="605" y="13" width="74" height="14" uuid="839c2315-ccc8-48e4-b137-ff623e55a981"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLTOTAL_VALOR_EN_INVENTARIO})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="679" y="12" width="70" height="14" uuid="52f94e8c-eb8e-41fd-9975-188e15233565"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLTOTAL_PROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="170" y="13" width="53" height="14" uuid="e86fa329-a6da-42f5-86a7-510520fa2e77"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMALLUNITS})]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="byLocation" isStartNewPage="true">
		<groupExpression><![CDATA[$F{LOCATIONID}]]></groupExpression>
		<groupHeader>
			<band height="21" splitType="Stretch">
				<textField>
					<reportElement x="1" y="0" width="145" height="20" uuid="6bfc70d2-1c78-4e79-ae84-54915d413535"/>
					<textElement>
						<font size="14" isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{LOCATIONNAME}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-3" mode="Opaque" x="0" y="17" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="0aaebb22-829d-4e0f-954b-fec708d0448c"/>
					<graphicElement fill="Solid">
						<pen lineWidth="2.0" lineStyle="Double"/>
					</graphicElement>
				</line>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="29">
				<line>
					<reportElement key="line-3" mode="Opaque" x="1" y="3" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="a54d92b6-6fc2-4e7b-ab2f-738bb3c44136"/>
					<graphicElement fill="Solid">
						<pen lineWidth="2.0" lineStyle="Double"/>
					</graphicElement>
				</line>
				<textField>
					<reportElement x="10" y="9" width="145" height="13" uuid="2e1f5a15-37d1-4a4a-b353-782f3d5c6a90"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA["Total " + $F{LOCATIONNAME}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="223" y="9" width="82" height="14" uuid="5c49ff19-9da8-413d-9d78-1a25314f2033"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCPRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="305" y="9" width="70" height="14" uuid="6b1ac579-f048-431d-beb0-824b7a31bf6b"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCPRECIO_VENTA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="530" y="9" width="74" height="14" uuid="144b3121-80e5-4b66-bc3c-870dfca2bea6"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCTOTAL_PRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="454" y="9" width="74" height="14" uuid="b85a033b-f7a7-41ee-a0d4-95071695f4fd"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{AVGLOCMARGEN})+" %"]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="376" y="9" width="70" height="14" uuid="9201bc6d-a2e1-4f6c-ac06-92e0943e7075"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCPROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="604" y="9" width="74" height="14" uuid="6706e571-c05e-4668-887d-73be7fefe1ec"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCTOTAL_VALOR_EN_INVENTARIO})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="678" y="9" width="70" height="14" uuid="2c2e495f-d9a1-4f55-9dec-fbcaa4efd4bb"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCTOTAL_PROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="170" y="9" width="53" height="14" uuid="3fc3f91f-914b-42e1-9cc5-1df9b3a696a5"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMLOCUNITS})]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="byCategory">
		<groupExpression><![CDATA[$F{CATEGORYID}]]></groupExpression>
		<groupHeader>
			<band height="18">
				<textField>
					<reportElement x="18" y="0" width="129" height="16" uuid="f6710361-ff60-4278-ae31-840bfe64276b"/>
					<textElement>
						<font size="12" isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CATEGORYNAME}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-3" mode="Opaque" x="0" y="17" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="2ad2ce86-aa5b-407a-b9d0-3d8cc5c133d0"/>
					<graphicElement fill="Solid">
						<pen lineWidth="0.25" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="21">
				<textField>
					<reportElement x="223" y="0" width="82" height="14" uuid="ecfb5859-f012-4db6-8f0f-3ef61d11a99b"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMPRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="305" y="0" width="70" height="14" uuid="a015237a-d591-4aea-a8f6-b7d539ba2e63"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMPRECIO_VENTA})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="530" y="0" width="74" height="14" uuid="3727c0ed-7ff6-4087-9b6a-fb25288baab2"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMTOTAL_PRECIO_COMPRA})]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-3" mode="Opaque" x="1" y="0" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="863c57e0-72bb-44c3-a4aa-af0f76f10c6a"/>
					<graphicElement fill="Solid">
						<pen lineWidth="0.25" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<textField>
					<reportElement x="454" y="0" width="74" height="14" uuid="613be649-6ddb-4fc1-baaa-76cba9cc2c12"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{AVGMARGEN})+" %"]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="376" y="0" width="70" height="14" uuid="6232a7e0-c77e-4d41-8068-07f543cb6225"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMPROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="604" y="0" width="74" height="14" uuid="a91e3b92-f955-4718-bcff-aceb9d5325f5"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMTOTAL_VALOR_EN_INVENTARIO})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="678" y="0" width="70" height="14" uuid="3850d542-a671-4371-8c83-c8a33e2dd68f"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMTOTAL_PROFIT})]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="170" y="0" width="53" height="14" uuid="a7ec35f6-f585-4d1d-81f1-2585fbc03139"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($V{SUMUNITS})]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band/>
	</background>
	<title>
		<band height="52">
			<rectangle radius="5">
				<reportElement key="rectangle-1" mode="Opaque" x="0" y="50" width="781" height="2" forecolor="#33CCFF" backcolor="#33CCFF" uuid="89d02ae2-c5a6-455f-843f-f20b531f0be7"/>
				<graphicElement fill="Solid">
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</rectangle>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-13" mode="Transparent" x="0" y="0" width="375" height="30" forecolor="#33CCFF" backcolor="#FFFFFF" uuid="83297b75-6a33-4643-82ec-123284c1e7a6"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="14" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.title.inventory_stock_value}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-10" mode="Opaque" x="646" y="0" width="135" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="2ad49871-ae6f-4fbb-9b3d-40867e979a79"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.printed}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false">
				<reportElement key="textField" x="646" y="15" width="135" height="15" uuid="c80a320f-6f9e-4743-a527-65289f62b6a9"/>
				<textElement textAlignment="Right">
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band>
			<textField>
				<reportElement x="19" y="-17" width="151" height="13" uuid="7a0f4680-4afc-4d10-b911-e259475b0bdc"/>
				<textFieldExpression><![CDATA[$R{label.name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="170" y="-17" width="56" height="13" uuid="9781bb89-47b1-4049-a716-39d78d90ffb9"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.units}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="226" y="-17" width="82" height="13" uuid="5a31797b-fcb3-4288-b75a-c7bdfd36535c"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.valuebuy}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="308" y="-17" width="70" height="13" uuid="d8ab7091-fe2c-45e4-8e28-91b21d4666ee"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.valuesell}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="531" y="-16" width="74" height="13" uuid="9fb7bb51-cf4f-4d1d-b3df-3e6c4ac5c855"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.total_buy}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="379" y="-17" width="74" height="13" uuid="afbb3f28-b3d5-4490-8426-bbd87072790b"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.profit}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="453" y="-16" width="74" height="13" uuid="93e32f01-9f40-4c8c-a85b-93ac85731e09"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.margen}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="605" y="-16" width="74" height="13" uuid="9a6569c1-e6ae-4772-b1b9-41477fb6de9b"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.total_sell}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="679" y="-16" width="74" height="13" uuid="4a9793e6-e34e-431c-a4c3-c18ae3b2bcdd"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$R{label.profit}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="13">
			<textField>
				<reportElement x="20" y="0" width="152" height="13" uuid="0e6633d5-f80a-42a8-bb9c-58c06224aa59"/>
				<textFieldExpression><![CDATA[$F{PRODUCT_NAME}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="223" y="0" width="82" height="13" uuid="dc274249-dd89-4fed-8c91-29c9424ea90d"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{PRECIO_COMPRA})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="530" y="0" width="74" height="13" uuid="79118f12-ca9c-4f3b-afc0-79f30114308d"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{TOTAL_PRECIO_COMPRA})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="305" y="0" width="70" height="13" uuid="05ae44b9-e9cd-4a9d-b67b-6d6299fa0796"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{PRECIO_VENTA})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="170" y="0" width="53" height="13" uuid="7fc596f7-db57-424f-b4cd-cdb7da16d81c"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{UNITS})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="454" y="0" width="74" height="13" uuid="61eb9df3-c1db-4419-9fc7-5c9e7bb401f1"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{MARGEN})+" %"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="376" y="0" width="70" height="13" uuid="cf70696b-c41a-4c58-a635-05a658486dd4"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{PROFIT})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="604" y="0" width="74" height="13" uuid="f9ba8e9f-acfa-46f6-8c1c-d38d73e464a0"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{TOTAL_VALOR_EN_INVENTARIO})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="678" y="0" width="70" height="13" uuid="8cc4c94d-0e13-4857-96fb-50535fa3e8f0"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[com.openbravo.format.Formats.DOUBLE.formatValue($F{TOTAL_PROFIT})]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="30">
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-6" mode="Opaque" x="731" y="10" width="20" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="d1fd9267-cd36-4c16-baf9-724ba12a96f2"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField-7" mode="Opaque" x="761" y="10" width="20" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="ee20cfe1-e8d0-46ed-9e30-cfc824ad53c0"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-5" mode="Opaque" x="751" y="10" width="10" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="f56cacf9-1f66-47ab-9763-d559db154072"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
			<line>
				<reportElement key="line-3" mode="Opaque" x="0" y="5" width="781" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="ffbeb46f-54eb-4475-a11a-686389863fc3"/>
				<graphicElement fill="Solid">
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="0" y="10" width="100" height="15" uuid="72ebf243-2066-4da2-9820-2fb6e37d9b9f"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<text><![CDATA[rpt:inventory_stock_value]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
