excise periodic transaction india

25
SAP ECC 6.00 June 2007 English J94: Excise Periodic Processing SAP AG Dietmar-Hopp-Allee 16 69190 Walldorf Germany Building Block Business Process Procedure

Upload: nayak4u

Post on 20-Oct-2015

73 views

Category:

Documents


2 download

DESCRIPTION

Excise sap

TRANSCRIPT

Page 1: Excise Periodic Transaction India

SAP ECC 6.00

June 2007

English

J94: Excise Periodic Processing

SAP AG Dietmar-Hopp-Allee 16 69190 Walldorf Germany

Building Block Business Process Procedure

Page 2: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 2 of 25

Copyright

© Copyright 2007 SAP AG. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, OS/2, Parallel Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390, OS/400, iSeries, pSeries, xSeries, zSeries, System i, System i5, System p, System p5, System x, System z, System z9, z/OS, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, Informix, i5/OS, POWER, POWER5, POWER5+, OpenPower and PowerPC are trademarks or registered trademarks of IBM Corporation.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems, Inc.

JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

MaxDB is a trademark of MySQL AB, Sweden.

SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, Duet, PartnerEdge, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

Page 3: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 3 of 25

Icons

Icon Meaning

Caution

Example

Note

Recommendation

Syntax

Typographic Conventions

Type Style Description

Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.

Cross-references to other documentation.

Example text Emphasized words or phrases in body text, titles of graphics and tables.

EXAMPLE TEXT Names of elements in the system. These include report names, program names, Transaction Codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.

Example text Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.

EXAMPLE TEXT Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.

Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.

<Example text> Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

Page 4: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 4 of 25

Contents

1 Excise Periodic Transactions ................................................................................................... 5

1.1 TR6 Challan Posting with PLA Register Updating ......................................................... 5

1.2 Utilization of CENVAT .................................................................................................... 8

2 Excise Report ......................................................................................................................... 12

2.1 CENVAT Register ........................................................................................................ 12

3 Excise Register Updation ....................................................................................................... 14

3.1 Updation of RG1 Register ............................................................................................ 14

3.2 RG1 Register Extraction .............................................................................................. 17

3.3 RG1 Register Print Utility ............................................................................................. 18

3.4 PLA Register Extraction ............................................................................................... 20

3.5 PLA Register Print Utility .............................................................................................. 21

3.6 Register RT- 12 ............................................................................................................ 22

3.7 ER1 Report................................................................................................................... 23

Page 5: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 5 of 25

Excise Periodic Processing

Purpose

Excise Periodic Processing’s that are to be carried out at end of a period. Excise Periodic Processing helps you prepare and carry out the activities required for day-end or month-end and year-end closing.

TR6 Challan Posting with PLA Register Updation

Utilization of CENVAT

RG1 Register updation

Proforma for Monthly Return under Rule 7 of the Cenvat Credit Rules, 2001

Prerequisites

Before execute business scenarios, you need to post the business processes transactions from other scenarios.

As part of the integrated scenario, this scenario needs several BPPs as prerequisites to demonstrate these include:

J64 – Production Planning and Discrete Manufacturing

J49 – Procurement of Stock Materials

J59 – Returns and Complaints

1 Excise Periodic Transactions

1.1 TR6 Challan Posting with PLA Register Updating

Use

You follow this procedure to make a posting when you transfer money to your personal ledger account (PLA) and to update the PLA Register. When you post Financial Accounting Document system shall not update the PLA Register. Hence while posting Financial Accounting post PLA to a clearing account i.e. PLA on Hold account. When you update the TR6 Challan updation process system will update the PLA Register and PLA account and reverse the PLA on Hold Account.

Prerequisites

You have made the posting for transfer of PLA in the Financial Accounting document.

Post the Financial Accounting Document note the document number which generated by system in the following transaction:

Transaction Code : FB50

Company Code : BP01

Document Number : 1000000##(Internally generated number)

Page 6: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 6 of 25

Posting Date : Current Date

Fiscal year : Current Fiscal Year

Currency : INR

GL- 26360210 PLA on Hold Debit INR 1,000,000.00

GL- 24100111 B1#-clg-Chq pymt Credit INR 1,000,000.00

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User menu Indirect Taxes Excise JV

Create

Transaction code J1IH

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Create Excise JV

2. On the Excise JV – Main Menu, select the TR6 Challan.

