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

How to see COA parent account changes history?

Dear All

We have big problem

Yesterday, the COA level and parent account for all active account was

changed suddenly from level 5 to be level 2

Please kindly help us with answer these questions:

1. Do you have any idea, what is cause of this problem ?

is this SBO bug ?

2. How could we see the history for level and parent account changes?

because we CAN see history for COA other information, but we CAN NOT

see history for level and parent account changes

3. When we tried to update the correct level and parent account through

DTW :

a. We can not find column level in DTW template, only parent account

b. When we dtw parent account, there is error : oact.fathernum field cannot be updated odbc 1029

is it possible to update the parent account and level through DTW ? because we should fix 600 accounts, and it is impossible to fix one by one

really appreciate your help

Best Regards

JeiMing

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Apr 14, 2010 at 08:19 AM

    you can update the levels by update query . But take back up ur DB before this activity.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 14, 2010 at 08:51 AM

    Hi

    SELECT T0.[UpdateDate] FROM OACT T0
    

    From above query u will get on which date update is made for Account.

    If u hv backup then try to take data from OACT table, extract same data in DTW COA template and then check it...

    Thanks

    Kevin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2010 at 03:28 AM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2013 at 09:23 PM

    Dears,

    In my company, this problem has happened twice and we can not update the levels by DTW

    We have SAPBO 8.81 PL08.

    Can anybody tell why it is happened and why SAP does not solved this bug?

    Thank you.

    Kayvan

    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.