<?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="d_er1_part1" pageWidth="1450" pageHeight="300" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1450" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="0.75"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="H3_site_code_exc" class="java.lang.String"/>
	<parameter name="H3_from_date" class="java.util.Date"/>
	<parameter name="H3_to_date" class="java.util.Date"/>
	<parameter name="FROM_DATE" class="java.util.Date" isForPrompting="false">
		<parameterDescription><![CDATA[]]></parameterDescription>
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT  A.UNIT as UNIT,
        A.CHAP_HEADING as CHAP_HEADING,
        A.ITM_SER as ITM_SER,
        SUM(A.OPN_STK) as OPN_STK,
        SUM(A.MANUFACTURED_QTY) as MANUFACTURED_QTY ,
        SUM(A.CLEARED_QTY) as CLEARED_QTY,
        SUM(A.ASSBLE_VAL) as ASSBLE_VAL,
        MAX(A.RATE_OF_DUTY_CENVAT) as RATE_OF_DUTY_CENVAT,
        sum(A.DUTY_PAYABLE_CENVAT)as DUTY_PAYABLE_CENVAT,
        MAX(A.RATE_OF_DUTY_CESS) as RATE_OF_DUTY_CESS,
        SUM(A.DUTY_PAYABLE_CESS) as DUTY_PAYABLE_CESS,
        MAX(A.RATE_OF_DUTY_SHEC) as RATE_OF_DUTY_SHEC,
        sum(A.duty_payable_shec) as duty_payable_shec
