Skip to Content
author's profile photo Former Member
Former Member

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

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

11 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 05: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.


    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 05: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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 01, 2014 at 01: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 01, 2014 at 05: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,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 05:49 AM

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

    Regards

    Priyaranjan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 06: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 04: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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 05: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 06: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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 07: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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.