Validation rule: Check_Inventory

Name

Check_Inventory

Label

Check_Inventory

Object

AQB__RecognitionOptionOffer__c

Active

Yes

Formula

IF( ISPICKVAL( AQB__RecognitionOption__r.AQB__OKtoOverbook__c, 'Yes' ),
FALSE,
IF( AQB__RecognitionOption__r.AQB__InventoryAvailable__c > 0,
FALSE,
IF( ISPICKVAL( AQB__RecognitionOption__r.AQB__InventoryMethod__c, 'ReducebyAcceptedOnly' ),
IF( ISNULL( AQB__DateAccepted__c ),
FALSE,
IF( AND( NOT( ISNEW() ), NOT( ISNULL( PRIORVALUE( AQB__DateAccepted__c ) ) ) ),
FALSE,
TRUE
)
),
IF( OR( ISNEW(), AND( ISNULL( AQB__DateAccepted__c ), ISNULL( AQB__DateRejected__c ), NOT( ISNULL( AQB__DateOffered__c ) ), ISNULL( PRIORVALUE( AQB__DateOffered__c ) ) ) ),
TRUE,
IF( AND( ISNULL( AQB__DateOffered__c ), NOT( ISNULL( AQB__DateAccepted__c ) ), ISNULL( PRIORVALUE( AQB__DateAccepted__c ) ) ),
TRUE,
IF( AND( OR( NOT( ISNULL( AQB__DateOffered__c ) ), NOT( ISNULL( AQB__DateAccepted__c ) ) ), ISNULL( AQB__DateRejected__c ), NOT( ISNULL( PRIORVALUE( AQB__DateRejected__c ) ) ) ),
TRUE,
IF( AND( NOT( ISNULL( AQB__DateOffered__c ) ), NOT( ISNULL( AQB__DateAccepted__c ) ), ISNULL( PRIORVALUE( AQB__DateOffered__c ) ), ISNULL( PRIORVALUE( AQB__DateAccepted__c ) ) ),
TRUE,
FALSE
)
)
)
)
)
)
)

Error message

Inventory has been exceeded!

Error location

Top of Page

Description

Checks to ensure that inventory is available prior to allowing an Recognition Option Offer to be recorded.