Product: MSGP 2010 SP3 version 11.00.2197, Dexterity version 11.00.0359.00 running on SQL Server 2008 R2
I am a Programmer/Analyst that supports MSGP for my company of 600+ employees. I'm looking for some help in developing an SQL Query that will show the PA User Class Security Setup for each user. On the front-end this is access via Microsoft Dynamics GP >> Setup >> Project >> User [User Project Accounting Settings]. There are (9) sub-forms with User Settings information that needs to be captured as well: Project, Timesheet, Equipment Log, Miscellaneous Log, Employee Expense, Purchase Order, Purchasing Invoice, Inventory and Billing.
A majority of the information is retained in Tables PA01501 and PA40401, but I need help translating the 0, 1, 2 codes--I understand that it indicates yes/no, checked/unchecked or a drop-down selection, but not what number is associated with which option. There is what I call the "manual method" which is going screen-by-screen and mapping it myself, but I'd rather not recreate the wheel if I don't have to.
We have identified a gap in our MSGP Security Matrix around Project Accounting User Classes and I was tasked with filling it in. Information on the Dynamics GP Project Accounting Tables is very limited and I would appreciate whatever assistance or resources anyone can offer. I would rank my SQL Query writing at a solid Intermediate skill-level.
Regards,
Joanne Herzog
