RSSCategory: SQL Server 2000

SQL Script for Vendor EFT Information

| 07/16/2011 | 2 Comments
SQL Script for Vendor EFT Information

Hi all Today, I am posting a SQL Script for getting the EFT information of various vendors. /****************************************************************** Created July 16, 2011 by Sivakumar Venkataraman – Interdyn AKA This view returns a returns the details of the EFT Information for the various vendors setup in the company.   Tables used: – PM00100 – Vendor Class […]

Continue Reading

SQL Script to delete stranded activity for a specific user

| 05/16/2010 | 5 Comments
SQL Script to delete stranded activity for a specific user

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 to execute these scripts. This is typically handy when we have many users signed into […]

Continue Reading

SQL Script to provide access to Transaction Dimension Codes to Users

| 05/11/2010 | 12 Comments
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 […]

Continue Reading

SQL Script for Revaluation Process

| 03/18/2010 | 1 Comment
SQL Script for Revaluation Process

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 the following assumptions. All accounts revalue at Period Balances Revaluation is done using an Exchange […]

Continue Reading

Macro to provide access to Transaction Dimension Codes to Users

| 03/03/2010 | 6 Comments
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 […]

Continue Reading

SQL View for Payables Transactions with AA Codes

| 03/01/2010 | 11 Comments
SQL View for Payables Transactions with AA Codes

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 transaction information along with the analytical accounting information.   IF EXISTS ( SELECT * FROM […]

Continue Reading