I have problem in RG1 updation. My go live was happen on 1st april. So we have taken closing stock from legacy system as on 31.03.2010 and post initial stock upload in MB1C on 1st of April.
Say for material XYZ closing stock was 100 qty
Now I updated table J-2IRG1BAL WITH FOLLWOING FILED
Date- 1st april 2010
Excise Document Entry Date-today's date
and i save the document.
Then I did J1I5 - update table For 01.04.2010 with classification ROP/RMA
Then i did J2I5-Extract table for 01.04.2010
Then i did J2i6 -print
But when i have seen print output opening balance column shows zero and qty manufacture column shows 100 qty and total and closing balance shows 100 qty.
my requirement is Opening balance column shows 100 qty because 31st march closing balance is 1st april opening balance for me
Please provide me the solution as it is immediate requirement