Skip to main content

Jasper INV >> Purchase Order - Aegis Web

Purchase Order (A4) -

<!-- Created with Jaspersoft Studio version 7.0.8.final using JasperReports Library version 7.0.8-6f896111  -->
<jasperReport name="INV_PO_A4" language="java" columnCount="1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4a393703-1051-4488-9873-72e1ff238c71">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
	<dataset name="taxDetailsDataset" uuid="4f65d35d-6ee8-4c26-9157-5e3422f2f595">
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
		<query language="sql"><![CDATA[]]></query>
		<field name="tax_code_name" class="java.lang.String"/>
		<field name="tax_amount" class="java.lang.String"/>
		<field name="factor" class="java.lang.String"/>
	</dataset>
	<parameter name="header_image" class="java.io.InputStream"/>
	<parameter name="purchase_order_number" class="java.lang.String"/>
	<parameter name="purchase_order_date" class="java.lang.String"/>
	<parameter name="local_currency" class="java.lang.String"/>
	<parameter name="vendor_name" class="java.lang.String"/>
	<parameter name="vendor_country" class="java.lang.String"/>
	<parameter name="vendor_state" class="java.lang.String"/>
	<parameter name="vendor_city" class="java.lang.String"/>
	<parameter name="vendor_street" class="java.lang.String"/>
	<parameter name="vendor_pan" class="java.lang.String"/>
	<parameter name="vendor_tel1" class="java.lang.String"/>
	<parameter name="vendor_tel2" class="java.lang.String"/>
	<parameter name="vendor_email" class="java.lang.String"/>
	<parameter name="shipping_to_name" class="java.lang.String"/>
	<parameter name="shipping_to_address" class="java.lang.String"/>
	<parameter name="shipping_to_contact" class="java.lang.String"/>
	<parameter name="shipping_to_email" class="java.lang.String"/>
	<parameter name="property_name" class="java.lang.String"/>
	<parameter name="property_address" class="java.lang.String"/>
	<parameter name="property_contact_number" class="java.lang.String"/>
	<parameter name="property_email" class="java.lang.String"/>
	<parameter name="sub_total" class="java.lang.String"/>
	<parameter name="discount" class="java.lang.String"/>
	<parameter name="tax" class="java.lang.String"/>
	<parameter name="list2" class="java.util.Collection"/>
	<parameter name="grand_total" class="java.lang.String"/>
	<parameter name="amount_in_words" class="java.lang.String"/>
	<parameter name="remarks" class="java.lang.String"/>
	<parameter name="payment_term" class="java.lang.String"/>
	<parameter name="prepared_by" class="java.lang.String"/>
	<parameter name="created_by_signature" class="java.io.InputStream"/>
	<parameter name="updated_by_signature" class="java.io.InputStream"/>
	<parameter name="printed_by_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level1_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level2_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level3_signature" class="java.io.InputStream"/>
	<parameter name="created_by" class="java.lang.String"/>
	<parameter name="updated_by" class="java.lang.String"/>
	<parameter name="printed_by" class="java.lang.String"/>
	<parameter name="approved_by_level_1" class="java.lang.String"/>
	<parameter name="approved_by_level_2" class="java.lang.String"/>
	<parameter name="approved_by_level_3" class="java.lang.String"/>
	<parameter name="order_type" class="java.lang.String"/>
	<parameter name="purchase_order_date_in_nepali" class="java.lang.String"/>
	<parameter name="exempted_amount" class="java.lang.String"/>
	<parameter name="taxable_amount" class="java.lang.String"/>
	<query language="sql"><![CDATA[]]></query>
	<field name="item_code" class="java.lang.String"/>
	<field name="particular" class="java.lang.String"/>
	<field name="brand_name" class="java.lang.String"/>
	<field name="uom_full_name" class="java.lang.String"/>
	<field name="uom_short_name" class="java.lang.String"/>
	<field name="quantity" class="java.lang.String"/>
	<field name="rate" class="java.lang.String"/>
	<field name="total" class="java.lang.String"/>
	<group name="ReportSummary" keepTogether="true" preventOrphanFooter="true">
		<expression><![CDATA[1]]></expression>
		<groupFooter>
			<band height="203">
				<element kind="frame" uuid="0e118899-ac1c-4823-8928-b0d50708ed9e" x="4" y="0" width="547" height="15">
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<element kind="textField" uuid="3e24ca70-0590-4993-b201-0ec6505e5b2e" x="356" y="0" width="92" height="16" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<box>
							<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						</box>
						<expression><![CDATA["<b>Subtotal: </B>"]]></expression>
					</element>
					<element kind="textField" uuid="22a2d7e5-238c-431f-94f8-e1a4d7840839" x="451" y="0" width="96" height="16" positionType="Float" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<box>
							<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						</box>
						<expression><![CDATA[($P{sub_total} != null ? $P{sub_total} : "")]]></expression>
					</element>
					<element kind="textField" uuid="8149a38f-c487-41d6-9c00-786c20937448" x="0" y="1" width="341" height="14" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.x" value="px"/>
						<expression><![CDATA["<b>Remarks : </B> "+($P{remarks} != null ? $P{remarks} : "")]]></expression>
					</element>
				</element>
				<element kind="textField" uuid="a2e11528-c52e-44cf-9d59-6f926a03b26c" x="455" y="48" width="96" height="16" positionType="Float" removeLineWhenBlank="true" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{tax} != null
