Skip to Content
0
Former Member
Oct 09, 2006 at 05:04 PM

BCS validations of amounts versus currencies or values

22 Views

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?