I want to validate a local currency amount to a fixed value for all Consolidation unit's currencies.
ie British Unit = 10,000 GBP,
Japanese unit = 10,000 JPY
American Unit = 10,000 USD
I do not want to perform any tranlsations in the validation task, therefore I do not want to specify a specific currency in the validation rule.
OSS note 870169 says that the following is no longer possible:
VAL_YTD (Selection) >= 10000
(NB This is possible in release 3.5 and below)
Therefore I must use this format (from BCS 4.0 onwards):
VAL_YTD (Selection) >= CONST (10000, currency key, rate type)
However I want to use a variable currency key, in which the curency key used is the local currency of the COnsolidation Unit being validated
- does anyone know how this is done?
- is it possible?
- any other work arounds?