Resource: Property, Field : ListPriceLow

Description

ListPriceLow must be no more than 15% lower.

Error Messages

1) ERROR, the low list price must be less than the list price.
2) ERROR, the low list price must be within 15% of the list price.

Fields referenced within this rule

ListPrice

ListPriceLow

Syntax with comments and error messages

//[ErrMsg1^ERROR, the low list price must be less than the list price.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk3^FALSE]
//[ErrMsg2^ERROR, the low list price must be within 15% of the list price.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk4^FALSE]
// Admin. bypass clause - line below
(/*[LogicBlk1]*/.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ')).OR.
// Start of rule... First verify that target field and the list price are not empty and have changed ...
IIF((/*[LogicBlk2]*/(.ENTRY. != .EMPTY.).AND.(ListPrice != .EMPTY.).AND.((.OLDVALUE. != .ENTRY.).OR.(LASTListPrice != ListPrice))),
// (THEN)
// If list price is greater than low list price.
((/*[LogicBlk3]*/ListPrice > .ENTRY.).AND.
// If low list price must be no more than 15% lower than list price.
(/*[LogicBlk4]*/(.ENTRY. >= (0.85 * (ListPrice))))),
// (ELSE)
// Accept if target field is empty
.ENTRY. = .EMPTY.)

Syntax only

(.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ')).OR.IIF(((.ENTRY. != .EMPTY.).AND.(ListPrice != .EMPTY.).AND.((.OLDVALUE. != .ENTRY.).OR.(LASTListPrice != ListPrice))),((ListPrice > .ENTRY.).AND.((.ENTRY. >= (0.85 * (ListPrice))))),.ENTRY. = .EMPTY.)

Rule Unique ID

d7de0ab8-65d4-4fd0-8fa6-2045e68190e2

ACCEPT