Go To Software Information Home
Microsoft Great Plains Installation ? Overview for IT Director/Controller
Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0 What is installation in the language of technology? Installation has server and client sides. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. All these tasks are performed by Microsoft Great Plains UtilitiesWorkstation side - workstation installation copies the client side application, installs current version of MDAC (we need SQL ODBC driver - please check documentation on ODBC DSN setup), registers the application. If you plan to run Great Plains Utilities from the workstation to create server side (see above) - you need to check Install Client and Server ComponentsWhat is following implementation? Implementation requires combination of technological and accounting skills - System Setup - you should refer to GP documentation. In general setup consists of Company information, General GL/AR/AP/Payroll setup, User classes, Customer/Vendor/Employee classes to name a few
- Master Records - you should either use integration tools, such as Integration Manager, SQL queries or have users to type in all your GL Accounts, Customers, Vendors, Employees .
- Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances in Great Plains GL, AR, AP, SOP, POP, Payroll. When you have balances in the system you are ready to use it in production
- Historical Data conversion - this is optional, in order to do historical data conversion you need to know basic Great Plains tables structure (Setup->Tools->Resource Description->Tables Structure). This is similar to surgery - so you probably need outside consultant to help you. If the volume of historical data is small - you can deploy Great Plains Integration Manager and then post the records in the modules.
- User Training - we are just listing this item - it is up to you to decide on the way to train your users
- Using Two Systems in Parallel - this is recommended. You should print the reports from both systems during this test period and compare the results
- Customization - typical areas of customizations: Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages
Do I need consultant? We strongly recommend you to use consultant in the following cases - You have identified the need for Great Plains Dexterity customization
- You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
- You are doing migration from Great Plains Accounting to Microsoft Great Plains
- You have to create a lot or ReportWriter Modified Great Plains Reports
- You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
- Your Great Plains has more than 20 users in this case the mistake may lead to serious business problems
- You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade
Good luck with installation, implementation, upgrade and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Minnesota, Texas, Florida, New York, Washington, Georgia, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com; akarasev@albaspectrum.com
|
 |
