on 09-24-2008 6:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.