Skip to main content
Topics#Data ManagementEduardo Caprile の質問
Eduardo Caprile が「#Data Management」で質問
2017年10月24日 16:15

need to set up validation rule

Hi All, 

 

I have set the following validation rule with the following criteria:

 

*Criteria:*

 

If the Account Number is equal to MTL00105 and Account's Business Unit

 

equal to "Chile"

 

And the following is null or blank

 

 - Po Line

 

 - Customer Product Code

 

*Display the MSG error:*

 

English: "The PO Line and Customer Product Code are requested"

 

I have created:

 

AND( Opportunity.Account.AccountNumber ="MTL00105", 

 

ISPICKVAL (Opportunity.Account.Pais__c,"Chile"), 

 

OR( 

 

ISBLANK (Customer_Product_Code__c), 

 

ISBLANK (Po_Line__c) 

 

) 

 

But the issue that i am facing is that error "The PO Line and Customer Product Code are requested"  is not appearding at the top of the screen, could you please advise if there´s any value that i am inserting wrongly?

 

Regards

 

Eduardo
5 件の回答
  1. John Mitchell
    2017年10月24日 16:22
    Sounds like its all within the AND statement? Try removing the OR. Is the below correct?

     

    If:

    • Account Number = MTL00105 AND
    • Account Country = Chile AND
    • Customer Product Code = blank AND
    • PO Line = blank THEN
    • <error message>
回答を記入...
0/9000