Validation against multiple Local Currencies

[TheScotsman]

Hi All,
I want to validate against a constant value in multiple local currencies - can anyone advise / help?

I am loading data to many consolidation units, each has its own Local Currency.

We wish to validate selections of Items to within a limit in local currency, say 10,000.

So if the unit is Dutch, we'd make sure the validation was within 10,000 euros.
If it was Japanese we'd validate to within 10,000 Yen
British to 10,000 GBP, American to 10,000 USD.
etc.

I am aware of how to validate to a fixed value in a fixed currency (eg all validated to 10,000 GBP) by translating in the validation.
However I do not want to translate due to performance impact.

I just want to validate to the absolute value for each unit's currency. However this doesn't seem possible unless you assign a seperate method to each unit (and the nightmare maintenance scenario going forward).

Is there a way to do this?
Please let me know if I can clarify the problem for you.

[TheScotsman]

To clarify, we want to do this:
VAL_YTD (Selection) >= 10000

but BCS 4.0 and above requires this:
VAL_YTD (Selection) >= CONST (10000, currency key, rate type)

Is it possible to have the currency key as some sort of variable or user exit that changes according to the Consolidation Unit's own local currency?
(thereby removing any requirement to perform currency translation during the validation).

[dans]

Have you tried LC_YTD instead of VAL_YTD?

I think that should work.

[TheScotsman]

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.

[TheScotsman]

In the end the requirement changed, so we went with a check against 10,000 USD for all Consolidation Units, which makes more sense anyway!