Thanks!
In V10.0 they added the syCurrentResources (SY09400) table.
Go to Microsoft Dynamics GP >> Tools >> Maintenance Clear Data
Click Display, Click Physical. Select System Series and Insert the Security
Resource Descriptions table.
Click OK and send the report to the screen
Now you can join with the SY09400 table at the SQL level to get names for
forms and reports.
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.M...@online.microsoft.com
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.
Thanks again for your help.