May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Recent Posts

Archives

Great Plains

Page 9 of 22« First...567891011121314...20...Last »

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

Published 06/16/2011 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , | 7 Comments

Analytical Accounting Information Flow from Purchase Order to Receipts

Published 06/02/2011 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing | Tagged , , , | 1 Comment

SQL Script for POP Receiving Transactions with AA Information

Published 05/20/2011 | By veeyeskay

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.

  1. Shipments
  2. Shipment/Invoice
  3. Invoice 
IF EXISTS ( SELECT  *
            FROM    sys.views… Continue reading →
Posted in Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , | 3 Comments

Dynamics GP Technical Database Guides – GP 10

Published 05/18/2011 | By veeyeskay

Hi all

In this article, I have posted the link of a detailed database reference guide for Microsoft Dynamics GP 10.

I have posted the link to the guide for the system database (DYNAMICS) and the sample company (TWO) database.  … Continue reading →

Posted in Documentation, Dynamics, Great Plains, SQL Server, SQL Server 2005 | Tagged , , | 2 Comments

Table Structure Definitions – Fiscal Period Setup

Published 05/17/2011 | By veeyeskay

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… Continue reading →

Posted in Dynamics, Fiscal Periods, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , | 3 Comments

Updated SQL Script for fixing Primary Key Errors in Analytical Accounting

Published 05/15/2011 | By veeyeskay

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… Continue reading →

Posted in Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , | 5 Comments

SQL View for Purchase Order Details with AA Information

Published 05/09/2011 | By veeyeskay

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… Continue reading →
Posted in Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , , | 1 Comment
Page 9 of 22« First...567891011121314...20...Last »

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.