FROM
(SELECT
       trim(item.unit) as unit,
       trim(taxchap.chap_heading) as chap_heading,
       (case when item.item_ser='BD' then 'Bulk Drugs' when item.item_ser='RM1' then 'Bulk Drugs' when  item.item_ser='BDI' then 'Bulk Drugs' when item.item_ser is null then null  else 'Pharmaceutical Products' end) as itm_ser,
NVL((DDF_INV_CLSTK_RG1(INVTRACE.SITE_CODE,INVTRACE.ITEM_CODE,INVTRACE.LOT_NO,TRUNC(TO_DATE('01-'||TO_CHAR(TO_DATE(INVTRACE.TRAN_DATE,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')) -1,'I','YN')),0) as  OPN_STK,
       SUM(case when  (invtrace.ref_ser ='P-RCP' or  invtrace.ref_ser = 'D-RCP' or invtrace.ref_ser ='W-RCP' or invtrace.ref_ser ='QC-ORD')  and invtrace.eff_qty > 0 THEN invtrace.eff_qty ELSE 0 END ) AS manufactured_qty,
       SUM(ABS(case when  (invtrace.ref_ser ='S-DSP' or  invtrace.ref_ser = 'P-RET' or invtrace.ref_ser ='D-ISS')  and invtrace.eff_qty < 0 THEN invtrace.eff_qty ELSE 0 END )) AS cleared_qty,
       sum((case when invtrace.ref_ser ='S-DSP' or  invtrace.ref_ser = 'D-ISS'  or invtrace.ref_ser = 'P-RET' then    ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'ABT_TAX_CODE','A')else 0 end )) +
       SUM(CASE WHEN  (INVTRACE.REF_SER ='S-DSP' AND (SORDER.ORDER_TYPE IN ('EF','EB'))) OR  (INVTRACE.REF_SER = 'D-ISS' AND DDF_RETURNSORDTYPE(INVTRACE.REF_ID) IN ('EF','EB')) THEN  (DDF_GET_TAX_DETAILS(INVTRACE.REF_SER,INVTRACE.REF_ID,INVTRACE.REF_LINE,'DUTYFREE_BONDTAX_RG1','A') ) ELSE 0 END ) +
       SUM((CASE WHEN NVL(DDF_GET_TAX_DETAILS(INVTRACE.REF_SER,INVTRACE.REF_ID,INVTRACE.REF_LINE,'ABT_TAX_CODE','A'),0) <= 0 AND INVTRACE.REF_SER IN ('S-DSP','D-ISS','P-RET') THEN DDF_GET_TAX_DETAILS(INVTRACE.REF_SER,INVTRACE.REF_ID,INVTRACE.REF_LINE,'EXC_TAX_CODE_MODVAT','A') ELSE 0 END ))
    as assble_val,
       max(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'EXC_TAX_CODE_MODVAT','P')) AS rate_of_duty_cenvat,
       SUM(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'EXC_TAX_CODE_MODVAT','T')) as duty_payable_cenvat,
       max(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'CESS_TAX_CODE_MODVAT','P')) AS rate_of_duty_cess,
       SUM(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'CESS_TAX_CODE_MODVAT','T')) as duty_payable_cess,
       max(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'SHEC_TAX_CODE_MODVAT','P')) AS rate_of_duty_shec,
       SUM(ddf_get_tax_details(invtrace.ref_ser,invtrace.ref_id,invtrace.ref_line,'SHEC_TAX_CODE_MODVAT','T')) as duty_payable_shec
FROM
	invtrace ,
	item     ,
	site     ,
	siteitem ,
	invstat  ,
	location ,
	taxchap  ,
   despatch ,
   sorder
WHERE   invtrace.item_code  			= item.item_code
and	  site.site_code      			= invtrace.site_code
and	  invtrace.loc_code   			= location.loc_code
and	  location.inv_stat   			= invstat.inv_stat
and     despatch.desp_id(+) 			= invtrace.ref_id
and     despatch.sord_no    			= sorder.sale_order(+)
and	  invtrace.site_code  			= siteitem.site_code
and	  invtrace.item_code  			= siteitem.item_code
and	  taxchap.tax_chap(+) 			= item.tax_chap
AND     invtrace.ref_ser 				NOT IN ('I-PKI','I-PKR','XFRX')
AND     (invtrace.loc_code 			NOT IN ('INTR','EXSH','FROOM') )
AND     (siteitem.item_ser__rg1 = 'FS' or siteitem.item_ser__rg1 = 'EX' or siteitem.item_ser__rg1 = 'BD' or siteitem.item_ser__rg1 = 'RM1' or siteitem.item_ser__rg1 = 'PM1' or siteitem.item_ser__rg1 is null )
AND   (nvl(trim(taxchap.chap_type),'E')='E')
AND     (location.loc_group like '%BSR%' or location.loc_group like '%SAMP%' or  location.loc_group like '%EXP%' )
AND     INVTRACE.TRAN_DATE BETWEEN $P{H3_from_date} AND $P{H3_to_date}
AND     SITE.SITE_CODE__EXC =$P{H3_site_code_exc}
GROUP BY  item.unit, taxchap.chap_heading, (case when item.item_ser='BD' then 'Bulk Drugs' when item.item_ser='RM1' then 'Bulk Drugs' when  item.item_ser='BDI' then 'Bulk Drugs' when item.item_ser is null then null  else 'Pharmaceutical Products' end), NVL((DDF_INV_CLSTK_RG1(INVTRACE.SITE_CODE,INVTRACE.ITEM_CODE,INVTRACE.LOT_NO,TRUNC(TO_DATE('01-'||TO_CHAR(TO_DATE(INVTRACE.TRAN_DATE,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')) -1,'I','YN')),0)
)a
GROUP BY  A.UNIT, A.CHAP_HEADING, A.ITM_SER
order by A.UNIT,A.CHAP_HEADING,A.ITM_SER]]>
	</queryString>
	<field name="UNIT" class="java.lang.String"/>
	<field name="CHAP_HEADING" class="java.lang.String"/>
	<field name="ITM_SER" class="java.lang.String"/>
	<field name="OPN_STK" class="java.lang.Double"/>
	<field name="MANUFACTURED_QTY" class="java.lang.Double"/>
	<field name="CLEARED_QTY" class="java.lang.Double"/>
	<field name="ASSBLE_VAL" class="java.lang.Double"/>
	<field name="RATE_OF_DUTY_CENVAT" class="java.lang.Double"/>
	<field name="DUTY_PAYABLE_CENVAT" class="java.lang.Double"/>
	<field name="RATE_OF_DUTY_CESS" class="java.lang.Double"/>
	<field name="DUTY_PAYABLE_CESS" class="java.lang.Double"/>
	<field name="RATE_OF_DUTY_SHEC" class="java.lang.Double"/>
	<field name="DUTY_PAYABLE_SHEC" class="java.lang.Double"/>
	<variable name="Total_ass_val" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{ASSBLE_VAL}]]></variableExpression>
	</variable>
	<variable name="Duty_Payable" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[new java.lang.Double($F{DUTY_PAYABLE_CENVAT}.doubleValue() + $F{DUTY_PAYABLE_CESS}.doubleValue() + $F{DUTY_PAYABLE_SHEC}.doubleValue())]]></variableExpression>
	</variable>
	<variable name="closing_bal" class="java.lang.Double">
		<variableExpression><![CDATA[new java.lang.Double($F{OPN_STK}.doubleValue() +$F{MANUFACTURED_QTY}.doubleValue()-$F{CLEARED_QTY}.doubleValue())]]></variableExpression>
	</variable>
	<variable name="Sum_op_bal" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{OPN_STK}]]></variableExpression>
	</variable>
	<variable name="Sum_mfg_qty" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{MANUFACTURED_QTY}]]></variableExpression>
	</variable>
	<variable name="Sum_clrd_qty" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{CLEARED_QTY}]]></variableExpression>
	</variable>
	<variable name="Sum_closing_bal" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$V{closing_bal}]]></variableExpression>
	</variable>
	<variable name="v_asses_val" class="java.lang.Double">
		<variableExpression><![CDATA[$F{ASSBLE_VAL}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="101" splitType="Stretch">
			<staticText>
				<reportElement x="3" y="2" width="364" height="17"/>
				<textElement>
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[  3    Details of the Manufacturer, Clearance of Duty Payable
]]></text>
			</staticText>
			<rectangle>
				<reportElement x="2" y="20" width="1438" height="80"/>
			</rectangle>
			<staticText>
				<reportElement x="4" y="21" width="117" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[CETSH NO.
]]></text>
			</staticText>
			<staticText>
				<reportElement x="122" y="20" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Description of]]></text>
			</staticText>
			<staticText>
				<reportElement x="122" y="42" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Goods]]></text>
			</staticText>
			<staticText>
				<reportElement x="206" y="21" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Unit of]]></text>
			</staticText>
			<staticText>
				<reportElement x="207" y="42" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity]]></text>
			</staticText>
			<staticText>
				<reportElement x="267" y="20" width="98" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Opening Balance]]></text>
			</staticText>
			<staticText>
				<reportElement x="368" y="20" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity]]></text>
			</staticText>
			<staticText>
				<reportElement x="369" y="41" width="77" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Manufactured]]></text>
			</staticText>
			<staticText>
				<reportElement x="448" y="20" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity]]></text>
			</staticText>
			<staticText>
				<reportElement x="448" y="41" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Cleared]]></text>
			</staticText>
			<staticText>
				<reportElement x="510" y="21" width="104" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Closing Balance]]></text>
			</staticText>
			<staticText>
				<reportElement x="622" y="21" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Assessable]]></text>
			</staticText>
			<staticText>
				<reportElement x="622" y="42" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Value (Rs.)]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="23" width="185" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="913" y="20" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Notification]]></text>
			</staticText>
			<staticText>
				<reportElement x="913" y="41" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Availed]]></text>
			</staticText>
			<staticText>
				<reportElement x="1006" y="20" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Serial No.]]></text>
			</staticText>
			<staticText>
				<reportElement x="1005" y="41" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[In]]></text>
			</staticText>
			<staticText>
				<reportElement x="1005" y="62" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Notification
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="20" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Rate of]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="41" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="62" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Adv)]]></text>
			</staticText>
			<staticText>
				<reportElement x="1164" y="20" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Rate of]]></text>
			</staticText>
			<staticText>
				<reportElement x="1164" y="41" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="1164" y="62" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Specific)]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="19" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="41" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Payable]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="61" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Rs.)]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="22" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Provisional]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="42" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Assessment]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="62" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Number (if any)]]></text>
			</staticText>
			<line>
				<reportElement x="2" y="80" width="1438" height="1"/>
			</line>
			<staticText>
				<reportElement x="4" y="79" width="117" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[1]]></text>
			</staticText>
			<staticText>
				<reportElement x="122" y="79" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[2]]></text>
			</staticText>
			<staticText>
				<reportElement x="206" y="79" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[3]]></text>
			</staticText>
			<staticText>
				<reportElement x="267" y="79" width="98" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[3 (A)]]></text>
			</staticText>
			<staticText>
				<reportElement x="368" y="79" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[4]]></text>
			</staticText>
			<staticText>
				<reportElement x="448" y="79" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[5]]></text>
			</staticText>
			<staticText>
				<reportElement x="510" y="80" width="104" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[5 (A)]]></text>
			</staticText>
			<staticText>
				<reportElement x="621" y="81" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[6]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="79" width="185" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[7]]></text>
			</staticText>
			<staticText>
				<reportElement x="916" y="80" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[8]]></text>
			</staticText>
			<staticText>
				<reportElement x="1008" y="80" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[9]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="81" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[10]]></text>
			</staticText>
			<staticText>
				<reportElement x="1162" y="79" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[11]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="81" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[12]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="81" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[13]]></text>
			</staticText>
			<line>
				<reportElement x="121" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="204" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="265" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="366" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="446" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="507" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="617" y="21" width="1" height="78"/>
			</line>
			<line>
				<reportElement x="723" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="911" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="1005" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="1084" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="1161" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="1225" y="20" width="1" height="80"/>
			</line>
			<line>
				<reportElement x="1329" y="20" width="1" height="80"/>
			</line>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="91" splitType="Stretch">
			<rectangle>
				<reportElement x="2" y="0" width="1438" height="91"/>
			</rectangle>
			<line>
				<reportElement x="3" y="32" width="1438" height="1"/>
			</line>
			<staticText>
				<reportElement x="-1112" y="-71" width="100" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[1]]></text>
			</staticText>
			<line>
				<reportElement x="3" y="63" width="1438" height="1"/>
			</line>
			<line>
				<reportElement x="265" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="120" y="1" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="203" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="365" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="445" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="507" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="616" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="723" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="910" y="1" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="1004" y="0" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="1083" y="1" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="1160" y="1" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="1225" y="1" width="1" height="90"/>
			</line>
			<line>
				<reportElement x="1328" y="0" width="1" height="90"/>
			</line>
			<textField isBlankWhenNull="true">
				<reportElement x="206" y="0" width="58" height="31"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{UNIT}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="725" y="2" width="100" height="30"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Basic Excise Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="34" width="100" height="29"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Education Cess]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" x="725" y="65" width="142" height="23"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Secondary & Higher Ed. Cess]]></text>
			</staticText>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="368" y="0" width="77" height="30"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{MANUFACTURED_QTY}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="445" y="0" width="61" height="30"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{CLEARED_QTY}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1085" y="0" width="44" height="30"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_CENVAT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1227" y="0" width="100" height="32"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{DUTY_PAYABLE_CENVAT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1084" y="34" width="45" height="29"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_CESS}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1227" y="34" width="100" height="29"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{DUTY_PAYABLE_CESS}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1083" y="65" width="46" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_SHEC}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1227" y="64" width="100" height="24"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{DUTY_PAYABLE_SHEC}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1162" y="0" width="37" height="30"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_CENVAT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1162" y="34" width="37" height="29"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_CESS}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="true">
				<reportElement x="1162" y="65" width="37" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RATE_OF_DUTY_SHEC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1129" y="0" width="31" height="30"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<staticText>
				<reportElement x="1131" y="36" width="29" height="27"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<staticText>
				<reportElement x="1130" y="66" width="30" height="22"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<staticText>
				<reportElement x="1199" y="0" width="25" height="28"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<staticText>
				<reportElement x="1199" y="35" width="25" height="27"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<staticText>
				<reportElement x="1199" y="65" width="25" height="23"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[%]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="122" y="0" width="81" height="27"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{ITM_SER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="4" y="0" width="116" height="27"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{CHAP_HEADING}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="510" y="0" width="104" height="29"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{closing_bal}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="268" y="0" width="94" height="27"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{OPN_STK}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="622" y="2" width="99" height="25"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{ASSBLE_VAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="21" splitType="Stretch">
			<rectangle>
				<reportElement x="2" y="0" width="720" height="20"/>
			</rectangle>
			<line>
				<reportElement x="616" y="0" width="1" height="20"/>
			</line>
			<staticText>
				<reportElement x="2" y="1" width="262" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL :]]></text>
			</staticText>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="621" y="1" width="100" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Total_ass_val}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement x="722" y="0" width="718" height="20"/>
			</rectangle>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1228" y="0" width="100" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Duty_Payable}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="507" y="-1" width="1" height="20"/>
			</line>
			<line>
				<reportElement mode="Opaque" x="445" y="1" width="1" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<graphicElement fill="Solid"/>
			</line>
			<line>
				<reportElement mode="Opaque" x="365" y="-1" width="1" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<graphicElement fill="Solid"/>
			</line>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="369" y="1" width="76" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Sum_mfg_qty}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="448" y="1" width="58" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Sum_clrd_qty}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="510" y="1" width="104" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Sum_closing_bal}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="268" y="1" width="94" height="18"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Sum_op_bal}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
	<noData>
		<band height="163">
			<staticText>
				<reportElement x="3" y="2" width="364" height="17"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[  3    Details of the Manufacturer, Clearance of Duty Payable
]]></text>
			</staticText>
			<rectangle>
				<reportElement x="2" y="20" width="1438" height="140"/>
			</rectangle>
			<staticText>
				<reportElement x="4" y="22" width="117" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[CETSH NO.
]]></text>
			</staticText>
			<line>
				<reportElement x="121" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="122" y="22" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Description of]]></text>
			</staticText>
			<staticText>
				<reportElement x="122" y="42" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Goods]]></text>
			</staticText>
			<line>
				<reportElement x="203" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="206" y="22" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Unit of]]></text>
			</staticText>
			<staticText>
				<reportElement x="206" y="43" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity]]></text>
			</staticText>
			<line>
				<reportElement x="265" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="267" y="21" width="98" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Opening Balance
]]></text>
			</staticText>
			<line>
				<reportElement x="365" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="368" y="22" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity
]]></text>
			</staticText>
			<staticText>
				<reportElement x="368" y="42" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Manufactured
]]></text>
			</staticText>
			<line>
				<reportElement x="445" y="21" width="1" height="139"/>
			</line>
			<staticText>
				<reportElement x="448" y="23" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Quantity
]]></text>
			</staticText>
			<staticText>
				<reportElement x="448" y="44" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Cleared
]]></text>
			</staticText>
			<line>
				<reportElement x="507" y="21" width="1" height="139"/>
			</line>
			<staticText>
				<reportElement x="510" y="23" width="104" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Closing Balance
]]></text>
			</staticText>
			<line>
				<reportElement x="617" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="622" y="22" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Assessable
]]></text>
			</staticText>
			<staticText>
				<reportElement x="622" y="42" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Value (Rs.)
]]></text>
			</staticText>
			<line>
				<reportElement x="723" y="20" width="1" height="141"/>
			</line>
			<staticText>
				<reportElement x="725" y="22" width="185" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty]]></text>
			</staticText>
			<line>
				<reportElement x="910" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="913" y="22" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Notification
]]></text>
			</staticText>
			<staticText>
				<reportElement x="913" y="44" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Availed
]]></text>
			</staticText>
			<line>
				<reportElement x="1003" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="1006" y="21" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Serial No.
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1006" y="41" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[In
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1006" y="61" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Notification
]]></text>
			</staticText>
			<line>
				<reportElement x="1083" y="21" width="1" height="139"/>
			</line>
			<staticText>
				<reportElement x="1086" y="21" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Rate of
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="41" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="61" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Adv)
]]></text>
			</staticText>
			<line>
				<reportElement x="1161" y="20" width="1" height="140"/>
			</line>
			<staticText>
				<reportElement x="1164" y="21" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Rate of
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1164" y="41" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1164" y="61" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Specific)
]]></text>
			</staticText>
			<line>
				<reportElement x="1226" y="19" width="1" height="141"/>
			</line>
			<staticText>
				<reportElement x="1227" y="21" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Duty
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="41" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Payable
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="62" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[(Rs.)
]]></text>
			</staticText>
			<line>
				<reportElement x="1328" y="21" width="1" height="139"/>
			</line>
			<staticText>
				<reportElement x="1331" y="21" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Provisional
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="41" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Assessment
]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="61" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[Number (if any)

]]></text>
			</staticText>
			<line>
				<reportElement x="2" y="80" width="1438" height="1"/>
			</line>
			<staticText>
				<reportElement x="4" y="81" width="117" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[1]]></text>
			</staticText>
			<staticText>
				<reportElement x="122" y="81" width="82" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[2]]></text>
			</staticText>
			<staticText>
				<reportElement x="206" y="81" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[3]]></text>
			</staticText>
			<staticText>
				<reportElement x="267" y="81" width="98" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[3 (A)]]></text>
			</staticText>
			<staticText>
				<reportElement x="368" y="81" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[4]]></text>
			</staticText>
			<staticText>
				<reportElement x="448" y="81" width="58" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[5]]></text>
			</staticText>
			<staticText>
				<reportElement x="510" y="81" width="104" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[5 (A)]]></text>
			</staticText>
			<staticText>
				<reportElement x="622" y="81" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[6]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="81" width="185" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[7]]></text>
			</staticText>
			<staticText>
				<reportElement x="916" y="81" width="90" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[8]]></text>
			</staticText>
			<staticText>
				<reportElement x="1008" y="81" width="78" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[9]]></text>
			</staticText>
			<staticText>
				<reportElement x="1086" y="81" width="76" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[10]]></text>
			</staticText>
			<staticText>
				<reportElement x="1162" y="81" width="61" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[11]]></text>
			</staticText>
			<staticText>
				<reportElement x="1227" y="81" width="101" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[12]]></text>
			</staticText>
			<staticText>
				<reportElement x="1331" y="81" width="109" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[13]]></text>
			</staticText>
			<line>
				<reportElement x="2" y="100" width="1438" height="1"/>
			</line>
			<line>
				<reportElement x="2" y="120" width="1438" height="1"/>
			</line>
			<line>
				<reportElement x="2" y="140" width="1438" height="1"/>
			</line>
			<staticText>
				<reportElement x="725" y="102" width="185" height="18"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Basic Excise Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="122" width="185" height="18"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Education Cess]]></text>
			</staticText>
			<staticText>
				<reportElement x="725" y="142" width="185" height="18"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Secondary & Higher Ed. Cess]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
