Archive for the ‘Analytical Accounting’ Category
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
Restricting Dimension Codes to Specific Account Numbers
Hi all In this article, I am going to explain yet another functionality in Analytical Accounting, where we can restrict a dimension code to a specific account number (or) a specific range of accounts. When a dimension code is created, we need to grant access to the dimension codes to specific users who can use [...]
June 20, 2011 · veeyeskay · 2 Comments
Tags: Account Access, Account Restriction, Select Accounts, Transaction Dimension Code Restriction, Transaction Dimension Codes · Posted in: Analytical Accounting, Dynamics, Great Plains Total Views: 218
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
Analytical Accounting Information Flow from Purchase Order to Receipts
Hi all This article is to explain how Analytical Accounting (AA) information is transferred from Purchase Orders to Receiving Transaction Entry. The scenario explained below is on an environment where there is one transaction dimension configured in Analytical Accounting. Create a Purchase Order with 2 line items as explained below. PO Number Line Seq. No [...]
June 2, 2011 · veeyeskay · One Comment
Tags: assigned percentage, purchase-order, receipt, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing Total Views: 310
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
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
SQL View for Purchase Order Details with AA Information
Hi all Based on a request from a community user on my blog, I have decided to post these SQL Views for fetching the purchase order information with analytical accounting information. IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POInformation]‘) ) DROP VIEW [dbo].[vw_POInformation] GO SET ANSI_NULLS ON GO SET QU Read [...]
May 9, 2011 · veeyeskay · One Comment
Tags: Dimension Codes, Purchase Order Processing, purchase-order, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 301
SQL Script to Reconcile GL vs. AA Balances for Accounts Payable
Hi all Some time back, I had posted an article to reconcile between GL and AA tables. This article can be found here. Today I had decided to write up a simple SQL script to reconcile the balances for every account currency combination between the General Ledger tables and the Analytical Accounting tables specifically to [...]
January 17, 2011 · veeyeskay · One Comment
Tags: Account Balances, Accounts Payables, Analytical Accounting, Reconciliation · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 635
SQL View for AA Accounting Class–GL Account Link Information
In this post, I am posting a SQL script for fetching the AA Accounting Class Link for various GL accounts in a company. It also provides us some key information about the accounting class that has been defined in Analytical Accounting. SELECT RTRIM(B.ACTNUMST) AS GPACCOUNTNO, RTRIM(A.ACTDESCR) AS GPACCOUNTDESC, ISNULL(D.aaAccountClass, ”) AS AAACCOUNTINGCLASS, ISNU Read the [...]
January 15, 2011 · veeyeskay · 5 Comments
Tags: AA Accounting Class, Analytical Accounting, Data Entry Rule, Dimension Code, GL Accounts, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005 Total Views: 666