&& $P{tax}!="" 
&& !$P{tax}.trim().isEmpty() 
&& !$P{tax}.trim().equals("0")
&& !$P{tax}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{tax} == null ? "" : $P{tax})]]></expression>
				</element>
				<element kind="textField" uuid="d66dd03d-c621-4673-a75b-8e72c79f7ac6" x="360" y="64" width="92" height="16" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA["<b>Total: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="4a74a290-34fd-4999-b447-e13c494842d5" x="455" y="64" width="96" height="16" positionType="Float" fontSize="9.0" textAdjust="StretchHeight" bold="true" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{grand_total} == null ? "" : $P{grand_total})]]></expression>
				</element>
				<element kind="textField" uuid="0474d672-f706-4020-a9aa-a78069a04f0f" x="4" y="80" width="547" height="16" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<box>
						<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA["<b>In Words :</b> "+($P{amount_in_words} != null ? $P{amount_in_words} : "")]]></expression>
				</element>
				<element kind="image" uuid="32435f38-50d2-4335-946c-f760c440d04c" x="32" y="127" width="45" height="45" positionType="Float" hImageAlign="Center" vImageAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{created_by_signature} != null]]></printWhenExpression>
					<expression><![CDATA[$P{created_by_signature}]]></expression>
				</element>
				<element kind="textField" uuid="49d95269-1a70-42f1-a0d0-08b23b2336c1" x="4" y="157" width="100" height="15" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{created_by_signature} == null && $P{created_by} != null && !$P{created_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{created_by}]]></expression>
				</element>
				<element kind="textField" uuid="68bb1e20-fec5-4568-8ddb-e04b88b97f1f" x="4" y="172" width="100" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Created By"]]></expression>
				</element>
				<element kind="image" uuid="f0731bb1-f1db-4fd8-8b11-fb1f6f909750" x="255" y="127" width="45" height="45" positionType="Float" hImageAlign="Center" vImageAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{updated_by_signature} != null]]></printWhenExpression>
					<expression><![CDATA[$P{updated_by_signature}]]></expression>
				</element>
				<element kind="textField" uuid="7c4a1dfe-2e8e-4430-8816-46dc4d798079" x="227" y="157" width="100" height="15" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{updated_by_signature} == null && $P{updated_by} != null && !$P{updated_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{updated_by}]]></expression>
				</element>
				<element kind="textField" uuid="68ff435f-9387-41c7-8d5f-20edc2b9a490" x="227" y="172" width="100" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Updated By"]]></expression>
				</element>
				<element kind="image" uuid="be23a8fd-941f-4f76-bce5-8879c2b58f59" x="479" y="127" width="45" height="45" positionType="Float" hImageAlign="Center" vImageAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{printed_by_signature} != null]]></printWhenExpression>
					<expression><![CDATA[$P{printed_by_signature}]]></expression>
				</element>
				<element kind="textField" uuid="5c3a61c8-6991-406c-a02b-0f33bea0e019" x="451" y="157" width="100" height="15" positionType="Float" printWhenGroupChanges="ReportSummary" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<printWhenExpression><![CDATA[$P{printed_by_signature} == null && $P{printed_by} != null && !$P{printed_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{printed_by}]]></expression>
				</element>
				<element kind="textField" uuid="4da5fb5e-e5a3-4906-be39-963e365342e8" x="451" y="172" width="100" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Printed By"]]></expression>
				</element>
				<element kind="textField" uuid="082e21d5-6c58-46de-bb7a-a2e67d848b91" x="455" y="16" width="96" height="16" positionType="Float" removeLineWhenBlank="true" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{discount} != null
&& $P{discount}!="" 
&& !$P{discount}.trim().isEmpty() 
&& !$P{discount}.trim().equals("0")
&& !$P{discount}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{exempted_amount}== null ? "" : $P{exempted_amount})]]></expression>
				</element>
				<element kind="textField" uuid="1cffcdf6-3033-4cfd-b478-e25b4b134d80" x="455" y="32" width="96" height="16" positionType="Float" removeLineWhenBlank="true" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{discount} != null
