excise periodic transaction india
DESCRIPTION
Excise sapTRANSCRIPT
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
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.
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.
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
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)
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
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
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
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
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
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
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
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.
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
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
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.
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
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
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
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
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
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
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.
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
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.