RSSCategory: Analytical Accounting

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

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

Analytical Accounting Information Flow from Purchase Order to Receipts

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

Continue Reading

SQL Script for POP Receiving Transactions with AA Information

| 05/20/2011 | 3 Comments
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   SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON […]

Continue Reading

Updated SQL Script for fixing Primary Key Errors in Analytical Accounting

| 05/15/2011 | 5 Comments
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 […]

Continue Reading