&& $P{discount}!="" 
&& !$P{discount}.trim().isEmpty() 
&& !$P{discount}.trim().equals("0")
&& !$P{discount}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{taxable_amount}== null ? "" : $P{taxable_amount})]]></expression>
				</element>
				<element kind="textField" uuid="e9785116-12c1-4561-96be-dc8fabb92422" x="360" y="16" width="92" height="16" markup="html" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
					<expression><![CDATA["<b>Exempted: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="90f179e9-3bcf-45fc-84ed-559793b8496c" x="360" y="32" width="92" height="16" markup="html" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
					<expression><![CDATA["<b>Taxable: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="e3abf5b3-c9ed-42b4-b2cd-2940ec7d482d" x="360" y="48" width="92" height="16" markup="html" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
					<expression><![CDATA["<b>Tax: </b>"]]></expression>
				</element>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
			</band>
		</groupFooter>
	</group>
	<background height="802" splitType="Stretch">
		<element kind="rectangle" uuid="b36d1de5-c64e-4362-bc83-0d9c784e742a" x="0" y="0" width="555" height="802" mode="Transparent">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<pen lineWidth="0.0"/>
		</element>
		<property name="com.jaspersoft.studio.unit.height" value="px"/>
	</background>
	<pageHeader height="240" splitType="Stretch">
		<element kind="image" uuid="f28b77cc-4732-49b8-9551-9ddd18050fad" x="4" y="3" width="547" height="106" removeLineWhenBlank="true" scaleImage="FillFrame" hImageAlign="Center" vImageAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<printWhenExpression><![CDATA[$P{header_image} != null]]></printWhenExpression>
			<expression><![CDATA[$P{header_image}]]></expression>
		</element>
		<element kind="textField" uuid="12a73144-2151-49d3-8347-e48f8044e076" x="232" y="115" width="95" height="15" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Bottom">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<bottomPen lineWidth="1.0"/>
			</box>
			<expression><![CDATA["PURCHASE ORDER"]]></expression>
		</element>
		<element kind="textField" uuid="44f5cccb-c3eb-4273-9528-c622fd2ea37c" x="381" y="135" width="171" height="16" positionType="Float" markup="html" fontSize="9.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>PO #: </b>" + ($P{purchase_order_number} != null ? $P{purchase_order_number} : "")]]></expression>
		</element>
		<element kind="textField" uuid="365a71d5-d8aa-4d0c-8726-e39d6878c631" x="381" y="151" width="171" height="16" positionType="Float" markup="html" fontSize="9.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA["<b>PO Date: </b>" + ($P{purchase_order_date} != null ? $P{purchase_order_date} : "")]]></expression>
		</element>
		<element kind="textField" uuid="470721b8-7879-4c86-8cc2-0984fbd3c424" x="381" y="167" width="171" height="16" positionType="Float" markup="html" fontSize="9.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>Ship To: </b>"]]></expression>
		</element>
		<element kind="textField" uuid="474bdc99-a96c-446e-a77f-f5fb56214376" x="382" y="183" width="170" height="16" positionType="Float" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_name} != null ? $P{shipping_to_name} : "")]]></expression>
		</element>
		<element kind="textField" uuid="c7fff2e1-ab8b-4cf1-b340-8fec0a81ad80" x="4" y="184" width="276" height="16" positionType="Float" fontSize="9.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA[$P{vendor_name} != null ? $P{vendor_name} : ""]]></expression>
		</element>
		<element kind="textField" uuid="d780d376-b1d3-4f72-b6f8-c07dd81f0222" x="4" y="216" width="276" height="16" positionType="Float" fontSize="9.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA[($P{vendor_country} != null ? $P{vendor_country} : "") + ($P{vendor_state} != null && !$P{vendor_state}.trim().isEmpty() ? (", " + $P{vendor_state}) : "") + ($P{vendor_city} != null && !$P{vendor_city}.trim().isEmpty() ? (", " + $P{vendor_city}) : "") + ($P{vendor_street} != null && !$P{vendor_street} .trim().isEmpty() ? (", " + $P{vendor_street}) : "")]]></expression>
		</element>
		<element kind="textField" uuid="40feb42c-676e-496a-be6a-7f215452511c" x="4" y="200" width="276" height="16" positionType="Float" markup="html" fontSize="9.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>PAN: </b>" + $P{vendor_pan} != null ? $P{vendor_pan} : ""]]></expression>
		</element>
		<element kind="textField" uuid="9459c062-aaca-40e5-b195-4d65916c06d8" x="382" y="199" width="170" height="16" positionType="Float" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_address} == null ? "" : $P{shipping_to_address})]]></expression>
		</element>
		<element kind="textField" uuid="91a1ba53-57e2-4808-ade5-a6d2a155a599" x="382" y="215" width="170" height="16" positionType="Float" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_contact} == null ? "" : $P{shipping_to_contact})]]></expression>
		</element>
		<element kind="textField" uuid="09d08211-8930-4fd0-a7ab-8d5d9cb74387" x="4" y="168" width="276" height="16" positionType="Float" markup="html" fontSize="8.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>To :</b>"]]></expression>
		</element>
		<property name="com.jaspersoft.studio.unit.height" value="px"/>
	</pageHeader>
	<columnHeader height="20" splitType="Stretch">
		<element kind="textField" uuid="64abe4c0-deb8-491e-a06f-4f9641d782ba" x="4" y="0" width="35" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["S.No."]]></expression>
		</element>
		<element kind="textField" uuid="399e3086-cabe-439e-858b-69b142da6802" x="41" y="0" width="71" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Item Code"]]></expression>
		</element>
		<element kind="textField" uuid="ded783ec-3040-48ca-830e-fa791b152687" x="114" y="0" width="230" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Item Description"]]></expression>
		</element>
		<element kind="textField" uuid="1e28cea9-ca5c-4a34-a926-e7763d50bac2" x="346" y="0" width="52" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["UOM"]]></expression>
		</element>
		<element kind="textField" uuid="dd67adf2-e712-45b6-9d80-f9873fcc18bf" x="400" y="0" width="47" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["QTY"]]></expression>
		</element>
		<element kind="textField" uuid="8d4fb511-2241-4bc6-9a7c-e98c6b388335" x="449" y="0" width="49" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Rate"]]></expression>
		</element>
		<element kind="textField" uuid="235176a1-1d00-44ff-9a4c-9111c4b7f329" x="500" y="0" width="50" height="20" positionType="Float" fontSize="10.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Value"]]></expression>
		</element>
	</columnHeader>
	<detail>
		<band height="17" splitType="Stretch">
			<element kind="textField" uuid="eba308e3-ed01-4082-8d27-3913aceb81f8" x="4" y="0" width="35" height="15" positionType="Float" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="false" hTextAlign="Center" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<expression><![CDATA[$V{REPORT_COUNT}]]></expression>
			</element>
			<element kind="textField" uuid="ec94ad58-1a8d-4b37-9de8-ee2818a0e0d3" x="41" y="0" width="71" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Center" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bfd6448e-0818-41c1-a4b4-3eb23c32c47c"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<expression><![CDATA[$F{item_code}]]></expression>
			</element>
			<element kind="textField" uuid="c1a1457d-5f01-4f8c-9ab8-3f9c78d64d96" x="114" y="0" width="230" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4597904a-513b-4f25-98fd-a3fd0abf6ff9"/>
				<expression><![CDATA[$F{particular} + ($F{brand_name} != null && !$F{brand_name}.trim().isEmpty() ? (" ["+$F{brand_name}+"]") : "" )]]></expression>
			</element>
			<element kind="textField" uuid="90d8f29a-a489-482f-b82e-1395639674fc" x="346" y="0" width="52" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1a2ba2de-43e6-4ed3-a39b-91fa8a00da24"/>
				<expression><![CDATA[$F{uom_short_name}]]></expression>
			</element>
			<element kind="textField" uuid="6711141a-0d28-4589-829a-f4c037b0f4de" x="400" y="0" width="47" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="76331216-3006-4017-9fea-42dd9860d05c"/>
				<expression><![CDATA[$F{quantity}]]></expression>
			</element>
			<element kind="textField" uuid="5153deed-9e4c-4831-b74b-431c6c00c760" x="449" y="0" width="49" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e95e34dc-6ca5-485b-86c1-fc0aa33ea4dd"/>
				<expression><![CDATA[$F{rate}]]></expression>
			</element>
			<element kind="textField" uuid="7ad08423-dc00-4387-81c7-c5f66f09b8ec" x="500" y="0" width="50" height="15" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a4a9f26-f701-4299-82e0-9de365ab21bf"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<expression><![CDATA[$F{total}]]></expression>
			</element>
		</band>
	</detail>
