Archive for the ‘SQL Server 2008’ Category
SQL Script for AP-GL Reconciliation
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general [...]
January 17, 2012 · 
veeyeskay · 
2 Comments
Tags: ap to gl, ap to gl reconcile, General Ledger, payables, Payables Reconciliation, reconcile, Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 369
Post Through GL for Computer Checks – with Analytical Accounting
When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents [...]
August 4, 2011 · veeyeskay · No Comments
Tags: analytical accounting activation, computer checks, post through general ledger files, post through gl, Posting Setup · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 131
Recent Updates to Payables HATB Script
Hi all I have posted an updated for the following scripts today. Please make use of these updated scripts for the historical aged trial balance in payables. AP Historical Aged Trial Balance – By GL Posting Date http://msdynamicstips.com/2010/10/09/payables-hatb-report-sql-query/ AP Historical Aged Trial Balance – By Document Date http://msdynamicstips.com/2010/10/08/payables-hatb-using-document-date/ Hope this Read the rest of this [...]
June 30, 2011 · veeyeskay · One Comment
Tags: Document Date, Payables HATB, Posting Date · Posted in: Accounts Payables, Dynamics, Great Plains, Reporting, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 116
SQL Script for Purchase Order Line Items Not Yet Received
Hi all Today, I am posting a script which provides the details of the Purchase Order Line Items which are yet to be received. /****************************************************************** Created June 23, 2011 by Sivakumar Venkataraman – Interdyn AKA This view returns a returns the details of the PO Line which has not been received fully. It provides the [...]
June 23, 2011 · veeyeskay · 4 Comments
Tags: Items Not Received, Line Item Remaining, purchase-order, Qty Canceled, Qty Ordered, Qty Shipped · Posted in: Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 388
SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Budget Tree Node
Hi all This script is in continuation to the previous article where I had posted a script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code. This script is for viewing Budgets vs. Actuals (for amounts) at Budget Tree Node level. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = [...]
June 16, 2011 · veeyeskay · One Comment
Tags: Analytical Accounting Budgets, Budget Tree, Budgets vs. Actuals, Node Level · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 177
SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code
Hi all Today, I am posting a script for analyzing Budgets vs. Actuals (using Amounts) in Analytical Accounting. However, there are two methods of analyzing the budget information in Analytical Accounting. They are: Node Level Dimension Code Level This script is for viewing Budgets vs. Actuals at Dimension Code level. I will be posting the [...]
June 16, 2011 · veeyeskay · 5 Comments
Tags: Analytical Accounting Budgets, Budgets vs. Actuals, Dimension Code Level · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 629
SQL Script for POP Receiving Transactions with AA Information
Hi all My last post had a script for Purchase Orders with AA information. Today, I am posting a script for the following POP transactions with AA information. Shipments Shipment/Invoice Invoice IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POPRcptInformation]‘) ) DROP VIEW [dbo].[vw_POPRcptInformation] GO S Read the rest of this entry
May 20, 2011 · veeyeskay · 3 Comments
Tags: Dimension Codes, Receiving Transaction Entry, shipment/invoice · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 237
Table Structure Definitions – Fiscal Period Setup
Hi all This is the second article that I have decided to post in the table structure definition series. This time, I am going to explain the table structure of the Fiscal Period Setup (SY40100) table in Dynamics GP. The structure of the table is as follows: Column Name SQL Column Name Data Type Length [...]
May 17, 2011 · veeyeskay · 3 Comments
Tags: Fiscal Period Setup, fiscal-periods, SY40100 · Posted in: Dynamics, Fiscal Periods, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 351
Updated SQL Script for fixing Primary Key Errors in Analytical Accounting
Hi all I had posted an article in my blog some time back which updates the indexes in the AAG00102 table to fix the primary keys in analytical accounting. This article can be viewed here. Even though that was useful to update the account indexes in all companies at once to synchronize it, it does [...]
May 15, 2011 · veeyeskay · 5 Comments
Tags: Analytical Accounting, Primary Key Error · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 432
Missing Object Explorer in SQL Server Management Studio
Hi all Today, I faced a strange problem where I could not see the Object Explorer in SQL Server Management Studio. Even if I go to View >> Object Explorer, the object explorer window did not show up. Was wondering what is the cause of the issue and I google’d up to find the [...]
May 12, 2011 · veeyeskay · No Comments
Tags: Object Explorer, Reset Window Layout, SQL Server Management Studio · Posted in: SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 712