SQL View For User–AA Code Access
Hi all In this article, I have posted a script to determine the access to analytical account dimension codes to various users who have access to the company. SELECT DB_NAME() AS COMPANY, A.USERID, C.USERNAME, D.aaTrxDim, D.aaTrxDimDescr, B.aaTrxDimCode, B.aaTrxDimCodeDescr, CASE WHEN ISNULL(E.aaDistribute, 0) = 0 THEN ‘No’ ELSE ‘ Read the rest of this entry
January 15, 2011 · 
veeyeskay · 
One Comment
Tags: Analytical Accounting, Dimension Code, Dimension Code Access, User Access · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 391
Restricting AA Dimension Codes to GL Accounts
Hi all We have come across many requirements to restrict GL accounts for various users in the system. This is generally achieved by Organization Structure definition and by activating Account Level Security. But in this episode, we are going to analyze a requirement where we need to restrict dimension code entry to specific GL accounts. [...]
November 10, 2010 · veeyeskay · One Comment
Tags: Account Access, Account Level Security, Dimension Code Access, GL Accounts · Posted in: Analytical Accounting, Dynamics, Great Plains Total Views: 338
Macro to provide access to Transaction Dimension Codes to Users
Hi all In this article, I am going to publish a SQL script which will be helpful to many using Analytical Accounting module. I have come across many clients who have multiple companies and they have hundreds of users spread across each of these companies. Assume the case when a new dimension code value has [...]
March 3, 2010 · veeyeskay · 6 Comments
Tags: Access, Analytical Accounting, Dimension Code, Dimension Code Access, Macro · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 1,804