Page 1 of 3123

Archive for February, 2010

The Dynamics GP Blogster: SQL – Autogenarating Customer IDs

The Dynamics GP Blogster. “Your Microsoft Dynamics GP world without barriers” Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/. Posted by Mariano Gomez at 10:33 AM.

Read this article:
The Dynamics GP Blogster: SQL – Autogenarating Customer IDs

February 28, 2010 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 87

High Page Rank dofollow Blogs Lists: Other Werbsites with Page …

1988496, dynamicsblogger.com, 3537988, 0, 0, Mon 21st Dec, 2009. 1988497 …… 1988941, rss-feeds-submission.com, 68513, 4, 0, Wed 18th Nov, 2009. 1988942 …… The feed providing these headlines is not available.

Continue reading here:
High Page Rank dofollow Blogs Lists: Other Werbsites with Page …

February 25, 2010 · Ideal Softs · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 97

The Dynamics GP Blogster: Microsoft Dynamics GP 2010 – Service …

The Dynamics GP Blogster. “Your Microsoft Dynamics GP world without barriers” MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/. Posted by Mariano Gomez at 9:15 PM.

View article:
The Dynamics GP Blogster: Microsoft Dynamics GP 2010 – Service …

February 17, 2010 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 82

Support Debugging Tool Build 12 released – Developing for …

10-Oct-2008: First Post by Scott Stephenson. 04-Nov-2008: First Post by Dave Dusek. 28-May-2010: Created Facebook account with blog feed. 15-Aug-2011: First Post by Development team. …. MBS Guru (Michael Johnson’s Blog) …. Fixed Default Path for three logging facilities to use dex.ini path if specified. Fixed issue where file dialogs were …. from DynamicAccounting.net. http://msdynamicsgp.blogspot.com/2010/02/support-debugging-tool-12-release-for.html

Read More:
Support Debugging Tool Build 12 released – Developing for …

February 17, 2010 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 137

GPtip42day – Track User Inactivity – GP2TheMAX – Blogger

GP2TheMAX – Helping users get the ‘MAX’ from Dynamics GP Post a Comment Post Home. Subscribe to: Post Comments (Atom). GP2TheMax Headroom. GP2TheMax Headroom …. Dynamics Confessions Blogspot.

More:
GPtip42day – Track User Inactivity – GP2TheMAX – Blogger

February 16, 2010 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 63

SQL view with AR apply detail | Victoria Yudin

Created on Feb 15, 2010 by Victoria Yudin – Flexible Solutions, Inc. For updates visit http://victoriayudin.com/gp-reports/ Returns apply detail for all posted receivables transactions. Only shows functional currency amounts.

Original post:
SQL view with AR apply detail | Victoria Yudin

February 15, 2010 · Victoria Yudin · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 246

Analysis Cubes for Microsoft Dynamics GP (on SQL Server 2008)

Folks

In this article, I am planning to give some quick insight into common configuration problems that you might face when installing and  configuring Analysis Cubes for Microsoft Dynamics GP on SQL Server 2008.

Before we begin, make sure you have SQL Server 2008 Analysis Services installed and the service is up and running before we begin to configure the product. Also make sure you install Analysis Cubes For Microsoft Dynamics GP Service Pack 3 (which is what is compatible with SQL Server 2008). You can download the SP3 for Analysis Cubes from

https://mbs.microsoft.com/fileexchange/downloadfile.aspx?fileid=6cd0d6d5-3575-4eda-a6a2-760791c1325b

Once we make sure that we have the analysis services installed and running, when we try to configure the Analysis Cubes using the configuration wizard and I am sure many of you would have faced the error that I received as well, as shown below.

Analysis Services Error

After quite a bit of searching, I decided to go through the Installation and Configuration checklist for Analysis Cubes (which I should have ideally done before beginning the configuration). :-)

On reading the manuals I came across a note which said the windows user who is configuring the Analysis Cubes, have to be added to the following windows groups as explained below.

Server Computer Windows Groups
Microsoft Dynamics GP server computer Administrators

SQL Server computer for Microsoft
Dynamics GP company databases

All versions of SQL Server: Administrators
SQL Server 2000: SQLServer2000MSSQLUser
SQL Server 2005: SQLServer2005MSSQLUser
SQL Server 2008: SQLServerMSSQLUser

Data warehouse database server
computer (with Integration Services
installed)

All versions of SQL Server: Administrators
SQL Server 2005: SQLServer2005MSSQLUser and
SQLServer2005DTSUser
SQL Server 2008: SQLServerMSSQLUser and
SQLServerDTSUser

SQL Server Analysis Services computer

All versions of SQL Server: Administrators
SQL Server 2005: SQLServer2005MSOLAPUser
SQL Server 2008: SQLServerMSOLAPUser

Once I made sure the windows user, with which I was trying to configure the analysis cubes, was mapped to the proper windows groups, I tried to configure the analysis cubes, and it worked fine.

Tip: If you are trying to configure the server component on a Vista machine, run the configuration wizard as as administrator. To do that go to C:\Program Files\Microsoft Dynamics\Analysis Cubes for Microsoft Dynamics GP Server and right click on the Microsoft.Dynamics.GP.AnalysisCubes.ConfigurationWizard2008.exe and choose Run as Administrator option.

I am sure this tip would be helpful for many who are trying to install and configure analysis cubes for Microsoft Dynamics GP, especially on SQL Server 2008.

Until next post…

February 14, 2010 · veeyeskay · No Comments
Posted in: Analysis Cubes, Dynamics, Great Plains Total Views: 3,899