3. On the Create Excise JV – Initial Screen (TR6 Challan Posting) screen, make the following entries:

Field name Description User action and values Comment

Document Number

Document number Input the document number you just noted.

1000000XX

Enter the Accounting Document number of TR6 Challan number or

TR6 Challan reference number

the number is the accounting document number posted for making the outgoing payment i.e TR6Challan

Document Year

Document year 2007

Fiscal Year

Company Code

Company Code BP01

Plant Plant BP01 For which plant PLA paid

Excise Group Excise Group 21 Plant Excise Group

Sub-transaction Type

Sub-Transaction Type

4. Choose Enter to proceed

Page 7: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 7 of 25

5. On the Details ‘Create Excise JV – Details for TR6 Challan <Document Number, Document Year> Posting’:

6. Header fields

Field name Description User action and values Comment

TR6Challan Number

Document Number Defaulted from the previous step

Grayed out and system defaulted the value

Company Code

Company Code Defaulted from the previous step

Grayed out and system defaulted the value

Plant Plant Defaulted from the previous step

Grayed out and system defaulted the value

Document Date

Document Date System Date Grayed out and system defaulted the value

Posting Date Posting Date System Date If required user can change the posting date

Business Area

Business Area If Business Area is active, then only we need to enter the Business Area

7. TR6Challan Posting Accounts

Credit / Debit G/ L Account Amount Description Comment

C - Credit 0026360210 1000000 PLA on hold-ExGrp 21

Input the Credit Amount, which paid through TR6 Challan

D – Debit 0026360212 0 PLA-AED-ExGrp 21

Input the PLA AED Amount as per TR6 Challan

D – Debit 0026360211 1000000 PLA-BED-ExGrp 21

Input the PLA BED Amount as per TR6 Challan

D – Debit 0026360214 0 PLA-CESS-ExGrp 21

Input the PLA Cess Amount as per TR6 Challan

D - Debit 0026360216 0 PLA-ECS-ExGrp 21

Input the PLA Cenvat BED Amount as per TR6 Challan

D – Debit 0026360213 0 PLA-SED-ExGrp 21

Input the PLA SED Amount as per TR6 Challan

Page 8: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 8 of 25

System will check the total of debit amount must equal to the total of credit amount. Input the values manually based on the TR6 Challan.

8. Post the Excise Document. Excise JV Save. Alternatively: Ctrl + S

Result

Excise JV <JV Document Number>.acctng. No. <Accounting Document Number> with Part2 Sl. <Part Serial Number > has been successfully created.

Message no. 8I212

Example

Excise JV 0000000106 acctng. No. 100000020 with Part2 Sl. 0000010006 has been successfully created

In the above example assumed that, only PLA BED is being paid through TR6 Challan. Based on actual payment corresponding values can be entered.

1.2 Utilization of CENVAT

Use

Utilization of CENVAT scenario is used to calculate how much excise duty you must remit to the authorities. Legislation requires you to remit excise duty monthly. Companies are allowed five days to remit the excise duty, except for the month of March.

Once the report has determined how much you have to pay, it allows you to specify where the money should be paid from – whether it should be deducted from the CENVAT credits that you have accumulated in RG23A Register or RG23C Register, or whether it should be deducted from the personal ledger account (PLA). You have an option to select the appropriation amounts as required.

Prerequisites

User must be assigned the Country India specific menu.

Excise Invoices must be posted in the system to arrive the CENVAT Payable for deliveries made from the factory. The CENVAT payable amount shall be captured to a clearing account as a liability i.e. Credit At the time of utilization of CENVAT system will post the Debit entry to the same account based on the account assignments in the Customization.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Sales /

Outbound Movements Fortnightly Payment

Transaction code J2IUN

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

Page 9: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 9 of 25

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Monthly utilization

2. On the Fortnight Utilization of CENVAT screen, make the following entries:

Field name Description User action and values Comment

Company Code Company code for posting of Excise

BP01

Plant Facility where goods or services are produced or sold.

BP01 Plant

Excise Group Excise Group 21 Based on Excise Group, Excise Records will be updated

SubTransaction Type

Specifies the subtransaction type

Based on this , Accounts Balances will be displayed

ADC SubTransaction Type

Specifies the subtransaction type

This will pick ADC accounts which is assigned for Import Credit

