IC elimination when group structure changes

[#1]

We have a cons unit (new_sub) in our system that has existed since 2024. In 012.2024 another cons unit (parent) posted a liability against new_sub. However this new_sub was not part of the group in 012.2024, hence no eliminations were performed by the system, which is what we expected.

In 012.2025 new_sub was added to the scope, so now we expect the system to perform the intercompany elimination of receivables and payables.

The liability was carried forward in the balance sheet of parent and in 012.2025 another amount was added. For this particular fs item we use subitem 1/999 for changes and 1/900 for the opening balance. This is what the reported data looks like in our system.

The system is set up to be used for monthly consolidations from 2026 onwards, however for 2024 and 2025 we have only loaded year end (period 012) data to have full year comparison numbers (and to test the system).

We use reconciliations in the consolidation monitor for the intercompany elimination. They are set up as periodic

The adjustments are posted to this document type and we are using version Y10 for actuals.

The selection used by the reconciliation method as the trigger includes the document type which holds the data, the fs item via the elimination selection and excludes subitem 900.

The result is that only the movement on the fs item in period 012.2025 is eliminated but not the opening balance amount.

What changes do we need to make in our customizing to get the correct elimination including the opening balance? We had expected that the task 2060 (preparation for cons group changes) in the consolidation monitor would adjust the data, so that the intercompany elimination would work as we expect. However, we did run 2060 before the intercompany elimination task without success.

[GregoireDesombre · Accepted solution]

Hi Arnold,

The C/I activity field is relevant only for postings on posting level 30, and I assume that your IC elimination rules post on posting level 20, hence this setting is not relevant.

If you want to include in the trigger the opening balance, you must indeed include the subitem "opening" in the selection (or even all subitems), and not select "periodic reclassification". With this the year-to-date amount is selected. You must also include in the trigger selection the document type that the rule uses to post, otherwise amounts are duplicated.

I suggest you have a look to the delivered content rule (method S2040), and maybe also evaluate the new posting rules if this is available in your system (https://community.sap.com/t5/blogs/blogworkflowpage/blog-id/erp-blog-sap/article-id/61053).

Hope this helps.

Grégoire

[ArnoldWarhonowicz · Accepted solution]

Hi Grégoire, thanks, I was missing the inclusion of the elimination document type in my selection. I have now added it and it works. Thanks, Arnold

[MartinJul]

Hi Arnold,

Your issue, I belive, is that your selection exclude the Sub Item you are expected to eliminate. But even if you add this, the amount is posted in period 000 and not considered when you run a periodic reclassification. 

You can create a new sequence as a copy of 010 in your reclassification. Have a selection as trigger that includes SI 900 (copy of the one you have and then change sub item). Have it as YTD eliminations and then the flag for First Consolidation. That should pick-up the opening balance.

Br

Martin Jul

[ArnoldWarhonowicz]

Hi Martin, thank you for the suggestion. Do you mean the C/I Activity field in the reclassification rule? I set this to 01 for the new sequence number. However, when running the elimination I get an error message saying that this setting is only applicable for posting level 30 and the intercompany elimination is on posting level 20. BR, Arnold

[ArnoldWarhonowicz]

Hi Martin, do you mean the C/I activity field that I should flag it for first consolidation? I tried that but it creates an error on running the elimination as this option is only meant for posting level 30 reclassifications. BR, Arnold