On the shortage consumption worksheet when I enter data in Item No, Variant code and then move onto the "From Zone Code" and "To Bin Code" SHOPFLOOR shouldn't be allowed.
This should produce an error if it's entered into both of these fields.
How do you go about Writing this? and In which function
Thank you!
*This post is locked for comments
Hello,
One option is to restrict it on the level as Nareshwar advised by placing warning messages for OnValidate trigger. Another option is to allow user to select the value, but within the next step verify if it has been selected and produce a warning message.
However generally the best option is not to allow user to actually see any values that he is restricted to select, in particular - to filter them out from the view based on user role settings. So, the user would not even see those values exist.
Hi,
On OnValidate on From Bin Code,
Do write:
IF "From Bin Code" = 'SHOPFLOOR' THEN
ERROR('SHOPFLOOR cannot be selected')
ELSE VALIDATE("From Zone Code");
and On OnValidate on From Zone Code,
Do write:
IF "From Bin Code" = 'SHOPFLOOR' THEN
ERROR('SHOPFLOOR cannot be selected');
This way, it'll fire the error at least on one field.
Hope it helps.
If you go onto From Bin Code and select SHOPFLOOR from that list it will still populate the From Bin Code and From Zone Code to SHOPFLOOR and ignore the Error. How can i prevent this. I don't think a TESTFIELD would work in this situation???
Hi,
You can probably write a TESTFIELD on the OnValidate of "From Zone Code" field on the relevant table.
Link: https://msdn.microsoft.com/en-us/library/dd301274(v=nav.70).aspx
Or you can use ERROR if you need to pop up customized error text.
IF "From Zone Code" = 'SHOPFLOOR' THEN
ERROR('SHOPFLOOR cannot be selected');
You can write this OnValidate of "From Zone Code" field on the relevant table as well.
Hope it helps.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (