Restricting Dimension Codes to Specific Account Numbers
Hi all In this article, I am going to explain yet another functionality in Analytical Accounting, where we can restrict a dimension code to a specific account number (or) a specific range of accounts. When a dimension code is created, we need to grant access to the dimension codes to specific users who can use [...]
June 20, 2011 · 
veeyeskay · 
2 Comments
Tags: Account Access, Account Restriction, Select Accounts, Transaction Dimension Code Restriction, Transaction Dimension Codes · Posted in: Analytical Accounting, Dynamics, Great Plains Total Views: 218
SQL Query for AA Multicurrency Summary Balances
Hi all In this article, I am posting a SQL script which generates the multicurrency period balances at transaction dimension code level. The standard GP’s multicurrency summary table MC00201 provides period balances at GL Account level. The result of this script would tie back to the balances you would see in the above mentioned GL [...]
November 9, 2010 · veeyeskay · 2 Comments
Tags: AA Summary Balances, Analytical Accounting, MC00201, Multicurrency Summary Balances, Transaction Dimension Codes · Posted in: Analytical Accounting, SQL Server 2005, SQL Server 2008 Total Views: 1,996
SQL Query for AA Functional Summary Balances
Hi all In this article, I am posting a SQL script which generates the functional period balances at transaction dimension code level. The standard GP’s summary tables GL10110 (Open Year) and GL10111 (Historical Year) provides period balances at GL Account level. The result of this script would tie back to the balances you would see [...]
November 9, 2010 · veeyeskay · 4 Comments
Tags: AA Summary Balances, Analytical Accounting, GL10110, GL10111, Transaction Dimension Codes · Posted in: Analytical Accounting, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 440
SQL Script to provide access to Transaction Dimension Codes to Users
Hi all I had posted an article sometime back titled Macro to provide access to Transaction Dimension Codes to Users where I had provided a SQL script to create a macro code to provide access to all users to all transaction dimension codes setup in the company. I had received a few comments from user [...]
May 11, 2010 · veeyeskay · 10 Comments
Tags: Analytical Accounting, Transaction Dimension Codes, User Access · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 682