on 12-28-2016 2:40 AM
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
Incorrect syntax:
Not:
OTHER = [ENTITY=%S_ENTITY_SET%]
But:
OTHER = [S_ENTITY=%S_ENTITY_SET%]
in OTHER real names have to be used!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Thanks Vadim. It worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.