Consolidation Business Rules

[Former Member]

Hi,

We set up the elimination & adjustment business rules for elimination in BPC 10 NW as following

Source Acc - Z100

Dest Acc - Z100   

Destination Group Account - Z100_DIF

The system posts the elimination difference to the correct account. However, it does not perform the consolidation for other accounts which are not part of the rule. Is this correct behavior.? the ownership hierarchy is defined with all at 100% with correct methods (100,101)

like a simple requirement is if we input value in CASH for 5 companies as 100 each and run the Consolidation package it should post 500 at group level in different data source (since it need not be eliminated). It should consolidate using purchase method picking up %, Method etc. from ownership hierarchy. Do we need to write separate rule to achieve this or will the system know that anything NOT to be eliminated will be consolidated.

All examples in BPC documentation show the elimination which is happening correctly but it does not consolidate the other accounts which are not defined in elimination (Z100).

Also, we are able to eliminate Investment/Equity but consolidation of other accounts which should add up & post at group level is not happening....

Thanks & Regards,

Ab

[Former Member]

Kindly Don't forgot to close the thread if you resolved your issue which will help others to look into the solution.

Regards,

Aravind.

[Former Member]

Hi Abhi,

          Can you please provide the screen shots of the reports after & before consolidation(Include Accounts for which elim is not posting) & also your account dimension screen which will help to resolve the isssue.

[Former Member]

Elimination is happening correctly at group level as I mentioned. 2 values posted in accounts are reversing at group level as expected.

My question is around the rest of the accounts in trial balance..how will they consolidate at group level. Like we added profit (INC) and Cash (AST) for 5 companies in LC at company level, then performed legal Consol. The result shud show total profit & cash at group level..but it does not post anything.

Are we missing anything here..

[Former Member]

As you said above you had setup the configuration of business rule that means in the account dimension under Elim_Code property you had mentioned plug account for the accounts for which consolidation should be done.

For example in your case for accounts Z100 you had mentioned a plug account "Z100_Diff" similarly you have to maintain plug account in the "Elim_Code" property for all the accounts for which the legal consolidation must done.

Hope this will help you Abhi.

Regards

Aravind

[Former Member]

Means all the balance sheet accounts and PL accounts shud be clubbed using elim_code property and then write business rule to say

source acc -ZBS

dest - ZBS

destin group diff- Minority intrst etc

and similarly for PL accounts..

and this clubbing should exclude the already clubbed elim accounts?

all examples in BPC documents just show elimination only and not consolidation of other left accounts.....does  the system not auto assume that anything that is not eliminated is automatically consilidated based on ownership.

Thanks

Abhi

[Former Member]

Yes, Up-to my extent you have to mention all the accounts that need to be consolidated in the ELIM_CODE property the system will not assume so try doing this .

Regards,

Aravind