RG-1 REGISTER

[Former Member]

Hi All,

I am working on ECC 6.0.. I am facing a problem in RG 1 Register. Even i am not sure whether that is a problem coz i am new to CIN.

The Problem is When i am taking the Print Preview in T-Code J2I6, I can see only Opening stock of material (Quantity), but value is not appearing in this Report.

" I have Raised a same Question in This Group. I have got the answer that In RG1 register Only Quantity gets updated not the value" Is it True?.. because there is a column for value also... if it is so y they will have value column?

Can any one Guide me Please. This is very urgent...

Answer will be Rewarded

Regards

MBS

[Former Member]

Hi In RG1 You can get values also. I have managed to get correct values in R/3 4.7 at one of my client. I can send you detailed check-list for that.

You have to be careful in uploading initial stock, material-chapter id combinations and Movement types.

Please give me more details about u r problem, I will try to help. You can send me email also.

Regards,

Darshan.

[Former Member]

Hi Darshan,

I am using ECC 6.0, we have both export sales and domestic sales. We have defined our own condition type for price.PR00 is not there in our pricing procedure. We have different Pricing Procedure like for Export Sales, Scrap Sales, Asset Sales, Service Orders etc.

Now the problem i am facing is when i got J1I5 t-code to Update,After that J2I5 to Extract, J2I6 to Print Here If i see the preview i can see only quanity day wise but value is not updating. This is same in case of Export data.

Hey can u tell me when we go to J1I5 What all steps we need to follow ....... I am getting Red Indicator in Export data...Y this problem comes. Please send me the step by step process of updating.

My id is sagar.nayak59@rediffmail.com

Thanks and regards

MBS

[Former Member]

<u><b>Important steps before going live – ( RG1 Updation) </b></u>

<b>Before going live – Update the table for RG1 Register - J_2IRG1BAL</b>

Day-to-Day Activities

The system does not automatically generate entries for goods receipts from production orders. You have to generate these yourself (see below).

Nor does it generate entries for goods issues, except for goods issues entered using the Goods Movements transaction if you have made the Customizing settings described above.

Periodic Processing

Generate the missing entries once a day using the Register Update program.

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

Use

You use this report to update the information in the following registers:

• RG 1

• RG 23A, Part I

• RG 23C, Part I

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

You cannot print or display these registers using this report. It is solely for the purpose of updating the registers. Instead, to download the registers, use the Download Register Data report

Prerequisites

You have specified in the material master data which materials are to be entered in register RG 1.

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:

Field Field entries

EXGRP Material’s 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 Leave these fields blank.

All quantities in this table are updated in the base unit of measure of the material.

OP BN UOM

CB FN UOM

USNAM User ID of the person filling out the table.

CPUDT Date of entry

CPUTM Time of entry

Features

To access the report, from the SAP Easy Access screen, choose Indirect Taxes &#61614; Registers &#61614; Excise Tax &#61614; Update RG 23A/C Issues and RG 1.

Selection

On the selection screen, you specify:

• Which documents you want to cover:

o Enter general organizational details in the Company details group box.

o Enter details about the documents that you want to include in the register, in the Document header and Document details group boxes.

• Which register you want to update, in the Registers group box

• Whether you want to run the program in batch mode

You can also check what date the data was last extracted.

Output

The system displays a list of material documents that have not yet been entered in the register.

1. Select the documents that you want to add to the register.

2. To check if there is enough stock in the specific excise group for the register for issues or receipts, select the line items and choose Simulate.

We recommend that you use this option before proceeding; it will show the line items that can be updated in the register.

Issues and receipts are handled separately based on the following register and classification code combinations:

Register Type Goods issues Goods receipts

RG 23A IIM ROP

RG 23A IPD ROP

RG 23A IWD ROP

RG 23C IIM ROP

RG 23C IPD ROP

RG 23C IWD ROP

RG 1 IDH RMA

RG 1 IDE ROP

RG 1 IWE ROP

RG 1 IWT ROP

RG 1 IWO ROP

o Lines that can be updated in the register will be shown with a green traffic light, while those which are not eligible (for example, if there is not enough stock on hand) will be marked with a red traffic light.

o You can reselect the required line items and repeat the Simulate process.

3. Select the line items you want and choose Register entry.

The system updates the Part I or RG 1 tables with the material documents.

For RG 1 issues to sales, wherever there is an excise invoice it is picked up and used for RG 1 updating.

The same option can be used for creating entries in RG 23A or RG 23C Part I registers. While creating entries in the register, system will pick up only those material documents for which Part I posting has not been done yet.

For further more details go through the OSS reply on RG1 Register updation

Regards,

Rajesh Banka

Reward points if helpful.