For Example : IP

Business Area Business Area Based usage of Business area need to be entered

Fortnight Payment Posting Date

Posting date for Posting of Utilization document and updation of Excise Registers

Date on which posting has to be made

If no values entered, by default system date will be considered as Posting date for posting of utilization document

Excise Invoice Selection

Period Date range for which Excise Invoices are posted and excise utilization need to be carried out

Date Range Enter the date range for which utilization is to be posted.

Example if utilization for the month of March 2005 enter the from date as 01.03.2005 and

Page 10: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 10 of 25

To date as 31.03.2005

Excise Invoice Excise Invoice numbers for which utilization need to be carried out

If the selection need to be restricted for some invoices this option has to be used otherwise system will select all the invoice in the given period

Then Execute

Additional Options

Simulate Simulate postings in display

Simulate option can be used to display the total Excise payment which needs to be done at the end of the period

Restrict Pending Invoices

Restriction on Invoice Selection

System will restrict the invoices selection based on the entry made in the Excise Invoice numbers entry

Pay AED from BED

Utilization of AED payable from BED balance

Based on requirement select the check box, if the AED to be utilized from BED

Pay SED from BED

Utilization of SED payable from BED balance

Based on requirement select the check box, if SED to be utilized from BED

Display last Utilization date

Displays date of CENVAT was last utilized

To see the upto the date for which CENVAT utilized

Display pending Invoices

Displays the pending invoices based on the selections criteria

To see the pending invoices list this option can be used

3. Choose on execute icon or Choose F8 or Program Execute

Page 11: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 11 of 25

4. On the Details ‘SAP’ screen, make the following entries:

Field name User action and values

Comment

BED SED AED CESS

Available Balances

RG23A

Display the amount available for utilization

RG23C Display the amount available for utilization

PLA Display the amount available for utilization

GL Account Balances

RG23A Display the amount available in GL account

RG23C Display the amount available in GL account

PLA Display the amount available in GL account

Amounts Payable

Total Display the amount payable for the selected period or Invoices

Balance Utilization

RG23A Amount Amount Amount Amount Input the Amount based on the payable under BED, AED, SED and Cess

The input value can not exceed the amount available for utilization

RG23C Amount Amount Amount Amount Input the Amount based on the payable

The input value can not exceed the

Page 12: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 12 of 25

under BED, AED, SED and Cess

amount available for utilization

PLA Amount Amount Amount Amount Input the Amount based on the payable under BED, AED, SED and Cess

The input value can not exceed the amount available for utilization

Balance utilization must be equal to the Amount payable.

After inputting the values use the simulate option. Then system displays the necessary message whether document can be posted, or displays the difference amount needs to be adjusted against RG23A, RG23C or PLA Balance Utilization.

5. The CENVAT Utilization may be posted by choosing on the Save button or Choose - CTR+S

Result

Part 2 posted and accounting document <Accounting Document Number> generated

Example

Part 2 posted and accounting document 100000052 generated

2 Excise Report

2.1 CENVAT Register

Use

Details to submit an Annexure to the Excise Authorities as a Monthly Return Under Rule 57AE of the Central Excise Rules, 2001. CENVAT Register displays input credit details for Raw materials or Capital Goods. This report can be generated detailed as Annexure or summary as Abstract.

Prerequisites

User must be assigned the Indian Localization menu.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax CENVAT Register

Transaction code J2I9

Page 13: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 13 of 25

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions New Monthly Returns Report Rule 57AE

2. On the Proforma for Monthly Return Under Rule 57AE of the Central Excise Rule screen, make the following entries:

Field name Description User action and values Comment

Company Code

Company code BP01

Excise Group Excise Group for which ID for which CENVAT Register is being generated

21

Posting Date Posting date range The date from the beginning of the month to end of the month

Annexure Output to be generated Annexure or Abstract

Select this radio button if the out put is being generated for Annexure

At time you can generate an Annexure or Abstract

Abstract Output to be generated Annexure or Abstract

Select this radio button if the out put is being generated for Abstract

At time you can generate an Annexure or Abstract

Inputs Annexure to be generated for Input materials or Capital Goods

Select this radio button if the out put Annexure is being generated for Input Materials

At time you can generate an Annexure for Input materials or Capital Goods

Capital Goods Annexure to be generated for Input materials or Capital Goods

