Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excise opening balance coming incorrect after extraction of registers

Former Member
0 Kudos

Hi All

I have searched a lot of threads and forums but couldn't get answer

We have implemented SAP in one of our client where at the time of cutover the excise balances were not uploaded

User extracted the register when the balances were not uploaded.

example

31.03.2015 -   Balance of registers were Zero

04.04.2015 -   Opening balance Zero and closing balance 189218.00

Now we deleted the entries in J_2IACCBAL  and inserted the opening and closing balance as on 31.03.2015

even after saving and executing the table J_2IACCBAL & extracting the register again below were the observations

1) the opening and closing balance of 31.03.2015 got changed

is there any other table where i need to delete the entries apart from J_2IACCBAL ?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Abhishek,

GO through the note - 1673612 , you have all the details available here.

Cheers,
Anushya S

4 REPLIES 4

Former Member
0 Kudos

Hi Abhishek,

GO through the note - 1673612 , you have all the details available here.

Cheers,
Anushya S

0 Kudos

Hi Anushya

this note says

Q. Rg23A Part2 / PLA opening balance and closing balance does not match.

       Please ensure there are no random extrcations for the register.

    Do the following-

   > Delete the entries from J_2IACCBAL table which fall after the date

     of extraction.

   > Delete the entries from J_2IEXTRCT table which fall after the date

     of extraction.

   > Delete the entries from J_2IEXDATE table which fall after the date

     of extraction.

   These tables are dynamically updated everytime you run J2I5.

   Example: You are running J2I5/J2I6 for the period 01.12.2012 to

   31.01.2012 and the opening balance is not matching with the closing

   balance of 31.12.2011. Then delete the entries from above

   given tables from 01.12.2012. There should be no entries from the

   start date of extraction to current date. There should only be

   correct closing balance as on 31.12.2011.

NOTE: Entries in J_2IEXDATE table cannot be deleted via SE16. You will

      have to write a Z program to do the same.

   Then run J2I5 and J2I6 the balances should be correct.

Do you have that Z program code with you , if yes pls do share

Thanks again for prompt and correct reply

Abhishek Sharma

0 Kudos

Hi Abhishek,

Sorry, i donot have a zprogram for it however it will not take much time , you can do the same with the help of your abaper.

Since these are dynamic tables, you donot have to worry as well when doing a table level deletion.

Cheers,
Anushya

0 Kudos

You have to ensure that all the balances were properly uploaded in J_2IACCBAL table directly before going live.

Since you have made a mistake already, now seat with abaper and follow the instruction given in the said sap note.

No body will have the z program readily. You have to develop yourself with the help of abaper.