Validation method for Price change

[Former Member]

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

[Former Member]

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