While reading in one of the application manuals, I found an interesting questions that we all must consider having its answers before calling the support specialist, it would be great if you could include those questions answers in your question posting to get a best reply:

 

“  Before you call support

If you are experiencing a problem when installing Microsoft Dynamics GP, have answers ready to the following questions to help your support specialist narrow down the source of the problem you’ve experiencing.

• What is the exact error…

After you load GP 10 you will notice a little extra item has loaded. That extra item is called the Database Mantenance Utility. I've been asked many times of late as to what it does and why we should care. Here goes. When the databases are created by GP several other…

Below are a list of the frequently used entries on Dynamics GP

Migrating Logins (here and he…

How big is your Dynamics GP database? Well there's a couple of ways to find out and if you don't want to do a lot of right clicking in SQL Server Management Studio run the SQL Stored procedure sp_SpaceUsed as:

EXEC sp_spaceused @updateusage = true

This will return the space used by whatever DB you run it against. The @updateusage=true updates statistics first to ensure that the sizes are correct.

If you want the space used by a particular table, run the stored proc as:

EXEC sp_spaceused 'PM00200', @updateusage = true

substituting your own table for PM00200.

If you want to see the usage for…

How many times have you performed an upgrade just to realize with the first posting that some stored procedure is missing or did not -- for some misterious reason -- get created, yet the upgrade completed with no errors? This is especially true when upgrading from several versions aback, when the upgrade path is not too clear, or you have forgotten to apply that critical service pack that would avoided some of the missing objects issues you are now experiencing.

I recently came across a user who wanted to recreate all SmartList Builder objects because they suspected something was wrong with the installation, however, they did not want to have to use the backend to recreate all the stored procs used by SLB, because of the "fair of missing something or endup damaging something else"... you know what they say... the client is always right! (not always, but that's the topic of another article).

After scratching my head for a few moments, the answer came in the form of the new Microsoft Dynamics GP Database Maintenance Utility, but first some history...

Before there was the SQL Maintenance utility, back in the old days, the former Great Plains Software provided reams of text files…

From time to time I want to disable some functionality in GP in order to make a demo more streamlined (e.g. disable Analytical Accounting) or to test some functionality without a specific product in the system. 

For example, I was recently testing the…

Just recently on the Dynamics GP Partner forum, my friend Japheth Nolt reported that some workstations at one of his clients would not display the warning dialog "It's 12:00 a.m. Would you like the user date to change to ...?" after the system clock crossed the 11:59:59 PM barrier, and that this issue would cause some users to enter transactions with the wrong date. After all, transaction windows in GP default with the user date, not the system date.


Japheth had already inspected the DEX.INI looking for the SuppressChangeDateDialog, making sure the key was not set to True. This setting prevents the user date rollover message from being…