</jasperReport>

Purchase Order (A5) -

<!-- Created with Jaspersoft Studio version 7.0.8.final using JasperReports Library version 7.0.8-6f896111  -->
<jasperReport name="INV_PO_A4" language="java" columnCount="1" pageWidth="420" pageHeight="595" columnWidth="400" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="4a393703-1051-4488-9873-72e1ff238c71">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
	<dataset name="taxDetailsDataset" uuid="4f65d35d-6ee8-4c26-9157-5e3422f2f595">
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
		<query language="sql"><![CDATA[]]></query>
		<field name="tax_code_name" class="java.lang.String"/>
		<field name="tax_amount" class="java.lang.String"/>
		<field name="factor" class="java.lang.String"/>
	</dataset>
	<parameter name="header_image" class="java.io.InputStream"/>
	<parameter name="purchase_order_number" class="java.lang.String"/>
	<parameter name="purchase_order_date" class="java.lang.String"/>
	<parameter name="purchase_order_date_in_nepali" class="java.lang.String"/>
	<parameter name="vendor_name" class="java.lang.String"/>
	<parameter name="vendor_country" class="java.lang.String"/>
	<parameter name="vendor_state" class="java.lang.String"/>
	<parameter name="vendor_city" class="java.lang.String"/>
	<parameter name="vendor_street" class="java.lang.String"/>
	<parameter name="vendor_pan" class="java.lang.String"/>
	<parameter name="vendor_tel1" class="java.lang.String"/>
	<parameter name="vendor_tel2" class="java.lang.String"/>
	<parameter name="vendor_email" class="java.lang.String"/>
	<parameter name="shipping_to_name" class="java.lang.String"/>
	<parameter name="shipping_to_address" class="java.lang.String"/>
	<parameter name="shipping_to_contact" class="java.lang.String"/>
	<parameter name="shipping_to_email" class="java.lang.String"/>
	<parameter name="property_name" class="java.lang.String"/>
	<parameter name="property_address" class="java.lang.String"/>
	<parameter name="property_contact_number" class="java.lang.String"/>
	<parameter name="property_email" class="java.lang.String"/>
	<parameter name="sub_total" class="java.lang.String"/>
	<parameter name="discount" class="java.lang.String"/>
	<parameter name="exempted_amount" class="java.lang.String"/>
	<parameter name="taxable_amount" class="java.lang.String"/>
	<parameter name="tax" class="java.lang.String"/>
	<parameter name="list2" class="java.util.Collection"/>
	<parameter name="local_currency" class="java.lang.String"/>
	<parameter name="grand_total" class="java.lang.String"/>
	<parameter name="amount_in_words" class="java.lang.String"/>
	<parameter name="remarks" class="java.lang.String"/>
	<parameter name="payment_term" class="java.lang.String"/>
	<parameter name="prepared_by" class="java.lang.String"/>
	<parameter name="created_by_signature" class="java.io.InputStream"/>
	<parameter name="updated_by_signature" class="java.io.InputStream"/>
	<parameter name="printed_by_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level1_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level2_signature" class="java.io.InputStream"/>
	<parameter name="approved_by_level3_signature" class="java.io.InputStream"/>
	<parameter name="created_by" class="java.lang.String"/>
	<parameter name="updated_by" class="java.lang.String"/>
	<parameter name="printed_by" class="java.lang.String"/>
	<parameter name="approved_by_level_1" class="java.lang.String"/>
	<parameter name="approved_by_level_2" class="java.lang.String"/>
	<parameter name="approved_by_level_3" class="java.lang.String"/>
	<parameter name="order_type" class="java.lang.String"/>
	<query language="sql"><![CDATA[]]></query>
	<field name="item_code" class="java.lang.String"/>
	<field name="particular" class="java.lang.String"/>
	<field name="brand_name" class="java.lang.String"/>
	<field name="uom_full_name" class="java.lang.String"/>
	<field name="uom_short_name" class="java.lang.String"/>
	<field name="quantity" class="java.lang.String"/>
	<field name="rate" class="java.lang.String"/>
	<field name="total" class="java.lang.String"/>
	<group name="ReportSummary" keepTogether="true" preventOrphanFooter="true">
		<expression><![CDATA[1]]></expression>
		<groupFooter>
			<band height="138">
				<element kind="textField" uuid="84fbe922-d407-4a7f-ba41-22086ee72a51" x="5" y="100" width="75" height="15" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{created_by_signature} == null && $P{created_by} != null && !$P{created_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{created_by}]]></expression>
				</element>
				<element kind="textField" uuid="ed2f121d-5252-4244-af86-d602ebdcaf65" x="5" y="115" width="75" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Created By"]]></expression>
				</element>
				<element kind="textField" uuid="1dcf5cc9-d0e4-44cd-930a-8a2e2d4c3a98" x="163" y="100" width="75" height="15" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{updated_by_signature} == null && $P{updated_by} != null && !$P{updated_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{updated_by}]]></expression>
				</element>
				<element kind="textField" uuid="754809a0-f532-4c5d-96ec-922c1d80106f" x="163" y="115" width="75" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Updated By"]]></expression>
				</element>
				<element kind="textField" uuid="56b270f7-5f2d-4833-98be-206dcc09d22c" x="322" y="100" width="75" height="15" positionType="Float" printWhenGroupChanges="ReportSummary" removeLineWhenBlank="true" fontSize="8.0" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{printed_by_signature} == null && $P{printed_by} != null && !$P{printed_by}.trim().isEmpty()]]></printWhenExpression>
					<expression><![CDATA[$P{printed_by}]]></expression>
				</element>
				<element kind="textField" uuid="560be453-2657-481a-af7d-629a2cdb7b23" x="322" y="115" width="75" height="15" positionType="Float" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<expression><![CDATA["Printed By"]]></expression>
				</element>
				<element kind="frame" uuid="df01d36c-b746-4027-82fd-acc339c58e9f" x="4" y="0" width="384" height="15">
					<box>
						<topPen lineWidth="1.0"/>
					</box>
					<element kind="textField" uuid="49e1a71d-710a-4a97-98fb-0eb152cd08f3" x="247" y="1" width="86" height="12" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<box>
							<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						</box>
						<expression><![CDATA["<b>Subtotal: </B>"]]></expression>
					</element>
					<element kind="textField" uuid="27dbdd2b-7d29-4953-9a17-045cb2438ad4" x="336" y="1" width="48" height="12" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<box>
							<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
							<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						</box>
						<expression><![CDATA[($P{sub_total} != null ? $P{sub_total} : "")]]></expression>
					</element>
					<element kind="textField" uuid="40305001-1a5a-4162-9337-26471ad30a10" x="0" y="1" width="232" height="12" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Middle">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.x" value="px"/>
						<expression><![CDATA["<b>Remarks : </B> "+($P{remarks} != null ? $P{remarks} : "")]]></expression>
					</element>
				</element>
				<element kind="textField" uuid="e036f845-18a4-4e5d-b7d8-f9e168557931" x="340" y="38" width="48" height="12" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{tax} != null
