Skip to Content
0
Former Member
Jul 30, 2014 at 09:40 AM

Consolidate in prompted currency

14 Views

Hello experts,

I need to consolidate the Groups in different currencies, depending on what user select in the prompt when executing the Legal Consolidation Data Package regardless what currency is in the GROUP_CURRENCY property.

Do you know if it's possible to achive this using standard code?.

Thank you.

Right now i've tried this codes, but none works:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

OTHER = [CURRENCY = %CURRENCY_SET%]

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

OTHER = [CURRENCY = %CURRENCY_SET%]

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

----------------------------------------------------------------------------------------------------------------------------------------------------------------

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %CURRENCY_SET%

OTHER = [GROUP = %GROUPS_SET%]

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

OTHER = [CURRENCY = %CURRENCY_SET%]

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM