RSSCategory: SQL Server 2008

SQL Script for AP-GL Reconciliation – Updated

| 03/07/2012 | 4 Comments
SQL Script for AP-GL Reconciliation – Updated

Hi all Sometime back, I had posted the SQL Script for AP-GL Reconciliation in my blog. At the time of posting the script, it had supported only one account index for AP. Today, I have updated the script to support multiple account indexes for Accounts Payable. Please take a look at the updated script in […]

Continue Reading

SQL Script for AP-GL Reconciliation

| 01/17/2012 | 7 Comments
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 […]

Continue Reading

Post Through GL for Computer Checks – with Analytical Accounting

| 08/04/2011 | 0 Comments
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 […]

Continue Reading

Recent Updates to Payables HATB Script

| 06/30/2011 | 1 Comment
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 update helps the community… Until […]

Continue Reading

SQL Script for Purchase Order Line Items Not Yet Received

| 06/23/2011 | 8 Comments
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 […]

Continue Reading

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Budget Tree Node

| 06/16/2011 | 1 Comment
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 = […]

Continue Reading

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code

| 06/16/2011 | 7 Comments
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 […]

Continue Reading