RG1

[Former Member]

Dear All,

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

Excise Grp

Date- 1st april 2010

Material-

Form-

Pack-

OP_FINISH-100 qty

User Name

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

Regards

Sd Consultant

[Former Member · Accepted solution]

hi

if you want 100 qty in opening balance you should make entry on 31 as closing balance then it will reflect as opening balance on 1 st do this it will work

sandeep

[Former Member · Accepted solution]

Thank uou for your immediate reply.

As per you i need to mainatin 100 qty in CB_FINISH filed with date 31.03.2010,

what should be J1I5 date and J2I5 date.

Regards

SD Consultant

[Former Member · Accepted solution]

what is the ideal solution.on what date i should upload initial stock.

If i go by your solution means in J_2irg1bal in Closing balance filed i maintain 100 qty for 31.03.2010

then update and extract table on 1st april.

so system shows opening balance 100 + qty manufuctur 100 and total = 200.

I want opening balance is 100 and total is 100.

reagrds

sd consultant

[Former Member · Accepted solution]

Issue has Resolved....

Thank You

SD Consultant

[Former Member]

ok