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.
Validation against multiple Local Currencies
Moderators: Snowy, thx4allthefish
-
- Posts: 102
- Joined: Fri Nov 19, 2004 9:32 am
- Location: London
-
- Posts: 102
- Joined: Fri Nov 19, 2004 9:32 am
- Location: London
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).
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).
-
- Posts: 102
- Joined: Fri Nov 19, 2004 9:32 am
- Location: London
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.
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.
-
- Posts: 102
- Joined: Fri Nov 19, 2004 9:32 am
- Location: London