SQL View for AA Accounting Class–GL Account Link Information
In this post, I am posting a SQL script for fetching the AA Accounting Class Link for various GL accounts in a company. It also provides us some key information about the accounting class that has been defined in Analytical Accounting. SELECT RTRIM(B.ACTNUMST) AS GPACCOUNTNO, RTRIM(A.ACTDESCR) AS GPACCOUNTDESC, ISNULL(D.aaAccountClass, ”) AS AAACCOUNTINGCLASS, ISNU Read the [...]
January 15, 2011 · 
veeyeskay · 
5 Comments
Tags: AA Accounting Class, Analytical Accounting, Data Entry Rule, Dimension Code, GL Accounts, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005 Total Views: 666
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
GL Transactions with AA Details
Hi all Today I decided to post a simple SQL code to fetch GL Transaction Details along with dimension codes from the Analytical Accounting module. SELECT A.aaGLHdrID, A.JRNENTRY, A.RCTRXSEQ, A.YEAR1, A.GLPOSTDT, B.INTERID, B.ACTINDX, F.ACTNUMST, B.CURNCYID, C.DEBITAMT, C.CRDTAMNT, C.ORDBTAMT, C.ORCRDAMT, E.aaTr Read the rest of this entry
September 13, 2010 · veeyeskay · 5 Comments
Tags: Analytical Accounting, Dimension Code, General Ledger, SQL View, Trial Balance · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 Total Views: 1,437
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