Skip to Content

No Posting of Elimination into Destination group account post running Elimination Business rule

Hi Team,

In our Real Time Consolidation implementation(1610, BW7.5 SP3), when we run Consolidation from Consolidation monitor which ultimately executes Elimination and Adjustment Business rules, the elimination entry into Destination group account for Profit Loss and Balance Sheet account respectively does not happen.

I am attaching the following snapshots:

1. The Elimination Business Rule

2. The Method Based Multiplier

3. Accounts from transaction code RTCGLA

4. Records in Composite Provider after running Currency Translation in RTCCT for Final Category and period 2016012

5. Records in Composite Provider after running Consolidation task .

elimination-rule.png m-ic-method-based-multiplier.png rtcgla-snapshot.png composite-provider-after-currency-translation-and.png composite-provider-data-after-running-consolidatio.png

Are we missing here something.



Regards.

SHUBHAM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 22 at 12:55 PM

    Thanks all for the suggestions.

    Was doing a basic mistake. Somehow the testing data was such that, if at all posting happens to Destination Group Account, then it will be 0.

    I uploaded 2 records, one with Partner entity and balance as 200 and other record with with No Partner entity and balance as -200.

    Now I am getting the Elimination entry in Destination Group Account as -200.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27 at 01:20 PM

    Hi Shubham,

    It's difficult to catch up the issue by just looking at the rule. Please share the SP level, Ownership, Master and model info (write back config.).

    Please check the logs and debug the same elimination rule from debugger. If it doesn't generate any adjustment records, then we need to do additional checks!

    Thanks!

    Regards,

    Harsha

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27 at 05:04 PM

    Hello,

    As Sri stated, BPC business rules are complex and troubleshooting them will involve checking master data, as well as ownership data and the business rules. Furthermore, it does not matter if you are dealing with BPC standard or embedded (RTC). The consolidation engine works the same and processes everything the same.

    If you are working with BPC standard and would like to become more familiar with tools and basic approach to troubleshooting BPC logic I can recommend reviewing 2239549 - BPC NW Script Logic Troubleshooting Survival Guide

    If you are working with BPC embedded then you will have to review the master data configuration, the rules and the ownership data as per BPC consolidation help.

    Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27 at 09:01 PM

    Is it posting to Destination All Account ?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Lucas,

      Yes we are using the Integration rule and we tried running with Level set to 0, but result was same.

      We checked the Note 2472529. We have already maintained ELIM Property account values as 10 digit.

      Also we tried hard coding an account in Destination group Account section of business rule, but it did not work.

      We have tried the multiplier suggestion also where multiplier is separated into multiple lines, but no result.

      Regards,
      SHUBHAM