Happy Thanksgiving to all!!!

Enjoy the holidays and safe driving!!!

Here's the turkey everyone!!!

Microsoft Dynamics GP 9.0 Service Pack 3

Get it in CustomerSource, use this link:
https://mbs.microsoft.com/customersource/support/downloads/
servicepacks/MicrosoftDynamicsGP90ServicePack3.htm

Microsoft Dynamics Announcements

Microsoft extends Dynamics support, promises road maps

Microsoft will offer five years of extended support beyond the five-year mainstream support period for its CRM, ERP, and retail management products. The plan, called Business Ready Customer Care, was first introduced during a keynote speech at Convergence 2007. These means customers won't necessarily be forced to upgrade. The price of the support will vary according to what software the customer has.

Per Barb Edson, senior marketing director for Microsoft's Dynamics products - "We don't want customers to upgrade on our timeline."

GP 11 will be built on Microsoft's next release of its Office suite, called Office 14, Microsoft said. Those products will ship within 90 days of Office 14, which is scheduled for release in 2009, he said. Road maps should be published soon for both of those products.

Microsoft pursues one code base for Dynamics ERP apps
Microsoft is developing a common code base for all of its Dynamics ERP applications, a company executive said Wednesday, Oct24. That will allow Microsoft to release new versions of the software more quickly, and make it easier for customers to switch from one application to another, according to Kirill Tatarinov, vice president of Microsoft Business Solutions.

Having one code base will allow applications to share the same user interface and controls, such as now are shared between AX and NAV, Tatarinov said. The code base will also encompass database functions, APIs, business intelligence capabilities, and communications technologies that enable VoIP and instant messaging, he said.

Using DISTINCT in Select Statement

When you use DISTINCT in a Select statement, you are saying that you only want one row in the result set for each distinct set of values. The result set will not have any two rows that have the same values in every column.

Let's say in table SOP30300, you have the following data:
INV001 Items: ABC, DEF, GHI
INV002 Items: DEF, JKL, MNO
INV003 Items: MNO

Then you run this statement:
SELECT DISTINCT itemnmbr
FROM dbo.SOP30300

The result set should be:
ABC,DEF,GHI,JKL,MNO

2007 Microsoft® MVP Award

Got this last night:

"Congratulations! We are pleased to present you with the 2007
Microsoft® MVP Award!

The Microsoft MVP Award is our way of saying thank you and to honor and
support the significant contributions you make to communities
worldwide. As a recipient of Microsoft's™ Most Valuable Professional award,
you join an elite group of technical community leaders from around the
world who foster the free and objective exchange of knowledge by actively
sharing your real world expertise with users and Microsoft.  Microsoft
salutes all MVPs for promoting the spirit of community and enhancing
peoples lives and the industrys success everyday."

Thank you Microsoft for believing in my capability and rest assure that I’ll be extending my
hands more to the community this year.  

How to setup your role in Great Plains 9.0

The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job displayed on your home page. When you select a user role that is similar to your job responsibilities, the information that is displayed on your home page will be set up for you to use right away. Reminders, Reports, SmartList favorites, and Metrics that you might use daily will be displayed on your home page, and default settings for each of the five areas of your home page will be applied. Click the Customize this page link to open the Customize Home Page window.

Once the Customize Home Page window is open click on the Change Role button.

Choose OK

Select an industry and a role that best describes the work that you do so that information specific to your job will be displayed on your home page. For each role, there are unique default settings for the content areas on your home page. For example, if you select the Accounting Manager role, reminders for recurring General Ledger batches will be displayed in the To Do area of your home page, and you will have quick links set up for windows that you would use frequently, such as the Master Posting window, Summary Inquiry window, and the Checkbook Balance Inquiry window. Look on the left-side of the Select Home Page window to get some information on the tasks for the role you’ve chosen. Click OK once you’ve selected your role.

2007 Predictions

2007 Predictions

	My Crystal Ball Says
	Less Time Spent On	More Time Spent On
	SARBOX	XBRL
	Storage Area Network (SAN)	Blade Servers
	Researching Service Oriented Architecture (SOA)	Implementing SOA
	Oracle, SAP, Microsoft and others acquisitions	Making it work as planned