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: 

Closing and Opening balance mismatching in Production system for RG23c Par II register

Former Member
0 Kudos

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?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

22 REPLIES 22

former_member192897
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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,

Former Member
0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

Thanks Ashok, we did it in same way and our issue has been resolved.

Regards

Priyaranjan

Former Member
0 Kudos

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

0 Kudos

Might you have not extracted the through J2I5 , extract first and then recheck.

0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

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

0 Kudos

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.

Former Member
0 Kudos

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

0 Kudos

Refer SAP Note 1673612 and see J2I5 section.


Former Member
0 Kudos

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

0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

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?

0 Kudos

Ensure you have selected the Proper Register in J2I5 and click on last extraction date and see the result.

Former Member
0 Kudos

I am following in same way but it is still showing 31.10.2013, though i have extracted upto 31.12.2013. Why so?

0 Kudos

Check table J_2IEXDATE. Earlier suggested note give you details of Extraction dates and their problems.

Former Member
0 Kudos

I am getting this problem in DEV,Qualiyu and PRd but there is no problem in Sandbox.

0 Kudos

If you have problem with the extraction dates then raise a message to SAP.