Select this radio button if the out put Annexure is being generated for Capital Goods

At time you can generate an Annexure for Input materials or Capital Goods

3. The out put can be saved into a local file or printed by using the print options.

Result

You are able to generate Perform for Monthly Return Under Rule 57AE of the Central Excise Rule.

Page 14: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 14 of 25

3 Excise Register Updation

3.1 Updation of RG1 Register

Use

RG1 register maintained at Manufacturing Plants for excisable finished goods. The register shows goods movements from the factory to a store and stores to customer, specifically for excisable finished goods. The R/3 System generates all the necessary entries in the register.

This report only creates register entries for goods movements that have not already been entered. It does not create duplicate entries.

Using this activity, you can also update the goods issue into RG23A Part I and RG23C Part I, Register by select the radio button option in the Registers.

Prerequisites

To extract the data to RG1 Register, Material numbers has to be maintained in the table J_2IRG1BAL - Opening/Closing balance table for RG1.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Update RG23A/C Issues and RG1

Transaction code J1I5

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Register creation for RG23 and RG1

2. On the Update of Registers RG1 and RG23 (Part1) screen, make the following entries:

Field name Description User action and values

Comment

Company Code

Company Code BP01

Plant Plant – for which RG1 Register is being maintained

BP01

Excise Group Excise Group for which RG1 register is being maintained

21

Posting Date Date of Material document Posted

Enter the Material Document Posting

Range for posting date

Page 15: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 15 of 25

Date

Movement Type

Movement Type used for posting the materials

Optional

Storage Location

Storage location used for posting the material movements

Optional

Material Material number to update the RG1 Register

Optional

Document Date

Document date of the material document

Optional

Batch Batch number of the materials

Optional

Stock Type Stock Type declared Optional

Rule Excise Classification Rule

Optional

Classification Pre-defined Classifications

IIM

For updation of goods receipts from Manufacturing plant use RMA

For updation of Goods issue, i.e. Removal from factory on payment of duty for home use – IDH

Receipts RMA- Receipt from manufacture

ROP-Receipt from outside under any other provision

Issues

IDH-Removal from factory on payment of duty for Home use

IDE-Removal on payment of duty for export under no bond

IWE-Removal without payment of duty for export under bond

IWT-Removal without payment of duty for transfers

IWO-Removal without payment of duty for other purpose

For this case choose RMA as classification

RG23/ RG1 RG23 / RG1 updation date

Select the appropriate radio button to update the RG1 Register. Please select the document entry date radio button

Date to be considered by the system for updation of RG1 Register

Document Entry date

Document posting date

Page 16: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 16 of 25

System date

Registers Register to update Select the RG1 radio button to update the RG1 Register,

By using this Transaction you can update the following Registers

RG23A Part1

RG23C Pat1

RG1

3. Choose enter and ignore any messages.

Update the Receipts to RG1 Register and then update the issue to RG1 Registers. Follow the sequence of transactions.

You can update the RG1 Register by selecting material document header values or Material document line item level details or both together.

The following Classification codes need to be used while updating the Excise Registers:

Register Type Goods issues Goods receipts

RG 23A IIM ROP

IPD

IWD

RG23C IIM ROP

IPD

IWD

RG1 IDH RMA

IDE ROP

IWE

IWT

IWO

4. System will display the ‘Update of Registers RG1 and RG23 (Part1’) screen:

Displays all the line items to meet the selection criteria to update the RG1 Register.

5. Select the line items which needs to be updated to RG1 Register by selecting the check box at the beginning of the each line item

6. Simulate the selection by using the Simulate function or use Shift+F10 to simulate the selection

7. System will display the selection Green or Red Traffic lights. The line items which can be updated will be displayed with Green Traffic Lights and the line items which can not be updated will be displayed with Red Traffic Lights.

Page 17: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 17 of 25

8. After selecting the right documents select the line item and use the Create button to update the RG1 Register or use CTRL+Shit+F11 to make register entry.

Result

Processing over for <number of records selected> records

3.2 RG1 Register Extraction

Use

This step need to be performed in order to create the RG1 details into the respective tables .

Prerequisites

You have to complete the update of RG1 Register before performing this step.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Extract

Transaction Code J2I5

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Extract

2. On the Excise Registers Extraction screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which RG1 Register being generated

21

State Date Starting date of Extraction

