I currently trying to make a field a 'required field', the problem i am having it that i am under the BRL pack. which does not have Field Level Security nor Modifier with VBA and to acquire these modules we will have to AM & AME.
Can this be done through SQL?
*This post is locked for comments
Vaidy is correct, you will need a customisation tool of some sort to make this happen.
If you at least get the customisation site license, then your partner can make the change and send you a package.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Ozle,
I don't think you would be able to do it from SQL, since the "Required Field" property is completely a DEX way of forcing the Users to enter a value to the concerned field.
You at least need Modifier to get this done.
But you may want to wait till others reply to your query.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156