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

One side reclassification for P&L calculation

Hi experts.

We have this one side reclassification method with posting level 00, during tests we have noticed that when the user executes the task "accidentally" amounts for P&L are duplicated.

The task doesn't have a document class assigned, thus reversing the previous movements is not possible, resulting in duplication of the information.

Is there any way to achieve an execution restriction of the task so that it only allows the end user to run it when changes have been made. Skiping/ignoring any second P&L calculation when not necessary (changes have not been made), would also work.

Any ideas to achieve this will be welcome.

Thanks.

Edited by: Ramon Rojas on Dec 17, 2008 3:44 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 17, 2008 at 04:50 AM

    Hi Ramon,

    I already have answered the quesion in your another thread.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ramon,

      Actually, more details were asked from you. Because, otherwise, without info, it's more guessing procedure.

      I appreciate very much Lucio's help. However, do not see here the answer to your question abt P&L calculation:

      if you have one side reclasification you have only trigger and source, in the trigger you have all items from balance sheet and source the clearing item for balance, you should include the clearing item in the range of trigger,

      It's a description of reclass which rounds your B/S in case of imbalance.

      May be it is what you need? Who knows? Only you.

      Just for future reference, here is a description of the typical situation in the projects:

      The incoming data: B/S & P&L. There is a need to make sure that NI in P&L and RE in B/S are the same (I guess, it's what you needed).

      I usually do it in 2 steps:

      1. Clear (zero) clearing items in B/S & P&L

      2. The sum of all P&L items (certainly, not including clearing one) I place into P&L clearing item (source) and B/S clearing item (target). And those source and target we saw in the description of your question, didn't we?

      If you have only 2nd reclass, every its execution will add amounts to clearing items, breaking the balance in B/S (isn't it what was your problem?). That's why I recommended to implement the class #1.

      Lucio's reclass may work in a proper direction only if you have the balanced B/S from the beginning. That is not always (at least for me) the case. It simply subtructs the amount of disbalance from the clearing item in B/S. This, in general, has nothing to do with P&L NI calculation.

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.