Starting date of data to be extracted for RG1 registers

End Date Ending date of Extraction

Ending date of data to be extracted for RG1 registers

Selection Registers

Mass extraction of data to all registers

Select the radio button Select Any Register option

User can generate all the registers together or individual register wise

Select individual Registers

Selection of individual register

Activate the RG1 Check box to extract the RG1 Register

Page 18: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 18 of 25

Display Last Extracted dates

Displays the previously upto what date the register has been extracted for information

3. Choose on execute icon or Choose F8 or Program Execute

4. If the RG1 Register is being generated for the Period First Time, system will execute the report and display the pop-screen with Register name and Green Tick mark, if it is successfully extracted, otherwise it will show the Red Cross.

Result

RG1 data has been extracted

Using this activity, you can also extract the following Excise Registers in addition to RG1.

RG23A Part I

RG23A Part II

RG23C Part I

RG23C Part II

PLA

RG23D

In the Registers select option, if you select All registers, the system will create an extract for all registers. If you only want to create an extract for specific registers, select Select any register and then the registers that you want to extract.

3.3 RG1 Register Print Utility

Use

The objective of this process is to print the RG1 Register or to display on the screen.

Prerequisites

The data must be extracted to the RG1 Register for the period to which RG1 Register need to be printed.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Print Utility program

Page 19: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 19 of 25

Transaction code J2I6

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Print Utility

2. On the Print Excise Registers screen, select the RG1 Radio button to print the RG1 Register.

3. Choose on Execute icon or Choose F8 or Program Execute

4. On the Print RG1 Register screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which RG1 Register is being generated

21 Enter the Excise Group

Start Date Starting date of the period for which currently RG1Register is being generated

For example

01.03.2005

Starting Date

End Date Ending date of the period for which currently RG1Register is being generated

For example:

31.03.2005

Ending Date

In Form Selection Tab , Choose Script Form for print out of Registers

If you choose Excel form, Then you can down load the values in Excel Sheet.

5. Choose Tab Script Tab

6. Choose on Execute icon or Choose F8 or Program Execute

7. System will display the Print parameters maintenance screen assign the out put device name and select the Print Preview option. System will display the output on the screen.

8. See the output on the screen and based on the requirement print the output using Ctrl + P

option or through menu Text Print.

Result

RG1 Register ready to print or you can see on the screen.

Using this activity, you can also view or print the following Excise Registers in addition to RG1

RG23A Part I

RG23A Part II

RG23C Part I

RG23C Part II

PLA

Page 20: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 20 of 25

RG23D

You have to print or see the registers one after another.

3.4 PLA Register Extraction

Use

This step need to be performed in order to extract the data relating to PLA Register to respective tables.

Prerequisites

The following process has been executed, if any transactions took place during the period of PLA register extraction for payment of CENVAT and Sale of goods

TR6 Challan updation

Utilization of CENVAT

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Extract

Transaction Code J2I5

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Extract

2. On the Excise Registers Extraction screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which PLA Register being generated

21

State Date Starting date of Extraction

Starting date of data to be extracted for PLA registers

End Date Ending date of Extraction

Ending date of data to be extracted for PLA registers

Selection Registers

Mass extraction of data to all registers

Select the radio button Select Any Register option

User can generate all the registers together or individual register wise

Select individual

Selection of individual register

Activate the PLA Check box to extract the PLA Register

Page 21: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 21 of 25

Registers

Display Last Extracted dates

Displays the previously up to what date the register has been extracted for information

System will display the last extraction date on the screen

3. Choose on execute icon or Choose F8 or Program Execute

4. If the PLA Register is being extract for the Period First Time, system will execute the report and display the pop-screen with Register name and Green Tick mark, if it is successfully extracted, otherwise it will show the Red Cross.

Result

PLA data has been extracted

3.5 PLA Register Print Utility

Use

The objective of this process is to print the PLA Register or to display on the screen.

Prerequisites

The data must be extracted to the PLA Register for the period to which PLA Register need to be printed.

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Print Utility program

Transaction Code J2I6

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Print Utility

2. On the Print Excise Registers screen, select the PLA Radio button to print the PLA Register.

3. Choose on Execute icon or Choose F8 or Program Execute

4. On the Print PLA Register screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which PLA Register is being generated

10 Enter the Excise Group

Start Date Starting date of the For example Starting Date

