0

This is my validation rule for Account.But when I create new Opportunity in Account tab it throw me this error .

'Validation Formula 'myAccount_rule' invalid Could not access the following field BillingAddress.'

I didnot change anything on Account field but I just create new Opportunity in the Account type.Here is my validation rule formula:

AND(NOT(ISCHANGED(Type)) ,ISPICKVAL(Type,'Customer'),ISCHANGED(BillingAddress),$Profile.Name <> 'Finance',  $Profile.Name <> 'Operations', 
$Profile.Name <> 'System Administrator')

Why this happening and how to solve it?

Improve this question
3
  • may be there is some trigger on opportunity updating account. check that.
    – Tushar Sharma
    Commented Apr 7, 2016 at 5:44
  • Might also be a process or roll-up summary field.
    – Robin De Bondt
    Commented Apr 7, 2016 at 5:49
  • what do you mean by roll-up summary ?
    – unidha
    Commented Apr 7, 2016 at 7:20

1 Answer 1

Reset to default
3

The problem is that BillingAddress is a compound field and doesn't (yet) successfully support the ISCHANGED function. Curiously, it compiles fine in the VR editor.

You'll need to test each field explicitly

... OR(ISCHANGED(BillingStreet),ISCHANGED(BillingCity),....) ...

this was addressed also in the SFDC Forum

Improve this answer
1
  • Addition- it is also read only field.
    – unidha
    Commented Apr 8, 2016 at 3:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .