01-01-2014 5:59 AM
Dear All,
We have a serious issues in PE1 system. Actually we went Partial Go-
live(only Procurement Process) on 1st September 2013. Then we upload
all
closing balances for RG23C part II directly in J_2IACCBAL in PE1 System
on 30.08.2013.
Then We made a 1st transaction on 18.09.2013 and then extracted from
01.09.2013 to 18.09.2013 and found correct opening and closing balance.
Then Day by Day the transactions happened and now when we extracted
each
month wise and take print each month wise we found Closing balance of
September is not matching with Opening balance of October.
I checked all data at J_1ipart2 and table is updated correctly.
For this issues i found a SAP Note- 1770674 and here my concerned is we
can not test the effect of this note in development or quality system
as
we made real time transaction (no manual entry in Table). So if we
implement this note directly in PE1 then will it be affect our current
data?. If Yes then what is the Solution for this? If No then shall i
get
correct Opening and Closing balance for Previous month?
01-02-2014 5:28 AM
Hi,
I am wondering When i checked J_2IACCBAL table Closing balance that we manually entered in PE1 is Showing all 0 Values. What is the reason and how should take action? Because its all are in PE1 system. Pls check the attached screen shot.
01-01-2014 1:28 PM
If you have refreshed the quality server with the production data then you can implement the sap note in Dev server and move the changes to Quality and test over there.
Further, i donot see any harm with the said sap note implementation. You can implement it with the help of an abaper and ofcourse you can undo it if found any deviation. Anyways check the side effects of the SAP note.
01-01-2014 5:30 PM
Hi,
As you have a SAP note it is clear that its a program error. So before going forward you can check the correct instructions in the note to understand what exactly are the changes. You can also take the help of your abap person to analyze the same. Also as Ashok mentioned above the best way is to do a client copy of your PE1 data to replicate the same case in your Quality client and proceed with the SAP note implementation in DEV and transport it to test the changes.
Thanks n Regards,
01-02-2014 5:28 AM
Hi,
I am wondering When i checked J_2IACCBAL table Closing balance that we manually entered in PE1 is Showing all 0 Values. What is the reason and how should take action? Because its all are in PE1 system. Pls check the attached screen shot.
01-02-2014 1:02 PM
Have you implemented the SAP Note?
Regarding the balances, i seems that some one would have executed the J2I5 extraction with the incorrect dates. No problem, you can again update the balances as it was before in J_2IACCBAL manually in debug mode or using SE16N and your problem should be resolved.
01-03-2014 5:49 AM
Thanks Ashok, we did it in same way and our issue has been resolved.
Regards
Priyaranjan
01-03-2014 6:03 AM
Dear Ashok,
Yesterday i was getting correct Opening and closing balance, but today once i re extract it the again my opening and closing balance is not matching.
What is the reason behind it.
Regards
Priyaranjan
01-03-2014 9:39 AM
Might you have not extracted the through J2I5 , extract first and then recheck.
01-03-2014 10:31 AM
The reason could be some one extracted the J2I5 report with the incorrect start dates i believe. Anyways your problem is resolved right. In case if you come across same problem then do update the Closing balance in the J_2IACCBAL table and check.
For the same reason, we had put a custom check in the Start date in J2I5 program.
01-03-2014 12:46 PM
Yes correct i agree with Ashok, first check which date did you extracted J2I5 and later check the opening and closing balance based on table J_2IACCBAL.
01-04-2014 4:24 AM
Dear Ashok,
Could you please elaborate the process of custom check in the Start date in J2I5 program? So that i will try to replicate same to my customer to avoid the randomly extracted through J2I5
Regards
Priyaranjan
01-04-2014 4:47 AM
Put a check in J2I5 transaction such that the Start date should not be less than 01.09.2013 (in your case) You may go for Explicit enhancement in J2I5 as there are no User exits or Badi's available for J2I5.
Replicate the same scenarios in Dev server and and check for the results and proceed further.
01-04-2014 5:05 AM
Suppose i extracted from 01.09.2013 to 30.10.2013 and again today i want to re extract from 01.09.2013 to 31.12.2013.
So does it in consistence in J_2IACCBAL table?
I want to know what is the standard extraction process for J2I5? i
Regards
Priyaranjan
01-04-2014 5:20 AM
01-04-2014 5:28 AM
Dear Ashok,
That i understand, my question is if user extracted 01.09.2013 to 31.12.2013 today and again
on January if he re extract 01.10.2013 to 31.01.2014 is it create a problem in register balance?
Regards
Priyaranjan
01-04-2014 5:43 AM
This kind of extraction should not be done as it updates the tables dynamically. There is no control of J2I5 extraction over the incorrect dates.
01-04-2014 6:17 AM
In addition replicate the scenario in Dev server or Qas server where Sufficient data is there. It is a bit difficult task to find out the cause for the incorrect extraction taking place in the transaction J2I5 in a scenario where a transaction brings the register balance to zero.
01-04-2014 6:59 AM
Then how i will get to know on which last date i have extracted? As we have a option on last extracted date on J2I5 but in my case is not updating correctly.
As i have already extracted on 31.12.2013 but it is showing last extracted on 30.10.2013. What could be the reason?
01-04-2014 7:09 AM
Ensure you have selected the Proper Register in J2I5 and click on last extraction date and see the result.
01-04-2014 7:14 AM
I am following in same way but it is still showing 31.10.2013, though i have extracted upto 31.12.2013. Why so?
01-04-2014 7:18 AM
Check table J_2IEXDATE. Earlier suggested note give you details of Extraction dates and their problems.
01-04-2014 7:16 AM
I am getting this problem in DEV,Qualiyu and PRd but there is no problem in Sandbox.
01-06-2014 3:43 AM
If you have problem with the extraction dates then raise a message to SAP.