&& $P{tax}!="" 
&& !$P{tax}.trim().isEmpty() 
&& !$P{tax}.trim().equals("0")
&& !$P{tax}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{tax} == null ? "" : $P{tax})]]></expression>
				</element>
				<element kind="textField" uuid="ac7370c0-1f5f-40ba-94bf-f15a47363ad1" x="251" y="50" width="86" height="12" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" bold="false" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA["<b>Total: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="fa1aa352-116e-49a9-b38f-5b5ae78c8f74" x="340" y="50" width="48" height="12" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{grand_total} == null ? "" : $P{grand_total})]]></expression>
				</element>
				<element kind="textField" uuid="695adb3a-4316-4c0f-a217-e4307f3fd580" x="4" y="62" width="384" height="12" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<box>
						<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA["<b>In Words :</b> "+($P{amount_in_words} != null ? $P{amount_in_words} : "")]]></expression>
				</element>
				<element kind="textField" uuid="5f958909-ba42-425e-a341-451024898c65" x="340" y="14" width="48" height="12" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{discount} != null
&& $P{discount}!="" 
&& !$P{discount}.trim().isEmpty() 
&& !$P{discount}.trim().equals("0")
&& !$P{discount}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{exempted_amount}== null ? "" : $P{exempted_amount})]]></expression>
				</element>
				<element kind="textField" uuid="2435bb32-0dbe-426b-b4af-1442043a913a" x="340" y="26" width="48" height="12" positionType="Float" removeLineWhenBlank="true" fontSize="8.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<printWhenExpression><![CDATA[$P{discount} != null
