HOW TO CARRY FORWARD RG1 CLOSING BALANCE TO OPENING BALANCE FOR NEW FISCAL

[Former Member]

Hi Experts

How to carry forward the RG1 closing stock at the year end to opening balance of Rg1 for new year.

Wt are the steps required for closing activity of RG1 and carry forward closing balance of last year to opening balance of new year.

Thanks

[Former Member]

Hi Rohan,

For RG1 and RG23 A Part I and RG23 C Part I

Go to SE16, here enter Table Name - J_2IRG1BAL and Click on "Create" button in initial screen, it will give the maintenance screen. Here mainatin following;

For each of these materials, you have maintained the material form in table J_2IRG1BAL as below. Do not make any entries in fields that are not listed below:

EXGRP - Materialu2019s excise group

DATUM - Date from which RG1 report is required, normally the date of going live

MATNR - Material

FORM - Enter P (Packed) or L (Loose). Do not leave this field blank.

WERKS - Leave this field blank.

OP FN UOM, OP BN UOM, CB FN UOM - Leave these fields blank. All quantities in this table are updated in the base unit of measure of the material

USNAM - User ID of the person filling out the table.

CPUDT - Date of entry

CPUTM - Time of entry

Note: - This is to be done before J1I5, J2I5.

Also refer link;

Update of Registers RG 1 and RG 23 (Part I)

For RG23 A Part II, RG23 C Part II and PLA

Go to SE16, here enter Table Name - J_2IACCBAL and Click on "Create" button in initial screen, it will give the maintenance screen. And maintain following;

Excise Group

Data element for Register names

Date

Plant

Basic duty (OP BAL)

Basic duty (CL BAL)

Basic duty (EXAMT)

Extract Indicator

User name

Entry Date

Entered at

Note: -

1. Enter OP BAL, CL BAL and EXAMT all as same as opening balance. For e.g. opening balance for RG23ABED is 1400 then this value is to be entered in all the 3 fields.

2. You have to enter separate line items for all the accounts;

RG23ABED

RG23ASED

RG23AAED

RG23CBED

RG23CSED

RG23CAED

PLABED

PLASED

PLAAED

PLACESS

RG23AECS

RG23CECS

PLAECS

RG23AAT1

RG23CAT1

PLAAT1

3. Enter Date is one day before of the opening. For e.g. if opening date is 01.04.2008 then enter it in 31.03.2008

Then go for J2I5 - Extract and J2I6 - Print Utility

use following

http://help.sap.com/bp_bblibrary/470/Documentation/J33_BPP_32_CHEM_EN_IN.doc

http://help.sap.com/saphelp_erp60_sp/helpdata/en/18/8e113999724854e10000000a11405a/content.htm

Reefer this link for complete Excise transactions

http://help.sap.com/saphelp_erp60_sp/helpdata/en/09/ebf138cdd78a4be10000000a114084/frameset.htm

Hopefully this will helpfull to resolve your answer.

Thanks & regards,

Pankaj Mahajan