06-18-2015 11:52 AM
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 ?
06-24-2015 6:08 AM
Hi Abhishek,
GO through the note - 1673612 , you have all the details available here.
Cheers,
Anushya S
06-24-2015 6:08 AM
Hi Abhishek,
GO through the note - 1673612 , you have all the details available here.
Cheers,
Anushya S
06-24-2015 6:41 AM
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
06-24-2015 9:29 AM
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
06-26-2015 11:56 AM
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.