&& $P{discount}!="" 
&& !$P{discount}.trim().isEmpty() 
&& !$P{discount}.trim().equals("0")
&& !$P{discount}.trim().equals("0.00")]]></printWhenExpression>
					<box>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<expression><![CDATA[($P{taxable_amount}== null ? "" : $P{taxable_amount})]]></expression>
				</element>
				<element kind="textField" uuid="4929a037-9a7d-441d-bdb0-70bd91937bed" x="251" y="14" width="86" height="12" markup="html" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<expression><![CDATA["<b>Exempted: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="628cbe3c-0927-4be3-9504-3fe3f7f96491" x="251" y="26" width="86" height="12" markup="html" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<expression><![CDATA["<b>Taxable: </b>"]]></expression>
				</element>
				<element kind="textField" uuid="5f2d2d84-4fc0-4438-a395-cdb98270b300" x="251" y="38" width="86" height="12" markup="html" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<expression><![CDATA["<b>Tax: </b>"]]></expression>
				</element>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
			</band>
		</groupFooter>
	</group>
	<background height="423">
		<element kind="rectangle" uuid="05d21875-fdc3-47b7-92b0-8c2cc9a1db20" x="0" y="0" width="400" height="422" mode="Transparent">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<pen lineWidth="0.0"/>
		</element>
	</background>
	<pageHeader height="181" splitType="Stretch">
		<element kind="image" uuid="f28b77cc-4732-49b8-9551-9ddd18050fad" x="2" y="3" width="396" height="79" removeLineWhenBlank="true" scaleImage="FillFrame" hImageAlign="Center" vImageAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<printWhenExpression><![CDATA[$P{header_image} != null]]></printWhenExpression>
			<expression><![CDATA[$P{header_image}]]></expression>
		</element>
		<element kind="textField" uuid="12a73144-2151-49d3-8347-e48f8044e076" x="150" y="84" width="86" height="15" fontSize="8.0" bold="true" hTextAlign="Center" vTextAlign="Bottom">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<bottomPen lineWidth="1.0"/>
			</box>
			<expression><![CDATA["PURCHASE ORDER"]]></expression>
		</element>
		<element kind="textField" uuid="17a433ff-0956-48eb-9a14-8ad3965b86b7" x="214" y="106" width="174" height="12" positionType="Float" markup="html" fontSize="8.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>PO #: </b>" + ($P{purchase_order_number} != null ? $P{purchase_order_number} : "")]]></expression>
		</element>
		<element kind="textField" uuid="95fac71e-bc55-4d70-8a8d-f1796f57c2cc" x="214" y="118" width="174" height="12" positionType="Float" markup="html" fontSize="8.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA["<b>PO Date: </b>" + ($P{purchase_order_date} != null ? $P{purchase_order_date} : "")]]></expression>
		</element>
		<element kind="textField" uuid="7c726c43-5f4d-4797-9e97-b918e84eca49" x="214" y="130" width="174" height="12" positionType="Float" markup="html" fontSize="8.0" bold="false" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>Ship To: </b>"]]></expression>
		</element>
		<element kind="textField" uuid="b973b39f-e3b3-4a2d-a9b7-0f53b6e48a7b" x="214" y="142" width="174" height="12" positionType="Float" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_name} != null ? $P{shipping_to_name} : "")]]></expression>
		</element>
		<element kind="textField" uuid="b2f2643b-8eb2-475f-997b-5c8539601f18" x="4" y="142" width="186" height="12" positionType="Float" fontSize="8.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA[$P{vendor_name} != null ? $P{vendor_name} : ""]]></expression>
		</element>
		<element kind="textField" uuid="406113c8-15f3-45f0-889a-92237ec0965e" x="4" y="166" width="186" height="12" positionType="Float" fontSize="8.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA[($P{vendor_country} != null ? $P{vendor_country} : "") + ($P{vendor_state} != null && !$P{vendor_state}.trim().isEmpty() ? (", " + $P{vendor_state}) : "") + ($P{vendor_city} != null && !$P{vendor_city}.trim().isEmpty() ? (", " + $P{vendor_city}) : "") + ($P{vendor_street} != null && !$P{vendor_street} .trim().isEmpty() ? (", " + $P{vendor_street}) : "")]]></expression>
		</element>
		<element kind="textField" uuid="19259903-1b83-4094-a32f-071981dc288b" x="4" y="154" width="186" height="12" positionType="Float" markup="html" fontSize="8.0" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>PAN: </b>" + $P{vendor_pan} != null ? $P{vendor_pan} : ""]]></expression>
		</element>
		<element kind="textField" uuid="283e1e9b-122d-484f-9e55-1b130346e1ee" x="214" y="154" width="174" height="12" positionType="Float" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_address} == null ? "" : $P{shipping_to_address})]]></expression>
		</element>
		<element kind="textField" uuid="9ca09f38-9552-4b14-9b54-4ad421760850" x="214" y="166" width="174" height="12" positionType="Float" fontSize="8.0" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<expression><![CDATA[($P{shipping_to_contact} == null ? "" : $P{shipping_to_contact})]]></expression>
		</element>
		<element kind="textField" uuid="24242966-36bd-4d8a-8ee4-a68692cb24a6" x="4" y="130" width="186" height="12" positionType="Float" markup="html" fontSize="8.0" bold="false" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.x" value="px"/>
			<expression><![CDATA["<b>To :</b>"]]></expression>
		</element>
		<property name="com.jaspersoft.studio.unit.height" value="px"/>
	</pageHeader>
	<columnHeader height="17" splitType="Stretch">
		<element kind="textField" uuid="226939ef-8c09-45b7-bce6-cdf7a9f02b47" x="4" y="0" width="24" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["S.N."]]></expression>
		</element>
		<element kind="textField" uuid="d504fc68-6491-4cf0-bc46-475b0b3c8bc9" x="30" y="0" width="38" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Item Code"]]></expression>
		</element>
		<element kind="textField" uuid="a370a6d0-fb25-45cf-8c2f-81276626954c" x="70" y="0" width="150" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Item Description"]]></expression>
		</element>
		<element kind="textField" uuid="a662fd37-c6bf-46e1-b5db-aa46bda771ec" x="222" y="0" width="46" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Left" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["UOM"]]></expression>
		</element>
		<element kind="textField" uuid="e028b83c-25cd-4294-a172-3c2dab217f57" x="270" y="0" width="36" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["QTY"]]></expression>
		</element>
		<element kind="textField" uuid="1d6f2e1d-f95f-417f-a845-2e1a85637a46" x="308" y="0" width="39" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Rate"]]></expression>
		</element>
		<element kind="textField" uuid="64b6aa47-3225-434c-8bb8-b9ef3653b15a" x="349" y="0" width="39" height="15" positionType="Float" fontSize="8.0" bold="true" hTextAlign="Right" vTextAlign="Middle">
			<property name="com.jaspersoft.studio.unit.width" value="px"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<box>
				<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
			<expression><![CDATA["Value"]]></expression>
		</element>
	</columnHeader>
	<detail>
		<band height="14" splitType="Stretch">
			<element kind="textField" uuid="e5daf3c7-fd42-49d0-be51-5b8d716c781d" x="4" y="0" width="24" height="13" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="false" hTextAlign="Center" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<expression><![CDATA[$V{REPORT_COUNT}]]></expression>
			</element>
			<element kind="textField" uuid="9561147f-989b-4766-a7ef-9381400cc4e5" x="30" y="0" width="38" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Center" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bfd6448e-0818-41c1-a4b4-3eb23c32c47c"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{item_code}]]></expression>
			</element>
			<element kind="textField" uuid="352f7d13-d2d8-45cc-9e08-582097b772dc" x="70" y="0" width="150" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4597904a-513b-4f25-98fd-a3fd0abf6ff9"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{particular} + ($F{brand_name} != null && !$F{brand_name}.trim().isEmpty() ? (" ["+$F{brand_name}+"]") : "" )]]></expression>
			</element>
			<element kind="textField" uuid="da06215b-bb7d-40de-b23c-35e63f2ed5dc" x="222" y="0" width="46" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1a2ba2de-43e6-4ed3-a39b-91fa8a00da24"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{uom_short_name}]]></expression>
			</element>
			<element kind="textField" uuid="cbcd579c-adbc-4d14-8489-0bcba9b651ba" x="270" y="0" width="36" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="76331216-3006-4017-9fea-42dd9860d05c"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{quantity}]]></expression>
			</element>
			<element kind="textField" uuid="f2547f47-9404-43ec-a2d5-eab9d599fa7a" x="308" y="0" width="39" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e95e34dc-6ca5-485b-86c1-fc0aa33ea4dd"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{rate}]]></expression>
			</element>
			<element kind="textField" uuid="a1030d6d-b5a3-402b-9843-a885af1afb75" x="349" y="0" width="39" height="13" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a4a9f26-f701-4299-82e0-9de365ab21bf"/>
				<property name="com.jaspersoft.studio.unit.width" value="px"/>
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<expression><![CDATA[$F{total}]]></expression>
			</element>
		</band>
	</detail>
</jasperReport>
No Comments
Back to top