Dynamics GP 9.0 Service Pack 1

Let the stampede begin. For those of you waiting for the first service pack to upgrade to Dynamics GP 9.0, the first service pack is here. It was actually out last week but I was away for the weekend and didn’t get the post out in time.

Those of you with Customer Source access can download it here.

You Will Be Assimilated

In case there are any lingering doubts about Microsoft’s commitment to their Business Solutions (now Dynamics) line, this announcement from the Dynamics site should put any doubts to rest.

Microsoft Business Solutions Will Be Merged with Microsoft Corporation: Understand Its Impact

Last Modified 5/12/2006Posted 4/7/2006
As part of a continuous effort to simplify and streamline our business, on July 1, 2006, Microsoft Business Solutions will be merged with Microsoft Corporation. With this change in legal structure, you will see some minor changes such as: legal name change, sales tax processing, tax exempt status and payment processing. Please take the appropriate action to make sure the records are updated.

I know there have been a few doubts about Microsoft’s commitment, given the long money losing history of the Dynamics lines but the money poured into the products, into Convergence and finally this should announcement should signal Microsoft’s commitment. It’s a lot tougher to dump divisions that are fully integrated. I also suspect it’s going to be a lot tougher to further your career in Microsoft from Fargo or Finley. The place to be for a Dynamics employee, it Redmond.

Weekly Dynamic: Custom Reminders From a Smartlist in v9

In Dynamics GP 9 you can now create a custom reminder based on Smartlist data. The system comes with a number of preset alerts but if, for example, you wanted to get an alert if a specific customer balance was over $20,000, you can do it. Doing this is easy.

1) Setup your Smartlist
2) Pick Favorites and name the Favorite.
3) Click Add and select Add Favorite and Reminder
4) Select Total of Columns, pick the column and how you want to total
5) You can set reminders based on the number of records or the total of the column
6) Click OK

  • You can setup a reminder for an existing Smartlist by going to Tools >> Setup >> User Preferences >> Reminders button
  • When you delete the Favorite, it deletes the reminder
  • Reminders appear on the Home Page

AICPA Loses Personal Info

I’ve promised to be all Dynamics GP all the time. I’m breaking that promise today for what I think is a good reason. Via the the TaxProf Blog:

“The American Institute of Certified Public Accountants (AICPA), the professional association of CPAs, has sheepishly announced that it has lost a computer file containing the names, addresses, and social security numbers of some its members:”

I’m sure that we have an AICPA member or two in the audience and if you’re a member you may have already gotten a letter, but if you haven’t, here’s your notice.

April’s New Knowldedge Base Articles

April’s additions to the Dynamics GP knowledge base at this link. You will need a customersource login to see them. I notices a lot of Integration Manager additions around SQL Server 2005 and GP 9.0 so make sure to check those out if you are getting ready to upgrade.

Dynamics GP Palettes and Pins

For those of you looking for a little nostalgia in your Dynamics GP implementation, Binary Stream Software is now offering a 3rd party app that will bring back Palettes and Pins to your Dynamics GP install for versions 8.0 and higher. The app is called viewPalettes and you can find out more here. Pricing is not specified on the website, unless you count “low-cost” but if you’re dying for palettes and pins, give them a call.

Weekly Dynamic: Schedule Backups in 9.0

Dynamics GP 9.0 allows you to schedule backups from within the application. You’ll need to be logged in to GP as an administrator and you’ll need to be on the server. Go to File-Backup. Enter the system password if you’ve set one. The backup window opens, pick Schedule.

  1. Name the backup schedule
  2. Pick the database to backup or backup the system databases
  3. Enter the backup path (this must be a path on the local server)
  4. Select the days to backup and the time. The time is entered is in a 24 hour format
  5. Pick how often to delete old backups
  6. Click Save. –SQL Agent MUST be running when you click save–

This process creates a job in the SQL agent with the information entered. You can modify the job throught the GP interface or via SQL to set more advanced options (like notifications). No, I don’t expect DBA’s to be using this, they’ll create their own SQL Jobs, but if you don’t have a dedicated DBA, this is a good start. You’ll still need to move the backups off the server for real protection but that’s easier with today’s portable hard drives. There’s no excuse for not backing up your Dynamics GP installation now.

The American Idol of Dynamics GP

As a reminder, Microsoft Dynamics has a feature survey available until June 30th where you can vote for what features you want in upcoming versions of Dynamics GP. This is the American Idol of Dynamics GP, where you get to vote for the winners, and there’s no Simon, Paula or Randy to deal with. The survey is available at:


It follows the format of previous surveys where you are given a number of points to assign to different features and the features are worth varying points. I can only assume, the higher the points, the harder the feature is to implement.

So go vote! If you don’t vote, you don’t get to whine when your feature isn’t included!

RAID 0+1 and RAID 1+0

This is from an article by Kim Tripp from Saturday, May 13th. I’m reprinting part of it here for all of our SQL DBA’s.

RAID 0+1 and RAID 1+0
“There was a question that came up on this and the question basically asked – which is better. Well, this is a hard question to answer because they both have pro’s and con’s BUT before I get to the pro’s/con’s there’s also another [more important] issue; these two get confused and swapped all the time. In fact, many vendors USED to refer to these interchangeably and even just lumped them together as RAID 10. Today, most people don’t do this and most people also try to refer to the underlying technlogy instead of the numbers. Having said all of that, RAID 1+0 is Striped Mirrors and is my general recommendation because it tends to be more reliable than 0+1 and can tolerate more drive failures than 0+1. RAID 0+1 is Mirrored Stripes – which generally outperforms RAID 1+0 but cannot tolerate the loss of more than one drive and because of that it’s more vulnerable. In the end, I’d suggest a simple “educational” site here (it’s on a commercial site but it has a nice – and short – description of the different types of RAID arrays). “

The whole thing is here and you can find Kim’s blog here along with SQL tips and webcasts. Kim’s my favorite SQL trainer. She’s full of energy and really bright so spend some time on her sight. (I apologize for that last line but I couldn’t resist.)

Dynamics GP 10 Reporting Sneak Peak

From Char Gust of Microsoft via the Dynamics GP Newsgroup, here’s some reporting hints for Dynamics GP 10 due early next year:

“With Dynamics GP 10, we will be adding several new options for getting data out of the system, including pre-defined refreshable Excel reports and about 100 SQL Reporting Services reports. We have prioritized the reports that are highly used, often customized. We hope these new reporting options will alleviate some of the concerns noted here. “