Download Windows Server 2012TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by:
|
There is a smartlist object for AP transactions, but this smartlist does not show the analytical accounting information in it. So in this article, I have decided to post a SQL view to generate a view to show AP transaction information along with the analytical accounting informat
|
(0)
Updated 7/13/2012
Released 7/13/2012
118
Downloads
|
|
|
One of the most common requests which I have come across from customers who have used Analytical Accounting (AA) in Dynamics GP, is that the balances between the GL and AA tables does not reconcile.This script allows us to compare the balances of accounts from both the GL tables
|
(0)
Updated 7/13/2012
Released 7/13/2012
126
Downloads
|
|
|
In this article, I am posting a SQL script which generates the multicurrency period balances at transaction dimension code level. The standard GP’s multicurrency summary table MC00201 provides period balances at GL Account level.The result of this script would tie back to the bal
|
(0)
Updated 7/13/2012
Released 7/13/2012
124
Downloads
|
|
|
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 |
(0)
Updated 7/13/2012
Released 7/13/2012
150
Downloads
|
|
|
I am going to post a script which allows you to analyze budgets vs. actuals for Microsoft Dynamics GP. There is an inquiry window available in Dynamics GP for viewing the budgets vs. actuals analysis. But this has to be inquired account by account and there is no out of the box r
|
(1)
Updated 7/13/2012
Released 7/13/2012
119
Downloads
|
|
|
In this article, I am going to publish a SQL script which will be helpful to many using Analytical Accounting module.I have come across many clients who have multiple companies and they have hundreds of users spread across each of these companies. Assume the case when a new dimen
|
(0)
Updated 7/13/2012
Released 7/13/2012
141
Downloads
|
|
|
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 |
(0)
Updated 7/13/2012
Released 7/13/2012
159
Downloads
|
|
|
This simple script will update the DEX_ROW_TS values in all Dynamics GP tables to the current date and time. This script can be run in both the system database and the company database.
|
(0)
Updated 10/21/2013
Released 10/21/2013
5
Downloads
|
|
|
I had posted an article sometime back titled Macro to provide access to Transaction Dimension Codes to Users where I had provided a SQL script
to create a macro code to provide access to all users to all transaction dimension codes setup in the company.In addition to the above |
(0)
Updated 7/13/2012
Released 7/13/2012
87
Downloads
|
|