Interesting Findings & Knowledge Sharing
Scribblings of a Microsoft Dynamics GP MVP
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,… Continue reading
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… Continue reading
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… Continue reading
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… Continue reading
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… Continue reading
Dynamics GP Technical Database Guides – GP 10
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
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… Continue reading