Microsoft Great Plains Implementation Faq: Financial Setup, Conversion, User Training

Microsoft Dynamics GP ERP implementation process is similar to other mid-market accounting and MRP products: GP partner selection and sales cycle, business processes mapping, customization design if required, reports. Then you go to the actions: Microsoft Dynamics GP software licenses purchase, GP installation, initial data conversion and beginning balances, business specific users training. If your company is large business, you may consider switching GP for one or several business entities as a pilot project with the plan to turn all your departments and units to Microsoft Great Plains in the short future. We will not be covering business processes mapping scenarios in this small article and will try to give you technical side of the implementation

1. Great Plains Installation. You should plan for appropriate Server hardware, SQL Server 2005 installation (including planning for data and log files separation on different drives). Then you go ahead with GP server installation – we certainly understand and confirm, that GP Utilities installation Wizard is very intuitive, however, GP is not small business accounting application, so it is powerful and at the same time sensitive to options chosen. This is why we strongly recommend you to invite GP consultant to do installation and overall implementation job

2. Data Migration. The best approach is to leave old ERP data in your old system and make fresh start in Microsoft Dynamics GP. If this is not possible, then consider migrating Chart of Accounts, Customers, Vendors, Employees, and entering beginning GL balances (this last step manually). This recommended data migration should be done via GP Integration Manager, as it validates Great Plains Dynamics business logic and doesn’t allow data inconsistency.

3. GP Modules Setup. Each module: General Ledger, Inventory Control, Sales Order Processing, Receivables Management, Payables Management, Payroll and others requires opening setup screen and coming through the required fields setup there. One of the most important setup decisions is Posting Accounts setup – this is done on the company setup level

4. User Training. First of all – you should be aware that Microsoft is in the process of synchronizing its ERP applications user interface with the one in Microsoft Office and Microsoft Outlook – meaning that if your users are very good and intuitive with Microsoft Office products, they should be ready to do GP discovery. Saying this, we have to admit that GP user training is needed, as MS Office interface unification, leading to users intuition is just the top level

5. Frequently Asked Questions. Software Licenses – you can purchase these from MBS partners only. To get new user licenses or modules – you will need to be enrolled in Microsoft Dynamics GP annual enhancement program. Migration from old versions: 5.5, 6.0, 7.0, 7.5 – if you are on Pervasive SQL or Ctree, then you need migration tool, please contact your MBS partner. Version upgrade – current version is 10.0 and one-step migration path exists for 8.0 SP5 and 9.0 SP2

6. Reporting. You can consider industry tools, such as Crystal Reports, Microsoft SQL Server Reporting Services (SRS), MS Excel, or even Microsoft Access Reports, if you are comfortable with Access. Very important reporting hint – consider creating report logic in MS SQL Server stored procedure or view and not expect the magic from reporting tool Wizard.

7. Beyond the generic implementation. Customization – please review eConnect, Microsoft Dexterity, GP SDK, SQL Stored Procedures, Modifier with VBA. Integration – please start with Integration Manager, then think about eConnect programming, SQL direct scripting. EDI or Electronic Document Interchange – this is popular SQL scripting routine, it is often resolved via XML feed. If you represent lager corporate entity and need major integration project, we will be happy to help you.

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale

Delighting your User, Part Four: Showing and Maintaining Competence

Copyright (c) 2007 Don R. Crawley

Competence means providing correct, knowledgeable service, performed with accuracy and confidence.

Competence is a two-part process. You must demonstrate competence in the way you do your job, but you must also find ways to maintain your technical competence.

Demonstrating Competence

Here are a couple of good techniques to use to demonstrate your competence.

Tell the user what you are going to do before you do it. This technique is called headlining, in the sense that a newspaper article’s headline tells you what you are going to read before you read it. As a user, it is very frustrating to be dealing with a technical support provider who does not tell you what he or she is doing. When there is silence on the phone, the user may be confused, and this does not assure the user of your competence. You know you have not done a good job of headlining if, after a period of silence, your user says, “Are you still there?” The user does not feel cared for if she has to guess if you are still on the line.

Headlining is the mark of a professional Help Desk provider. It is easy and quick to do, and creates a high degree of end-user satisfaction. Use headlining when you need to take a moment to look up some information in the database. You can say, “It will take me just a minute to look that up in the database.” This gives the user the assurance that you are working on their behalf.

Another way of providing assurance to users is to build their confidence in your ability to help them. This can be done with a solution statement delivered once you understand and have confirmed the user’s problem. A solution statement simply tells the user that you can help them solve the problem. You can say, “From what you have told me, I know how to solve the problem.”

Maintaining Technical Competence

Our world in Information Systems and Technology evolves so quickly that maintaining technical competence can seem overwhelming at times. Here are four keys to maintaining your technical competence:

Be curious. Curious people are always exploring. When you’re curious, life is more interesting and you find new ways of doing things, you find things you didn’t even know existed, and you maintain a childlike sense of wonder and awe.

Read…a lot. The fact that you’re reading this article speaks highly of you. It’s not that you’re reading this particular article (as much as your author wants to believe that!), but that you’re reading any article about how to do your job better that speaks so highly of you. There are thousands, perhaps millions, of blogs and forums on the Web dealing with the same technologies you support. Microsoft and most other vendors provide extensive support documentation at their sites. Microsoft even has free hands-on labs and how-to guides. Get one of the O’Reilly Cookbooks for the technology you support and work through recipes that are most interesting to you.

Build a sandbox. I first heard of an IT “sandbox” when I was working with some individuals from Kimberly-Clark Corporation in a PKI training session. The IT “sandbox” is another name for a testing lab where you can experiment without worrying about system failure. Today, it’s often not necessary to set up a physical lab with multiple physical computers. Instead, you can use tools like VMWare, Virtual PC, or Xen to create a virtualized lab environment in which you can test and experiment to your heart’s content without worrying about affecting end-users. Some virtualization products are available for free; others at very low cost. (I use VMWare Workstation.) Use Google to learn more about virtualization and the vendors who create virtualization products.

Get trained! As a training provider to the IT world, you’d certainly expect me to make this recommendation, but it’s important. Training, whether in a college classroom, a seminar environment, in a workshop, or at a conference exposes you to new ways of doing things and thinking about things. Electronic delivery of training can be an excellent solution, but participating in in-person classes allows you to interact with the instructor and the other students. It’s through such interaction that you discover new concepts and new solutions to old problems. I discovered when I returned to college that just being in an educational environment got me thinking in new and positive ways. Additionally, great teachers and trainers challenge you and help you step outside your comfort zone which is how you affect positive change in your career and in your life.

Being great at your job isn’t necessarily easy, but it’s immensely rewarding in terms of personal satisfaction, career options, and financial rewards.

Next week, we’ll talk about empathy and its importance as part of the tech support process.

Don R. Crawley is president and chief technologist at soundtraining.net, the Seattle training firm specializing in business skills and technical training programs for IT professionals. He works with I.T. pros to enhance their work, lives, and careers. For Don’s article, “Ten Ways to Delight Your End-User”, click here.