Scenario

Add Rule for compulsory key in a column upon save

Example column “Reference No” in Sales Invoices

Solution

1. Go to Maintenance > System Option

2. Press and hold Ctrl + Shift + F9

3. Key in password “qne2004” and click OK

4. Go to Tools > Customization Centre

5. Expand Win > expand Application > double click “QNE Optimum”

6. Expand Validation > right-click on “Rules”

7. Select “Add” > Select “RuleRequiredField”

8. Key in “TargetType” = QnEBS.BO.Sales.SalesInvoices

9. Key in “TargetPropertyName” = ReferenceNo

10. Select “ResultType” = Error

11. Select “TargetContentIDs” = Save

12. Key In “CustomMessageTemplate” = Reference No. must not be empty.

13. Key in “Id” = SalesInvoices.RefNoRequiredRule

14. Key in “Name” = SalesInvoices.RefNoRequiredRule

15. Click Save and re-login Optimum

16. Now Optimum will prompt Error message when save Sales Invoice without enter “Reference No”

** Learn more about Azure Cloud

Qne is the author of this solution article.

Did you find it helpful? Yes No