Validation rule: PlannedExp_Restrict_Updates

Name

PlannedExp_Restrict_Updates

Label

PlannedExp_Restrict_Updates

Object

Planned_Expenditure__c

Active

Yes

Formula

AND(
NOT(ISPICKVAL(Spending_Plan_ID__r.Status__c, 'Initial Draft')),
NOT(ISPICKVAL(Spending_Plan_ID__r.Status__c, 'Draft')),
OR(
ISCHANGED(Amount__c),
ISCHANGED(Class_Code__c),
ISCHANGED(Analysis_Code__c),
ISCHANGED(Expenditure_Summary__c),
ISCHANGED(PC_Name__c),
ISCHANGED(Responsibility_Centre__c)
)
)

Error message

The record can only be edited during Initial Draft or Draft stage of the Spending Plan.

Error location

Top of Page

Description

Planned Expenditure record can only be updated if spending plan is in Initial Draft or Draft