This option will reset the home page of this site. Restoring any closed widgets or categories.

Reset
Home  »  Archives

SQL Server

Page 1 of 212

SQL Script to Reconcile GL vs. AA Balances

Written on 16 May, 2010 at 12:45 in Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 3 Comments

Hi all Having used Analytical Accounting for quite some time now, I have come across various issues in Analytical Accounting module, which has caused serious data discrepancy between the General Ledger tables and the Analytical Accounting tables. So I had... (Continue reading)

Tagged with:             

SQL Script to delete stranded activity for a specific user

Written on 16 May, 2010 at 12:22 in Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, System | viewed 1 views times | 4 Comments

Hi all In this article I am providing a script to delete the activity table records for a specific stranded user in Dynamics GP. This will enable us not to have all the users log out of GP in order... (Continue reading)

Tagged with:                             

SQL Script to provide access to Transaction Dimension Codes to Users

Written on 11 May, 2010 at 18:42 in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 2 Comments

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)

Tagged with:         

SQL Script for Revaluation Process

Written on 18 Mar, 2010 at 16:44 in Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 0 Comments

Hi all During this week, I just thought of writing a simple SQL script to calculate the gain (or) loss for a particular currency/account combination based on a specific date that has been provided. The script has been written for... (Continue reading)

Tagged with:                         

Macro to provide access to Transaction Dimension Codes to Users

Written on 3 Mar, 2010 at 15:56 in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 3 Comments

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... (Continue reading)

Tagged with:                 

SQL View for Payables Transactions with AA Codes

Written on 1 Mar, 2010 at 18:01 in Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 1 Comment

Guys There is a smartlist object for AP transactions, but this smartlist does not show the analytical accounting information in it. So in this post, I have decided to post a SQL view to generate a view to show AP... (Continue reading)

Tagged with:                 

Handling Primary Key Errors in Analytical Accounting

Written on 23 Dec, 2009 at 8:11 in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 2 Comments

Hi all… It has been some time, since I have posted something here… Was busy at many other assignments. However, here comes an article which will be of interest and use to many, especially those who are using Analytical Accounting... (Continue reading)

SQL Code for GL Trial Balance

Written on 26 Apr, 2009 at 10:15 in Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 6 Comments

Guys Today, I just decided to post a simple code snippet to generate a detailed GL Trial Balance with reference to the various sub ledgers, including the multi-dimensional information. IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_GLTrialBalance]')... (Continue reading)

String Parser SQL Function

Written on 20 Apr, 2009 at 18:44 in SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 0 Comments

Guys The post I am making now, can be one from a very old school of thought, but is a recurring problem, which the developers face, day in and day out, as they write SQL scripts. It is about parsing... (Continue reading)

Decrypt SQL 2000 Stored Procedures, Functions, Views, and Triggers

Written on 24 Dec, 2008 at 23:09 in SQL Server, SQL Server 2005 | viewed 1 views times | 0 Comments

Note: This method has to be handled with utmost care only in critical situations, and my experienced database administrators to provide critical support services in case of a SQL emergency. In order to decrypt the objects in SQL Server 2000,... (Continue reading)

Page 1 of 212