CRM On Demand - Administration (MOSC)

MOSC Banner

Field Validation Error message

edited Sep 20, 2011 3:23AM in CRM On Demand - Administration (MOSC) 4 commentsAnswered
Hello all.

I have a field validation rule that is working as expected in production.

=IIf([<pl_Status_ITAG>]='Closed/Won' And PRE('<pl_Status_ITAG>')<>'Closed/Won' And [<bFS_MLA_ITAG>]<>'Y','X',IIf([<pl_Status_ITAG>]='Closed/Won' And PRE('<pl_Status_ITAG>')<>'Closed/Won' And [<stCompany_Brand_ITAG>]is NULL,'X',IIf([<pl_Status_ITAG>]='Closed/Won' And PRE('<pl_Status_ITAG>')<>'Closed/Won' And[<bHas_the_Tax_Exempt_Certificate_ITAG>]<>'Y','X',IIf([<pl_Status_ITAG>]='Closed/Won' And PRE('<pl_Status_ITAG>')<>'Closed/Won' And IfNull([<PrimaryShipToPostalCode>],'Null')='Null','X', IIf([<pl_Status_ITAG>]='Closed/Won' And PRE('<pl_Status_ITAG>')<>'Closed/Won' And ([<bPrimary_Ship_to_Flag_ITAG>]='N' AND [<stSite_Name_ITAG>] is null),'X',[<pl_Status_ITAG>])))))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center