<?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_er6" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="801"/>
	<property name="ireport.y" value="272"/>
	<parameter name="AS_FROM_DATE" class="java.util.Date"/>
	<parameter name="AS_TO_DATE" class="java.util.Date"/>
	<parameter name="AS_SITE_CODE" class="java.lang.String"/>
	<queryString>
		<![CDATA[select  e.item_code as itemcode,d.bom_code,
       (f.descr||','||f.add1||','||f.city) as siteadd,
        g.descr  as  principal_input,
        g.unit   as principal_item_unit,
        nvl((ddf_inv_clstk(f.site_code,e.item_code,null,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')) -1,'I','Y')),0) as open_stk,
        nvl(fn_er6_receipt(e.item_code,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')),last_day(to_date(c.ord_date)),'ER6_REF_SER_RECIEPT'),0) as receipt,
        nvl(sum(fn_er6_iss_receipt(e.item_code,TRUNC(TO_DATE('01-'||TO_CHAR(TO_DATE(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')),last_day(to_date(c.ord_date)),'ER6_REF_SER_WORKISS')),0)  as taken_manu_qty,
       nvl(ddf_inv_clstk(f.site_code,e.item_code,null,last_day(to_date(c.ord_date)),'I','Y'),0) AS close_stk,
        d.descr  as fg_descr,
        d.unit   as fg_item_unit,
        NVL(FN_ER6_SUM_WO_FG_QTY(d.bom_code,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')),last_day(to_date(c.ord_date))),0)  AS  SUM_FG_QTY
from   bom d,
       bomdet e,
       WORKORDER C,
       site f,
       item g
where  d.bom_code       = e.bom_code
and    e.item_code      = g.item_code
and    d.bom_code       = c.bom_code
and    c.site_code      = f.site_code
AND    C.WORK_ORDER IN (SELECT WORK_ORDER FROM WORKORDER_ISS WHERE TRAN_DATE between $P{AS_FROM_DATE} and $P{AS_TO_DATE})
and    D.active           = 'Y'
and    D.confirmed        = 'Y'
and    E.item_category = 'A'
and    E.crit_item     = 'Y'
and    f.site_code__exc        = $P{AS_SITE_CODE}
and    C.ord_date between $P{AS_FROM_DATE} and $P{AS_TO_DATE}
group by e.item_code,d.bom_code,
(f.descr||','||f.add1||','||f.city),
g.descr, g.unit,
nvl((ddf_inv_clstk(f.site_code,e.item_code,null,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')) -1,'I','Y')),0),
nvl(fn_er6_receipt(e.item_code,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')),last_day(to_date(c.ord_date)),'ER6_REF_SER_RECIEPT'),0),
nvl(ddf_inv_clstk(f.site_code,e.item_code,null,last_day(to_date(c.ord_date)),'I','Y'),0),
d.descr, d.unit,
NVL(FN_ER6_SUM_WO_FG_QTY(d.bom_code,trunc(to_date('01-'||to_char(to_date(c.ord_date,'DD-MM-RRRR'),'MM-RRRR'),'DD-MM-RRRR')),last_day(to_date(c.ord_date))),0)
order by itemcode]]>
	</queryString>
	<field name="ITEMCODE" class="java.lang.String"/>
	<field name="BOM_CODE" class="java.lang.String"/>
	<field name="SITEADD" class="java.lang.String"/>
	<field name="PRINCIPAL_INPUT" class="java.lang.String"/>
	<field name="PRINCIPAL_ITEM_UNIT" class="java.lang.String"/>
	<field name="OPEN_STK" class="java.lang.Double"/>
	<field name="RECEIPT" class="java.lang.Double"/>
	<field name="TAKEN_MANU_QTY" class="java.lang.Double"/>
	<field name="CLOSE_STK" class="java.lang.Double"/>
	<field name="FG_DESCR" class="java.lang.String"/>
	<field name="FG_ITEM_UNIT" class="java.lang.String"/>
	<field name="SUM_FG_QTY" class="java.lang.Double"/>
	<variable name="Removed_Qty" class="java.lang.Double" resetType="None">
		<variableExpression><![CDATA[new java.lang.Double(Math.abs($F{OPEN_STK}.doubleValue()+ $F{RECEIPT}.doubleValue()-$F{TAKEN_MANU_QTY}.doubleValue()-$F{CLOSE_STK}.doubleValue()))]]></variableExpression>
	</variable>
	<variable name="Sr No" class="java.lang.Integer" resetType="None" calculation="DistinctCount">
		<variableExpression><![CDATA[$F{ITEMCODE}]]></variableExpression>
	</variable>
	<variable name="Sr No._1" class="java.lang.Integer" resetType="Group" resetGroup="ITEMCODE" calculation="Sum">
		<variableExpression><![CDATA[new java.lang.Integer($V{COLUMN_NUMBER}.intValue())]]></variableExpression>
	</variable>
	<variable name="v_closing_bal" class="java.lang.Double">
		<variableExpression><![CDATA[new java.lang.Double(Math.abs($F{CLOSE_STK}.doubleValue()))]]></variableExpression>
	</variable>
	<variable name="vs_site_code" class="java.lang.String">
		<variableExpression><![CDATA[$P{AS_SITE_CODE}]]></variableExpression>
	</variable>
	<variable name="V_OPENING_BAL" class="java.lang.Double">
		<variableExpression><![CDATA[new java.lang.Double(Math.abs($F{OPEN_STK}.doubleValue()))]]></variableExpression>
	</variable>
	<group name="ITEMCODE">
		<groupExpression><![CDATA[$F{ITEMCODE}]]></groupExpression>
		<groupHeader>
			<band/>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="135" splitType="Stretch">
			<staticText>
				<reportElement x="351" y="0" width="66" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[FORM ER-6]]></text>
			</staticText>
			<staticText>
				<reportElement x="271" y="17" width="257" height="14"/>
				<textElement/>
				<text><![CDATA[{sub-rule (3) of rule 9A of CENVAT Credit Rules,2004}]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="43" width="128" height="15"/>
				<textElement/>
				<text><![CDATA[Name of the manufacturer:]]></text>
			</staticText>
			<textField>
				<reportElement x="128" y="43" width="664" height="15"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITEADD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="61" width="154" height="17"/>
				<textElement/>
				<text><![CDATA[PAN based Registration Number: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="83" width="154" height="14"/>
				<textElement/>
				<text><![CDATA[Month to which the return relates :]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="100" width="369" height="20"/>
				<textElement/>
				<text><![CDATA[Details of receipt and consumption of principal inputs and finished excisable goods:]]></text>
			</staticText>
			<subreport>
				<reportElement x="155" y="59" width="143" height="10"/>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="site_code">
					<subreportParameterExpression><![CDATA[$P{AS_SITE_CODE}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream("D:/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml/d_er6_subreport1_siteregno.jasper")]]></subreportExpression>
			</subreport>
			<textField pattern="MMMMM - yyyy">
				<reportElement x="155" y="83" width="143" height="14"/>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{AS_FROM_DATE}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="104" splitType="Stretch">
			<line>
				<reportElement x="0" y="3" width="802" height="1"/>
			</line>
			<staticText>
				<reportElement x="3" y="5" width="22" height="19"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[S.NO.]]></text>
			</staticText>
			<line>
				<reportElement x="1" y="4" width="1" height="67"/>
			</line>
			<line>
				<reportElement x="25" y="4" width="1" height="66"/>
			</line>
			<staticText>
				<reportElement x="27" y="5" width="219" height="64"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[Description of Principal Inputs]]></text>
			</staticText>
			<line>
				<reportElement x="260" y="4" width="1" height="66"/>
			</line>
			<staticText>
				<reportElement x="262" y="5" width="31" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Quantity Code]]></text>
			</staticText>
			<line>
				<reportElement x="293" y="4" width="1" height="67"/>
			</line>
			<staticText>
				<reportElement x="296" y="5" width="55" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Opening Balance]]></text>
			</staticText>
			<line>
				<reportElement x="351" y="4" width="1" height="67"/>
			</line>
			<staticText>
				<reportElement x="353" y="5" width="48" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Receipt]]></text>
			</staticText>
			<line>
				<reportElement x="403" y="4" width="1" height="65"/>
			</line>
			<staticText>
				<reportElement x="405" y="5" width="53" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Taken for use in the manufacture of dutiable and exempted finished goods]]></text>
			</staticText>
			<line>
				<reportElement x="459" y="4" width="1" height="67"/>
			</line>
			<staticText>
				<reportElement x="460" y="5" width="56" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Removed as such for export or for home consumption]]></text>
			</staticText>
			<line>
				<reportElement x="517" y="4" width="1" height="66"/>
			</line>
			<staticText>
				<reportElement x="521" y="5" width="52" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Closing
Balance]]></text>
			</staticText>
			<line>
				<reportElement x="573" y="3" width="1" height="67"/>
			</line>
			<staticText>
				<reportElement x="572" y="5" width="125" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Finished Goods manufactured out of inputs]]></text>
			</staticText>
			<line>
				<reportElement x="704" y="4" width="1" height="67"/>
			</line>
			<staticText>
				<reportElement x="705" y="5" width="31" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Quantity code of Finished Goods ]]></text>
			</staticText>
			<line>
				<reportElement x="736" y="4" width="1" height="66"/>
			</line>
			<staticText>
				<reportElement x="736" y="5" width="62" height="63"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Quantity of Finished Goods Manufactured]]></text>
			</staticText>
			<line>
				<reportElement x="800" y="4" width="1" height="66"/>
			</line>
			<line>
				<reportElement x="1" y="70" width="800" height="1"/>
			</line>
			<line>
				<reportElement x="1" y="85" width="800" height="1"/>
			</line>
			<line>
				<reportElement x="1" y="103" width="800" height="1"/>
			</line>
			<line>
				<reportElement x="594" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="1" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="25" y="70" width="1" height="33"/>
			</line>
			<line>
				<reportElement x="260" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="293" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="351" y="70" width="1" height="33"/>
			</line>
			<line>
				<reportElement x="403" y="69" width="1" height="34"/>
			</line>
			<line>
				<reportElement x="459" y="71" width="1" height="33"/>
			</line>
			<line>
				<reportElement x="517" y="71" width="1" height="33"/>
			</line>
			<line>
				<reportElement x="573" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="704" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="736" y="71" width="1" height="32"/>
			</line>
			<line>
				<reportElement x="800" y="71" width="1" height="33"/>
			</line>
			<staticText>
				<reportElement x="574" y="71" width="20" height="14"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[ Sr No]]></text>
			</staticText>
			<staticText>
				<reportElement x="620" y="71" width="53" height="14"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Description]]></text>
			</staticText>
			<staticText>
				<reportElement x="7" y="86" width="12" height="17"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<text><![CDATA[(1)]]></text>
			</staticText>
			<staticText>
				<reportElement x="128" y="86" width="13" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(2)]]></text>
			</staticText>
			<staticText>
				<reportElement x="269" y="86" width="14" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(3)]]></text>
			</staticText>
			<staticText>
				<reportElement x="314" y="86" width="11" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(4)]]></text>
			</staticText>
			<staticText>
				<reportElement x="361" y="86" width="12" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(5)]]></text>
			</staticText>
			<staticText>
				<reportElement x="421" y="86" width="15" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(6)]]></text>
			</staticText>
			<staticText>
				<reportElement x="478" y="85" width="14" height="18"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(7)]]></text>
			</staticText>
			<staticText>
				<reportElement x="541" y="86" width="18" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(8)]]></text>
			</staticText>
			<staticText>
				<reportElement x="574" y="86" width="20" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(9A)]]></text>
			</staticText>
			<staticText>
				<reportElement x="636" y="85" width="16" height="18"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(9B)]]></text>
			</staticText>
			<staticText>
				<reportElement x="711" y="86" width="19" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(10)]]></text>
			</staticText>
			<staticText>
				<reportElement x="750" y="86" width="18" height="17"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[(11)]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="35" splitType="Stretch">
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="1" y="0" width="1" height="35"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="25" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="260" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="293" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="351" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="403" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="459" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="517" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="573" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="594" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="704" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="736" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="800" y="0" width="1" height="34"/>
			</line>
			<line>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="1" y="33" width="799" height="1" printWhenGroupChanges="ITEMCODE"/>
			</line>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="27" y="0" width="233" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PRINCIPAL_INPUT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="262" y="0" width="30" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PRINCIPAL_ITEM_UNIT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="351" y="0" width="51" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{RECEIPT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="###0.00" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="402" y="0" width="55" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{TAKEN_MANU_QTY}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="596" y="0" width="107" height="33"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FG_DESCR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="705" y="0" width="31" height="33"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FG_ITEM_UNIT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="###0.00" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="737" y="0" width="62" height="33"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{SUM_FG_QTY}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="5" y="0" width="18" height="33"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{Sr No}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="575" y="0" width="19" height="33"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{Sr No._1}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="###0.00" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="460" y="0" width="56" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{Removed_Qty}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="###0.00" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="518" y="0" width="54" height="33" printWhenGroupChanges="ITEMCODE"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{v_closing_bal}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="298" y="0" width="53" height="31"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{V_OPENING_BAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="312" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="801" height="312"/>
				<textElement>
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Note:-

(1)   Finished Goods mentioned in Column 9(B) should be stated in respect of the inputs mwntioned in Column
      (2) and (6)

(2)   Please indicate the abbreviation referred to in instruction No.7 mentioned in Form E.R-1 and Form E.R-3 specified
      in the Government of India.Ministry of Finance (Department of Revenue) vide No.25/2004-Central Excise (N.T.) dated
      27th September,2004 published vide G.S.R.No. 643(E)dated the 25th September 2004.

6.(i) I\We hereby declare that the particulars declared above have been compared with the records and books
      of my/our factory/warehouse and the same are true and correct to the best of my/our knowledge

  (ii)I\am\We are authorised to sign this return.

                                                                                                                                                                       (Authorised Signatory)

   Place  :
   Date   :

                                              ACKNOWLEDGMENT

  Return of excisable goods and availment of CENVAT creadit for the month of

  Date of Reciept: ]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
