Elim&Adj Rules multiply data at each consolidation

[Former Member]

Hi Experts,

I face issue using Elimination Rules in a Consolidation Model.

In some cases, (most of), datas are multiply at each consolidation ; it seems that the problem occurs when the account destination of the rule is different than the source account.

Détails below :

Before Conso :

After 1st Conso : Résults are correct. :

After 2nd Conso : Data on elimination audittrail are multiply, and so on at each consolidation :

Anybody has met that kind of issue ?

Tks for your help.

Best regards,

Olivia.

[Former Member · Accepted solution]

Hi Olivia,

have you tried to define the destination accounts by ID in the rule and if so, does that make any difference?

also, what does your multiplier M_IC look like?

BR,

Arnold

[Former Member · Accepted solution]

Hi Arnold,

 have you tried to define the destination accounts by ID in the rule and if so, does that make any difference?

Yes. No difference. Data are also doubled at each run of Consolidation.

Also note, that Amount are not doubled when destination account remains the same as source account.

 also, what does your multiplier M_IC look like?

Note that i've tried with MINORITY Formula filled as "1" ou without anything.

Results are the same.

Tks a lot,

Olivia.

[Former Member · Accepted solution]

Hi Olivia,

have a look at SAP NOTE 1514944 - it is about the IS_CONSOL property in the AUDIT dimension. Alternatively, SAP NOTE 1682227 might help, it is about the STORE_GROUP_CURR property in your GROUP dimension.

BR,
Arnold

[Former Member · Accepted solution]

Arnold Warhonowicz wrote:

Hi Olivia,

have a look at SAP NOTE 1514944 - it is about the IS_CONSOL property in the AUDIT dimension.

Regarding that, my destination datasource used in business are already flagged as :

IS_CONSOL = Y

IS_CONVERT=Y

Alternatively, SAP NOTE 1682227 might help, it is about the STORE_GROUP_CURR property in your GROUP dimension.

BR,
Arnold

My consolidated scope is flagged as STORE_GROUP_CURRENCY=Y

I've got a conversion rule using AS_IS formula.

I do not use the integration mode in my BR formula.

So not sure i'm concerned with that note

But thanks for your help,

Olivia.

[Former Member · Accepted solution]

The destination datasources should be of DATARSC_TYP A and I never flag them as IS_CONVERTED = Y, instead I leave the IS_CONVERTED blank.

BR,

Arnold

[Former Member · Accepted solution]

That's true.

I made a mistake in my last answer.

My destination datasource are all, flagged as 'A', IS_CONSOL=Y and IS_CONVERTED=N (i can try by leaving them blank.... not sure it changes something.... as it should be the same )

BR

Olivia.

[former_member225135 · Accepted solution]

Hi,

Can you check what ratetype you have maintained for GLs which are there in Destination GL account.

If it is blank, try to fill it with CLOSING rate type.

Regards,

Rahul

[Former Member · Accepted solution]

Hi Rahul,

I've Ratetype = CLO.

BR,

Olivia

[Former Member · Accepted solution]

Hi,

It seems that amount that are doubled at each consolidation , come from account with ratetype = clo.

account with rate type = avg seems ok...

[former_member225135 · Accepted solution]

So, the issue is now closed?

Regards,

Rahul

[Former Member · Accepted solution]

Hi,

what does the rule for CLO look like?

BR,

Arnold

[Former Member · Accepted solution]

No 😞 It occurs for BS accounts....

[Former Member · Accepted solution]

Hi Arnold,

Please see the conversion rule for CLO :

My Flow Dimension :

Tks for your help,

Regards

Olivia

[former_member225135 · Accepted solution]

Hi Olivia,

You should also have a flow member with "OPENING" flow type.

Can you create the same and run the consol again.

Regards,

Rahul

[Former Member · Accepted solution]

Hi Olivia,

I would also try to leave the destination flow blank. Rahul is correct, you should also have an OPENING flow or leave the flow_type blank for F99.

BR,

Arnold

[former_member225135 · Accepted solution]

Hi Arnold,

SAP has said in note:1941497

• " Check Flow dimension.
  •   Flow_Type: Must have OPENING and CLOSING and VARSCP:the generic flow for change in scope"
    
    

So flow dimension should have opening and closing flow type.

I keep the delivered the flow member as it is and use to create a new flow member based on requirement

Regards,

Rahul

[Former Member · Accepted solution]

Hi Rahul,

I know, but in my experience having only OPENING or CLOSING is more of a problem then having neither.

BR,

Arnold

[Former Member · Accepted solution]

I totally agree with that, but unfornately, that fails (I need to put some securities in my flow dimension, to make unavailable the flow opening, which is unused in my case)

Anyway, thanks for your valuable help guys.

Regards

Olivia

[GregoireDesombre · Accepted solution]

Hi Olivia,

Do you still have this issue?

If you have "integration mode" activated in your model (it is for SAP IFRS content), check the note 2248325 - Duplicate value are generated with integration rule.

Regards,

Grégoire

[Former Member · Accepted solution]

Hi Grégoire,

Tks for your answer,

Yes, I 'd finally found the note,

It works fine now,

Best regards

Olivia

[former_member225135]

Hi Olivia,

It might be due to some parameters are missing in your dimension.Please check the below note:

1941497 - Check points for consolidation issue

Regards,

Rahul