Currency Translation - Does not filter on Entity Dimension

[selva_amd]

Hi,

When I perform currency translation, it does not filter out based on the Entity selected. currency conversion is performed for all company codes. I have maintained the appropriate dimension and properties.

In the business rule I have only 1 rule.

Source Flow: Balance

Formula: AVG

Is there any thing I missed out?

Currency Translation logic in FXTRANS.lgf

RUN_PROGRAM CURR_CONVERSION
CATEGORY = %S_CATEGORY_SET%
TID_RA = %S_TIME_SET%
OTHER = [ENTITY=%S_ENTITY_SET%]
RATEENTITY = Global
*ENDRUN_PROGRAM

[Former Member]

Hi Selva,

Can you please share the names of the dimensions Entity and Category and Data manager Package Advanced script? While running Currency conversion package are you selecting the entity?

JP

[former_member186338 · Accepted solution]

Incorrect syntax:

Not:

OTHER = [ENTITY=%S_ENTITY_SET%]

But:

OTHER = [S_ENTITY=%S_ENTITY_SET%]

in OTHER real names have to be used!

[Former Member · Accepted solution]

Hi Vadivm, please help us find solution.
We have a problem with FX Restatement package. We trying translate LC to USD. After translating we don'thave any data on AUDITTRAIL with attribute 'DATA SOURCE TYPE' = "A", and attribute 'IS TRANLATED' = "Y", but on on AUDITTRAIL with attribute 'DATA SOURCE TYPE' = "M", and attribute 'IS TRANLATED' = "Y" - all work is fine.

[selva_amd]

Thanks Vadim. It worked.

[selva_amd]

Hi JP,

Here is the details.

Entity Dimension: S_ENTITY

Category: S_CATEGORY

before-currency-translation.jpgselection-values.jpgafter-currency-translation.jpg

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CURRENCY_DIM%,%CATEGORY_DIM%,%TIME_DIM%")
TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,FXTRANS.LGF)