Skip to main content
Topics#FormulasDeveloper Forums User (Inactive)의 질문
Developer Forums User (Inactive) (Salesforce Developer Forums) 님이 #Formulas에 질문했습니다
2017년 11월 27일 오후 12:33

Validation rule on OpportunityLineItem (opportunity product)

On a visualforce page, I am creating an opportunity and I am adding an OpportunityLineItem (opportunity product) to it.

The product2 linked to the opportunity product has a field called Maximum_Discount_in_percent_EUR__c, which is a percent field and specify the maximun discount possible.

When adding the opportunity product on the visualforce page, you can enter a discount in % (standard Discount field) or a net price (Net_Price_Discount__c). There is a validation rule preventing you for entering both.

The opportunity product has a validation rule checking if the discount is not superior to the authorized discount.

Here is the rule's formula:

    AND(

    NOT($User.ByPass_VR__c),

    OR(

    AND(

    Product2.Maximum_Discount_in_percent_EUR__c <> 0,

    IF(ISBLANK(Discount) || ISNULL(Discount),

    (ListPrice - (Product2.Maximum_Discount_in_percent_EUR__c * ListPrice)) >= Net_Price_Discount__c,

    Product2.Maximum_Discount_in_percent_EUR__c < Discount))

    )

    )

I have tested the NOT($User.ByPass_VR__c) line, and it is not giving me any problems.

When I enter a discount in the Discount field superior the authorized one, the validation rule worked fine and I get my error message.

But when I enter e net price in Net_Price_Discount__c inferior to the authorized one, then it doesn't work and I can save the opportunity product.

Is the problem in my formula or can it be somewhere else?

Thank you for your help
답변 1개
  1. Developer Forums User (Inactive) (Salesforce Developer Forums)
    2017년 12월 8일 오전 8:51
    I actually find a solution to my problem.

    I made a new  separated validation rule. Because there is already a validation rule preventing you for entering a discount i percent and a net price, I don't need to check if the Discount field is blank or null.

    Here is the validation rules formula:

        AND(

        NOT($User.ByPass_VR__c),

        OR(

        AND(

        Product2.Maximum_Discount_in_percent_NOK__c <> 0,

        (PricebookEntry.UnitPrice - (Product2.Maximum_Discount_in_percent_NOK__c * PricebookEntry.UnitPrice)) > Net_Price_Discount__c)

        )

        )

    A good old divide and conquer solution ;-)