How to create a validation rules to control the Purchase Price cannot more than Last Purchase Price? : QNE Software Sdn. Bhd.

How to create a validation rules to control the Purchase Price cannot more than Last Purchase Price? Print

Created by: Cheng Kah Poh

Modified on: Mon, 7 Sep, 2020 at 3:11 PM

How to create a validation rules to control the Purchase Price cannot more than Last Purchase Price?

Solution:

Step 1 - Validation > Rules > Add… > RuleCriteria

Step 3 - Set as below:

ResultType: Error

Id: Rule name (PurchasePriceNotMoreThanLastPurchasePrice)

Target Type: Which transaction apply rules (QnEBS.BO.Purchase.PurchaseInvoiceDetails)

Criteria: Rules/Conditions ([UnitPrice] >= [Stock.PurchasePrice])

Step 4 - Save and re-login QNE

Done.

Cheng is the author of this solution article.

Did you find it helpful? Yes No

How to create a validation rules to control the Purchase Price cannot more than Last Purchase Price? Print