Skip to Content
0

SAP BPC 10.0 Business Rules for Elilmination

Jan 16 at 03:19 PM

84

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Jan 16 at 03:27 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
avatar image
Former Member Jan 16 at 09:11 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Former Member

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

0
avatar image
Former Member Jan 16 at 03:57 PM
0

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


rules.png (64.5 kB)
elim2.png (122.4 kB)
elim21.png (58.8 kB)
elim22.png (36.2 kB)
report.png (106.9 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

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

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

0
Former Member

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

0
avatar image
Former Member Jan 16 at 09:32 PM
0

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


elim2.png (122.4 kB)
elim21.png (58.8 kB)
report.png (106.9 kB)
Share
10 |10000 characters needed characters left characters exceeded