BPC Consolidations 10.1 how to use the ELIM=Y property in Entity

[Former Member]

Hello

I am attempting to perform a US Elimination in NW 10.1 standard model. 

i do not fully understand the use of the Elim = Y property,   ( is elimination entity?)  in the Entity dimension.

i have several company codes/entities in this dimension that i want to be included in the US Eliminations process.

Do i set them all to 'Y'  or what entities are supposed to be Y?    These are all my normal Entities. 

at the Account level, i have set the property for those accounts to be eliminated with an entry for plug account. ie.

Account 12345  has property ELIMACC (offset account)  set to 'plugaccountXYZ)

so i have balances as such

Entity ABC     Account  12345    TP XXX    $100

Entity XXX     Account 45678    TP ABC      -$100

i would expect offsetting entries to go to plugaccountXYZ   if i have specified that in the Account dimension members for 12345 & 45678  

do i set  ELIM = Y  to ABC  and XXX      or do i have a different Entity involved that is Y?

[former_member186338 · Accepted solution]

Hi Timothy,

Simply read the guide:

Vadim

[Former Member · Accepted solution]

Thanks Vadim,

I did find the documentation previously and am using that to build the environment, but did not understand the description of ELIM = Y the way it is written and explained.

Thanks for the guidance though,  I think my problem was assuming I would eliminate accounts,  and not eliminating Entities.  I see the reference to technical entities which I have not created.

[former_member186338 · Accepted solution]

Ups,

It's absolutely simple! You have number of real entities under some parent. You have to create special elimination entity under the same parent with property ELIM=Y. Then all elimination figures will be posted to this special entity.

Vadim

[Former Member · Accepted solution]

Thanks for confirming!

[damovand]

Hello,

US elimination finds all entities that can go through elimination, ELIM<>Y.  It stores elimination values in entities under the same common parent and have property value ELIM=Y .

Best Regards,

Leila

[Former Member]

so to understand fully,

I need 2 entities   such as ABC  and elimABC   with one set to 'y'  to record the elimination from the original entity?

you do not eliminate account balances within the same entity but use different entities to book the offsetting amount.

if so, it seems I need both a sepearte entity  'elimABC'  in ENTITY  and an offset account in my ACCOUNT dimension as well?