Rg1-opening balance not as per actual

[Former Member]

Dear all,

I am updating Rg1 but in output(j2i6) opening and closing balance not matching with MB5B opening and closing balance,my client is referring mb5b for their reference.

I have check 2_rg1bal table,

My client using this report from 1st of april 2009 and they have implemented sap 3 years back and that time 2_rg1bal table has updated for all material.but for some material this table has updated till 31.05.09 ,so wat to do for making exact opening balance as per MB5B.

Initaly i thought that i can delete all rows of J-2irg1bal from 31st march 09 to 31st may 09 and then upload closing balance for 31st march 09 for all material and all plant .and then rg1 will update (j1i5) and ,extact on 1st of april 09 so that closing balance of 31st march will come as a opening balance of 1st april and then i will again update rg1(j1i5),extract(j2i5 ) and then take a print(j2i6)

but i find there is data in J-1irg1 table also .for some material.

kindly advice on the above issue.

hemant

[Former Member]

hi

Note 951955 - CIN: General clarifications for RG1 goods

maintain the following

entries in table J_2IRG1BAL for all RG1 material.

EXGRP: Excise group of the material

DATUM: Date from which you want RG1 report i.e. 01.01.2004

MATNR: Material

FORM: P for packed, L for loose. note that the same material cannot be

maintained as both packed and loose.

WERKS: Leave it blank

Maintain all relevant opening balance fields. These fields start with

OP

Enter the username in USNAM and CPUDT (current date).

When ever a new material is created this has to be done. For more details

refer the Note No.373001.

If you do not want to maintain the material form in table J_2IRG1BAL, and

want to use your own logic for updating material form in table J_1IRG1

during transaction J1I5 then apply Note No.412864. This note provides

for an user exit J_1I7_userexit_J1I5_matform. In this user exit you can

write your own logic for updating the material form for different

materials irrespective of what the system picks up. Once again please note

that the same material cannot be updated as 'P' for one entry and 'L' for

another entry in table J_1IRG1.

Also check the Note No. 502792 based on your Support pack level. And

always ensure the Latest Support Pack is applied in your

System.

Please check whether you have uploaded the correct Balance of the

Materials in the table J_2IRG1BAL and compare with the table

J_1IRG1.

Please note that the table J_2IRG1BAL alone will have the Material

field. The table J_2IACCBAL has to updated for the Excise Group,

Plant and no Material field will be available.

Hence, identify the Material and compare with the tables

J_1IRG1, cumulative stock.

regards