Skip to Content
0

account filter in CURRENCY translation not working

Dec 31, 2017 at 05:08 PM

38

avatar image
Former Member

Hi,

I'm trying to run currency translation for specific accounts as below but FX translation is running for all accounts. Has anyone experienced similar issue?

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = ACTUAL
GROUP = CG_ALL
TID_RA = 2017.10
OTHER = [ACCOUNT=A_1000]
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Dec 31, 2017 at 08:12 PM
0

Account dimension can't be used as a filter for currency conversion. No way! Use rate type.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Vadim,

thanks for your reply. Could you provide me syntax on how to use rate type?

I tried in both of the below ways but not working.

OTHER = [RATETYPE=CLO]

OTHER = [ACCOUNT.RATETYPE=CLO]

0
Vadim Kalinin Dec 31, 2017 at 09:42 PM
0

I don't understand your requirements. In the rule definition use only required rate types.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

1st, i need to run currency translation for all accounts and all rate types just before consolidation process.

Then, after consolidation is complete, i need to run currency translation again for only few accounts. How can i achieve this? how can i define "all rate types for 1st run" and "only required rate types for 2nd run"?

0

Strange and unsupported requirement - to perform conversion before and after consolidation. Please explain what is the business reason.

0