SAP BPC 10.0 Business Rules for Elilmination

[daniel_cepok2]

Dear Experts,

I have some problems with my Elimination rules. We are Usind BPC 10.0.

We have some Items which are splittet for Intercompanies and Third parties.

For example

Item 10300100

IC: Third Party

Value: 1000

Item 10300100

IC: PG100

Value: 2000

When I start the Elimination in consolidation Monitor the rule eliminated all values in this companie also those which are posted on third parties but in my understanding it should eliminated on the AuditID ELIM 1 just the value of 2000 and leave the value 1000 for third party. But after Elimination of the rule ELIM1 I have 0 on this account.

Do you have an idea how can I run the rule just for IC partners and to leave alle values on this account for third parties.

Thanks for help

Daniel

[daniel_cepok2]

ok hope to translate the screens well.

Once again the problem is that we have one Account on which we post Intercompany values as well as third party values.

Dimension COMPANY

Dimension INTERCO

Here we have P99999 which is out third party INTERCO

and PG001 .... this are our InterCo Entities ID for the Entities

Now the rules ones agian which translation

ID: ELIM2

Description: PL Product sales (onesite)

Destination Audit: ELIM_UMSATZ

ID: ELIM2

Source Account: ELIM2 - this is our property/group for some Sales Accounts (30120100 - 30120900)

Source Flow: empty

Reverse Sign: empty

Destination All Account: Line 1: 30510990

Line 2: ELIM2

Destination Group Account: empty

Destination Minotirty: empty

Destination Equity Account: empty

Destination Flow: empty

Multiplier: RULE11

Force Closing: empty

Swap Entity - Interco: empty

Force Interco Member: empty

Periodic Calc: empty

Report after Consolidation

ACCOUNT: 30120100 - Sales abroad machine (this is a IC Account, on this account we put values on IC Companies and also values P99999 Third Parties)

AUDITID: INPUT

Value: 850.549.342,85

AUDITID: ELIM_UMSATZ

Value: -850.549.342,85

AUDITID: TOTAL

Value: 0,00

BPC should eliminate on Account 30120100 and AUDITID: ELIM_UMSATZ just values with Partnercompanies PXXXX from INTERCO Dimension. Not values with INTERCO P9999. AT AUDITID: TOTAL there should be then just value for P99999 Third Party bun no zero.

Hope it helps now and you can help me with our problem.

Thanks

[former_member399404]

Hi Daniel,

Please post the Ownership model configuration & Ownership associated with this Entity. It will help to understand the issue.

Check if the Third Party "P99999" is correctly defined as Non Inter Company Member in Ownership. Do check if the data collection for IC and Non IC is correctly captured.

EX:

E1 I_E1 AC FXX 2000

E1 I_EN AC FXX 1000

E1 refers to the entity and I_EN refers to the Third party/Non Inter company Member.

[daniel_cepok2]

Hi

this is our Ownership model

As you can see we have P99999 as Non Inter Company Member

We have some data on the same account as you wrote for Intercompany entities and also for Third Party P99999

Thie dimension properties I posted below as a answer.

Hope you have an idea how to fix our problem.

Thanks

Daniel

[former_member399404]

Hi Daniel,

If the data is aligned, then couldn't see an issue with the data provided so far. Please share the Method based multiplier and the data set that's used in this scenario.

Regards,

Harsha

[daniel_cepok2]

Hello

sorry hope with this screens it helps to understand my problem:

We use RULE: ELIM2

Details of Rule ELIM2

Detail ELIM2

After running the consolidation in consolidation monitor we get the result:

As you can see we have the value for the company on AUDITID: INPUT on ITEM 30120100 of 850.549.342,85

On the AUDITID: ELIM_UMSATZ value -850.549.342,85

On TOTAL is zero but on this ITEM we have the value for Intercompanies of 850.000.000 and on third parties on 549.342,85. So should be eliminated the value of 850.000.000,00 and BPC should leave there the value of 549.342,85

In TOTAL it should also be the value of 549.342,85.

How can I say BPC to eliminate just values which are posted on the IC and not on Third parties P99999

Hope it helps to understand my problem.

Thanks

[former_member186338]

If you decided to show non-english screenshots, I will answer in Russian!

А где детальная структура измерений: ENTITY, INERCO?

Для каждой картинки с неанглийским текстом требуется перевод каждой строки!

[daniel_cepok2]

Sorry we just have the system in German and that’s why I tried to explain it in English.

I will try to change to English with my user but I think it is in our company not so easy sorry! If I get the system in English I will send you some more screenshots

[former_member186338]

Sorry, but without very detailed setup with all screenshots it's not possible to discuss. Too many places to make a mistake!

[daniel_cepok2]

Hello

sorry hope with this screens it helps to understand my problem:

We use RULE: ELIM2

Details of Rule ELIM2

Detail ELIM2

After running the consolidation in consolidation monitor we get the result:

As you can see we have the value for the company on AUDITID: INPUT on ITEM 30120100 of 850.549.342,85

On the AUDITID: ELIM_UMSATZ value -850.549.342,85

On TOTAL is zero but on this ITEM we have the value for Intercompanies of 850.000.000 and on third parties on 549.342,85. So should be eliminated the value of 850.000.000,00 and BPC should leave there the value of 549.342,85

In TOTAL it should also be the value of 549.342,85.

How can I say BPC to eliminate just values which are posted on the IC and not on Third parties P99999

Hope it helps to understand my problem.

Thanks