Category: SQL Server 2000
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 [...]
SQL Script to Reconcile GL vs. AA Balances
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 decided to write up a simple SQL script to reconcile the balances for every account [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
Loading ...