RG1 register-opening quantity is mismatching with actual quantity

[Former Member]

Dear Experts,

My client has implemented SAP in 2009 and never used excise registers for long time. 2012 mid started giving training to users and finally they fixed a cutover date on Jan 2013,

upload Chapter material combination with material status as RG1

Uploaded opening quantity in  J_1irg1bal table as on 01.01.2013

started update,extract and print

but we have encountered some red traff issue is due to the cumulative receipts are not tallying with cumulative issue.we have rectified the issue and  took 2 months time. now the client is telling the actual opening quantity and system opening quantity are not same

so how do i justify whether the quantity is showing in the system is corect or not or what can i do to solve this issue please through some light on it?

With regards,

Pratheep

[prasanna_kumar4]

Hi

My suggestion is you better to go with July month ( 01.07.2013) opening balance and try to update in RG1 Balance( J_2IRG1BAL) because As per excise rule i think they already submitted to excise Department (June month)

So try to upload those opening balance and check every day opening and close balance.

Otherwise compare the Data with MB5B ( T-code) then you will come to know the exact Quantity as on date with corresponding Movement types.

[Former Member]

Thanks mahesh.

Your answer is absolutely corect

But the system has already "N" number enteries in J_1irg1bal table (included initial entry and every update -entry)

So  closing balance is depending upon the earlier quantity

In this situation if i upload opening quantity in July month ,what happens to the january month opening stock

please reply

Thanks in advance

Regards,

Pratheep

[prasanna_kumar4]

Hi

Please Discuss with client because it is already submitted to excise Department and also early you mentioned that last few years they didn't use RG1 in standard SAP.

My better suggestion is follow the July month opening balance and update the Table in J_2IRG1BAL and J_1IRGSUM.

In future you won't get any issues also.

Otherwise you need to do workaround like check Each and Every material day to day opening balance, Manufactured Qty, dispatched, Return Qty , closing balance through MB5B  (T-code)

[Former Member]

If initial upload quantity was correct and records are submitted to excise, further corrections in opening qty is not recommended. For difference in stock,you need to tally each entry, sometimes some of the transactions are not posted correctly ending up in quantity and value mismatch.

[Former Member]

Thanks experts,

Still the client is submitting the excise report to govt manually. but after started doing the excise register in production server from january 2013 to june the opening quantity showing 17050

If i tried to upload in july month as fresh what will happens to the 17050 quantity

please help me to resove this

Regards,

Pratheep

[former_member192897]

Have a look at the below notes. It may be helpful to you.

Note 1673612 - Frequently asked questions for Registers

[Former Member]

Hi Pratheep,

Do read through the note -1673612 and follow the steps as suggested and maintain the

correct closing balances , re-extract and check.

Also, opening balances will be fetched directly from the GL, incase you have direct FI postings the sme will

not be reflected in the report.

Regards,

Anushya