Validation against multiple Local Currencies

All postings related to SEM only

Moderators: Snowy, thx4allthefish

Post Reply
TheScotsman
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Validation against multiple Local Currencies

Post by TheScotsman » Mon Oct 09, 2006 10:59 am

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
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Post by TheScotsman » Mon Oct 09, 2006 11:52 am

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
Posts: 197
Joined: Fri Mar 07, 2003 10:26 am

Post by dans » Tue Oct 10, 2006 6:45 am

Have you tried LC_YTD instead of VAL_YTD?

I think that should work.

TheScotsman
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Post by TheScotsman » Mon Oct 16, 2006 6:53 am

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
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Post by TheScotsman » Fri Dec 01, 2006 6:06 am

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!

Post Reply