BCS validations of amounts versus currencies or values

[Former Member]

Hi,

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?

[dan_sullivan]

Try using LC_YTD instead of VAL_YTD.

That should do the trick.

[Former Member]

Thanks dans,

This doesn't help, OSS note 870169 explains:

"VAL_YTD (Selection) >= 10,000

A formula of this type can be used up to Release 3.5 but as of Release 4.0, only the following syntax is permitted:

VAL_YTD (Selection) >= CONST (100, currency key, rate type)"

I am investigating other possibilities - will come back if I get something useful.