on 03-14-2008 7:20 AM
Hi,
I was trying to build a validation for checking the change in Price.
My setup
Price is a Qualifier and Amount is a Currency field in the Qualified lookup table.
Requirement : When I modify a Item master record and change the Price value, need a validation to throw an error or warning for a Price change greater than 10% from the existing value.
I was trying the following, but it does not work correctly.
IF(Price Information.Amount>(Price Information.Amount)*1.05),TRUE)
Regards,
Balaji
Hi,
I have tried the options mentioned in the thread here. I'm using SRM MDM Catalog. When I try to run this check
IF((Price Information.Amount-[Original].Price Information.Amount) > 10,FALSE,TRUE)
The IF condition goes to the ELSE condition and sets the Flag to TRUE always.
When I tried to use
IF((Price Information.Amount-[Original].Price Information.Amount) = 0,FALSE,TRUE)
It always sets the flag to FALSE. That shows the result of subtraction is always "0". Not sure why this is happening.
If I use another field, that is not a qualifier, this logic works fine very well.
IF((Delivery Time In Days - [Original].Delivery Time In Days) > 10,FALSE,TRUE)
Is there a limitation with SRM MDM Catalog working with a Qualifier?
Regards,
Balaji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.