Add Compulsory Column Rule upon save

Created by QNE Software Sdn bhd, Modified on Tue, 22 Nov, 2022 at 3:41 PM by QNE Software Sdn bhd

Scenario

Add Rule for compulsory key in a column upon save

Example column “Reference No” in Sales Invoices

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”