Skip to Content
avatar image
Former Member

Validation method for Price change

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 17, 2008 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded