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

 

 

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

** Learn more about QNE Hybrid Cloud Software


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article