Updation of Excise registers for stock initially uploaded by 561

[Former Member]

Hi all,

We have uploaded stock of RM by using movement type 561. But now we want to update the excise values of all the initially uploaded stocks in the registars.

I have tried passing JV by J1IH but it only updates part II entry.

How do I do this?

Thanks

Sonal

[Former Member · Accepted solution]

Hi,

For the initial entry of the stock value.

It is SAP stadard practice to load as the closing balances directly in to the respective tables.

Table is J_2IACCBAL

Procedure:

1)Go to SE16

2)Table name as J_2IACCBAL

3)Click on create entry tab

4)Put the reg name e.g Rg23ABED

5)Put the date

6)Put the balances in the both closing and opening balances tab.

7)Save ur entry.

Do the same for remaining reg values.

regards,

sujit

[pankaj_singh9]

Hi,

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)|http://help.sap.com/saphelp_erp60_sp/helpdata/en/1e/f4a1a011d811d4b5af006094b9ec21/content.htm]

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