Validation rule: Designation_Must_Be_Active

Name

Designation_Must_Be_Active

Label

Designation_Must_Be_Active

Object

AQB__Transaction__c

Active

No

Formula

OR (
AND(
AQB__MovingToNewAccount__c = FALSE,
NOT(ISNEW()),
ISCHANGED( AQB__ChartofAccounts__c),
AQB__PledgePayment__c = FALSE, AQB__WriteOff__c = FALSE, AQB__Voided__c = FALSE,
AQB__ChartofAccounts__r.AQB__Active__c = FALSE),
AND(AQB__MovingToNewAccount__c = FALSE,
ISNEW(),
AQB__PledgePayment__c = FALSE, AQB__WriteOff__c = FALSE, AQB__Voided__c = FALSE, AQB__ChartofAccounts__r.AQB__Active__c = FALSE))

Error message

The Designation is not active, please enter an active Designation.

Error location

Designation

Description

The Designation must be Active unless making a Pledge Payment.