1 Reply Latest reply: Aug 10, 2011 8:25 AM by Shailesh Gangurde RSS

Opening and Closing balances in RG1 register

Satyendra Soni
Currently Being Moderated



We are facing one issue in RG1 register. When we update and extract the RG1 register from system, its showing Sales Qty and Excise duties properly. But opening and closing balances are not coming, its showing zero there. I checked J_2IRG1BAL table and found that it is also not getting updated. Material comes into stock with 561(initial stock) and 101(from production) movement types but opening/closing balances not coming in either case. Both movement types are activated for RG1 also.

Seeking your help in this regard.....



Satyendra Soni

  • Re: Opening and Closing balances in RG1 register
    Shailesh Gangurde
    Currently Being Moderated

    Hi Satyendra ,

    For initial  upload in RG1 there are 2 tables you need to manually update. J_2IRG1BAL  from CIN or SD side. And Accounts to be updated for Balance in J_2IACCBAL.

    There are 2 ways for updating balance tables

    On last day of month enter Balance in Closing balance field.

    OR enter opening balance on 1 st day of month.

    Also check Material form P ,can be maintained in user exit for permanent effect.

    After  updating balances ,

    perform any one transaction on system.

    and then  Extract  the Rg1 table .

    Ask FI consultant to put in  FI JV after balance upload in ACCBAL table.


    If you have not done table entries before performing transaction and extraction of RG1  then balances will not appear .

    Check with your senior there and use table edit in such case (I hope you are not on production server  at the moment) .Then again perform Extraction and check once.

    SD FI and ABAP to be present and take decision accordingly.