|
|
RELATED ARTICLES
Groupware: Answers the 5 Questions of Document Collaboration
Every organization which creates collaborative documents, whether they are budgets, presentations, reports, spreadsheets, or other documents recognizes that collaborative efforts are requirement. That collaboration always forces the 5 eternal document collaboration questions: Who? What? Where? When? How? The reason I refer to them as eternal is that every day businesses are faced with these questions and rarely find the answers when they collaborate on documents.
Groupware: What Works the Way Businesses Do?
Groupware
Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer
If you are software developer or database administrator - we would like to give you the clues on Crystal Report creation for Microsoft RMS
IBM Lotus Domino or Microsoft Exchange?
IBM Lotus Domino or Microsoft Exchange?
Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO
Microsoft Business Solutions Great Plains as new ERP for multinational corporation manufacturing facility in Brazil.
Algebra Help Software
Need help making sense of algebra? Have algebra lectures in your classroom left you scratching your head and wondering: "How on earth did they get that answer"? Do not despair, because help is at hand. AlgebraSolver from Softmath can make all the pieces of the algebra puzzle fall into place, improving your grasp of the subject with step-by-step problem solving that demonstrates exactly how a solution has been reached.
Microsoft Great Plains & CRM in Transportation & Logistics ? Overview
Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company. Having more material, we would like to share with you how you can leverage Microsoft Business Solutions products to automate your business. We'll try to be both technical and business processes specific and be laconic to comply the rules of tiny article.
IT Department Skills to Support Microsoft Great Plains and Microsoft CRM
Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support.
Let us give you the directions, based on our research and consulting practice.
Microsoft SQL Server Specialist ? we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios. On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database. The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support.
Network Administrator with good Microsoft Exchange and Active Directory skills. Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here. In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology. In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet.
C# or VB.Net programmer with excellent SQL Skills? if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support. Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored.
Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs. This position maybe merged with one of the above.
These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person. In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner.
Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative. This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented. If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577! help@albaspectrum.com
Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur
I started using PIP (Picture It Publishing) Platinum 2002 right after I got it in a bundle with my HP Pavallion N5295 Notebook more than several moons ago!
MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains
If you look back to the history, you will see that ERP for large publicly traded company had to be built upon very reliable hardware (more likely non-Intel hardware: mainframe, Sun sparc, etc.), powerful database platform: Oracle, DB2, Ingress, Sybase and reliable OS: UNIX. 10 years ago Microsoft had Windows NT first tries, plus Windows 95 was kind of revolution, but not the one to stake on for corporate users. Nowadays hardware (from Intel side), Windows 2003 Server Enterprise Edition, WindowsXP Pro, and Microsoft SQL Server could be considered reasonably reliable plus it is certainly easier to support these products, because of the large pool of Microsoft-oriented IT professionals available Worldwide. Microsoft Business Solutions offers several lines of ERP systems: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta. We don't want to state here that in the future Microsoft will be only ERP systems provider, but it certainly is and will be one of the major players on the ERP/MRP market. In this small article we'll consider the ways to implement large corporation required features in Microsoft Great Plains.
The Top 5 Wrong Reasons For Not Hiring Testers
Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.
Microsoft Great Plains implementation: Restaurants Supply Chain Management Example
Microsoft Great Plains serves majority of US based horizontal and vertical markets. Being relatively flexible and customizable ? it can fit your specific business requirements with light or deep customization. You can have portion of the system customization done by your in-house developers (such tools as Modifier with VBA, MS SQL Server stored procedures, Crystal Reports do not require unique expertise) and the most critical and difficult part could be subcontracted ? especially Great Plains Dexterity. In this small article we would like to give you good example of customization scenarios, where client needs warehouse management, random weight purchasing and by-pond resale to end clients, barcoding.
Spyware Definitions List
The adware and spyware definitions list is very long. But the definitions listed below are the most common ones. This is a glossary of spyware facts and terms so you'll know what these malicious programs are and what they can do to your computer.
Unofficial Windows 98 SE Service Pack 2.0 RC2
Microsoft has never released a service pack for Windows98 SE, but I made a Service Pack for Windows98 SE users.
Start Developing Your Own Software
Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. If it were, the majority of nerds wouldn't be doing it because the defining factor of our kind is an inherent laziness. Why do you think we like computers? The heaviest thing we have to lift is a monitor and that's done fairly irregularly and for a very short period of time.
Outlook... Not Just for Email! Using Your Outlook Calendar
Microsoft Outlook is one of the most widely used software programs for email, but if you're only using it for email, you're missing out on a great productivity tool! This month's column looks at a few ways you can use the Outlook calendar to make scheduling easier.
Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains
We would like first emphasize the change in the paradigm. If you look back ? 20 years or even 10 years ? those days you saw ERP/MRP monster applications/systems winning time. Everyone wanted to be looking large and, especially due to traditional business consulting sales efforts ERP applications were sold to large and mid-size clientele. The proposed strategy was: you need three components:
Business Plan Software Review: Ultimate Business Planner?
One of the main reasons business owners and entrepreneurs use business plan software is to simplify building their financial models. Even with an explosion in business plan software packages on the market today, "doing the financial projections" is still often cited as the most difficult part of completing a business plan. Yet, software can still simplify financial forecasting.
Separate Anti-Keylogging Protection: Who Needs it Most?
If there still are few unprotected computers left, I haven't seen any.
Every emerging threat causes means of defense to appear. Anti-viruses
and firewalls were the first. Now most computers have also an anti-spy
program installed. More and more often experts say that some computers
need autonomous anti-keylogging protection as well.
Databases ? How We Love to Hate Them!
You've finally created databases that you can actually use to
store and manipulate all your critical data. That's great news
and quite an accomplishment. But in your rush to get your
employees to start entering information into these databases, you
skipped the training process and let them go at it alone.
|