May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Recent Posts

Archives

Analytical Accounting

Page 3 of 41234

SQL Query for AA Multicurrency Summary Balances

Published 11/09/2010 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, SQL Server 2005, SQL Server 2008 | Tagged , , , , | 2 Comments

SQL Query for AA Functional Summary Balances

Published 11/09/2010 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , , , | 4 Comments

GL Transactions with AA Details

Published 09/13/2010 | By veeyeskay

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.… Continue reading →
Posted in Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 | Tagged , , , , | 5 Comments

Year End Close Issue with AA – Workaround

Published 06/08/2010 | By veeyeskay

Hi all

Recently, I was working on the year end for one of our clients and landed up in the error shown below during the YEC process for the General Ledger.

image

Based on the error message, I believed it was… Continue reading →

Posted in Analytical Accounting, General Ledger, Great Plains | Tagged , , , , , , | 3 Comments

SQL Script to provide access to Transaction Dimension Codes to Users

Published 05/11/2010 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | Tagged , , | 10 Comments

Issue with Journal Entry Back-outs in Analytical Accounting

Published 04/26/2010 | By veeyeskay

Hi all

Sorry for not posting for quite some time… Has been a hectic month and a half for me… :( But I have now come back and I have decided to post an interesting issue that we have faced in… Continue reading →

Posted in Analytical Accounting, Dynamics, Great Plains | Tagged , , , | 2 Comments
Page 3 of 41234

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.