One side reclassification for P&L calculation

[Former Member]

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

[Former Member]

Hi Ramon,

I already have answered the quesion in your another thread.

[Former Member]

Thanks Eugene, but the solution you gave is not working. Would you give more details about it, please.

Thanks

Edited by: Ramon Rojas on Dec 17, 2008 11:35 PM

[Former Member]

Look into Lucio's solution.

Edited by: Ramon Rojas on Dec 18, 2008 1:16 AM

[Former Member]

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.