Skip to Content
avatar image
Former Member

SAP BPC 10.0 Business Rules for Elilmination

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 16 at 03:27 PM

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

    Add comment
    10|10000 characters needed 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

  • Jan 16 at 09:11 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

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

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

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

    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

    Add comment
    10|10000 characters needed characters exceeded