RG1 Balance Updation

[Former Member]

Dear Expert,

I update opening balance in table J_2IRG1BAL for RG1 Register (For Particular one material).

After that i create one goods receipt against one production order and For that i update RG1 Register with classification RMA.

it is updating properly and extract also.

but the problem is, say for example:

Material code Opening Balance

1200010 100

this only i update in J_2IRG1BAL table for that material.

After that goods receipt against production order, say for example 50 Quantity.

For that i update RG1 Register with classification RMA.

Now in that table, should be 150 Quantity right. but i showing 50 Quantity only. that opening Quantity is gone.

can anyone tell me what is the problem? why that opening Quantity is replace to 50 quantity?

Thanks for Advance

[Former Member · Accepted solution]

HI

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

Note 951955 - CIN General clarifications for RG1 goods

Note 1237504 - Incorrect opening balance in RG1 register extraction - J2I6

regards

Prashanth

Edited by: Prashanth@SD on Apr 16, 2011 9:34 AM