Validation rule: Debit_Account_Must_Be_Active

Name

Debit_Account_Must_Be_Active

Label

Debit_Account_Must_Be_Active

Object

AQB__Transaction__c

Active

Yes

Formula

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

Error message

The Debit Account is not active, please enter an active Debit Account.

Error location

Debit Account

Description

The Debit Account must be Active unless making a Pledge Payment.