Page 22: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 22 of 25

period for which currently PLA Register is being generated

01.03.2005

End Date Ending date of the period for which currently PLA Register is being generated

For example

31.03.2005

Ending Date

5. Choose on Execute icon or Choose F8 or Program Execute

6. System will display the Print parameters maintenance screen assign the out put device name and select the Print Preview option. System will display the output on the screen.

7. See the output on the screen and based on the requirement print the output using Ctrl + P

option or through menu Text Print.

Result

PLA register displayed on screen or printed.

3.6 Register RT- 12

Use

This is activity is used to generate the RT-12, to submit on monthly basis. The report summarizes the CENVAT and PLA information from the other registers.

Prerequisites

The following has been executed:

Utilization of CENVAT

Data Extract to RG23A Part II Register

Data Extract to RG23C Part II Register

Data Extract to PLA Register

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu Country India User Menu Indirect Taxes Registers

Excise Tax Print Utility program

Transaction Code J2I6 or J2IN

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Print Utility

Page 23: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 23 of 25

2. On the Print Excise Registers screen, select the RT-12 Radio button to print the RT-12 Register.

3. Choose on Execute icon or Choose F8 or Program Execute

4. On the RT-12 New Format screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which RT12 Register is being generated

21 Enter the Excise Group

Start Date Starting date of the period for which currently R12Register is being generated

For example

01.04.2007

Starting Date

End Date Ending date of the period for which currently RT12 Register is being generated

For example

31.04.2007

Ending Date

5. From the Details, select one of the radio button

Display headings

Fortnight – Removals & duty payment (this option, executed only on Fortnightly basis in the system)

Month- Excisable Goods manufactured

Month – Goods cleared without payment of Duty

Month – Total duty and interest paid

Based on the selection system will display the corresponding detail.

Here you can Choose Month- Excisable Goods manufactured

6. Choose on Execute icon or Choose F8 or Program Execute

7. System will display the Print parameters maintenance screen assign the out put device name and select the Print Preview option. System will display the output on the screen.

8. See the output on the screen and based on the requirement print the output using Ctrl + P

option or through menu Text Print or Print Preview

Result

RT-12 register displayed on screen or printed.

3.7 ER1 Report

Use

This is activity is used to generate the form E.R.-1 to be filled with excise authorities, by all the assesses (as defined under Central Excise Act) on a monthly basis for production and removal of goods and other relevant particulars and CENVAT credit.

Page 24: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 24 of 25

You can run the report for a plant for a particular month. The system displays and prints the various sections of the form for a Registration Number of a plant for a particular month.

Prerequisites

The following has to be executed:

Utilization of CENVAT

Data Extract to RG23A Part II Register

Data Extract to RG23C Part II Register

Data Extract to PLA Register

Procedure

1. Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP menu No Menu

Transaction code J2IER1

Option 2: SAP NetWeaver Business Client (SAP NWBC) via AIO role

AIO role (Name) SAP_BP_CIN_TAXATIONMANAGER

AIO role menu CIN Excise Transactions Monthly er1 report

2. On the Program J_1IER1 screen, make the following entries:

Field name Description User action and values Comment

Excise Group Excise group for which RT12 Register is being generated

21 Enter the Excise Group

Plant Plant BP01

Report Period Report Period Starting & Ending date of the period for which currently ER1 Register is being generated

Current period shall be given

Last Utilization Period

Last Utilization Period All ready Utilized Period shall be given

3. From the Details, select one of the radio button

Display headings

Details of manufacture, clearance and duty payable)

Details of duty paid on excisable goods

Details of CENVAT credit availed and utilized

Details of other payments made

Self- assessment memorandum

Page 25: Excise Periodic Transaction India

SAP Best Practices J94: Excise Periodic Processing - BPP

© SAP AG Page 25 of 25

Based on the selection system will display the corresponding detail.

You can enter the General Ledger Account Number for the different service taxes. If you enter the Account Number, the system checks the amount against that service tax and prints it on the header of the form

4. Choose on Execute icon or Choose F8 or Program Execute

5. System will display the Print parameters maintenance screen assign the out put device name and select the Print Preview option. System will display the output on the screen.

6. See the output on the screen and based on the requirement print the output using Ctrl + P

option or through menu Text Print or Print Preview

Result

ER1 Report register displayed on screen or printed.