I would like to set a validation rule on the requisition lines to validate the account no. field IF the TYPE field is populated. So on the requisition, if the TYPE field is populated with G/L Account then the user must enter a valid account no. in the No. field. IF the TYPE field on the requisition line is "blank" then the user does not need to enter an account no. Is this possible using the Validation rule functionality? We are using NAV 2013 R1.
*This post is locked for comments
Hi,
This is a part of Standard Navision functionality and you can found it in Sales Order ,Purchase Order and almost everywhere.
In Sales Line you can check field Type and No and see how it is programmed.
You already have that functionality by standard, i am not sure what validation you are mentioning. When you setup a table relation on the field and if you specify ValidateTableRelation/TestTableRelation Property to yes, which is by default true it will apply that logic.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (