Software Information

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 Utilities

  • Workstation 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 Components

What 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


MORE RESOURCES:

Los Angeles Times

Software for supervising students
Los Angeles Times, CA - 3 hours ago
Here's an overview of some of the more popular programs: MealpayPlus: A program from Horizon Software International that lets parents go online to put money ...
Online tools let parents peer into their kids' school day Los Angeles Times
all 3 news articles


Lieberman Software Launches Virtual Server Management Initiative
MarketWatch - 21 hours ago
LOS ANGELES, Sep 04, 2008 (BUSINESS WIRE) -- Lieberman Software's User Manager Pro Suite, a configuration management solution for Windows-powered servers ...
Vendors scramble to rein in virtual environments NetworkWorld.com
Azaleos' OneServer Now Supports Microsoft Hyper-V Server TMCnet
Hyper-V Virtual Monitoring Appliance Debuts at Microsoft Conference WebWire (press release)
MarketWatch
all 23 news articles


Sun to Craft Software Stack Into NAS Appliances
PC World - 10 hours ago
Sun Microsystems will introduce a storage appliance based on its FISHworks software package by the end of this year and later extend the technology to other ...


Roper Industries buys Horizon Software
Bizjournals.com, NC - 15 hours ago
Horizon, based in Duluth, Ga., will continue to market its products and services under its current brand names and will become part of Roper’s radio ...
Roper Acquires Horizon Software, Expands K-12 Business with Food ... Education Channel Partner
Lakewood Ranch company acquires software player Sarasota Herald-Tribune
Roper Industries Acquires Horizon Software International MarketWatch
SunHerald.com
all 14 news articles


Check Point Software Shareholders Approve all Proposals at 2008 ...
MarketWatch - 12 hours ago
Check Point Software Technologies Ltd. ( www.checkpoint.com) is the leader in securing the Internet. Check Point offers total security solutions featuring a ...


Arxan Hosts Complimentary Webinar on Software Protection Best ...
PR Web (press release), WA - 2 hours ago
What application hardening and software protection best practices can be put to use so companies can take back control of their applications and revenues. ...


Schools Consider Software Update
Tampa Tribune, FL - 6 hours ago
By RONNIE BLAIR LAND O' LAKES - The Pasco County School District is considering replacing its outdated computer software with something new that could ...


Software engineering degree coming to SUNY Oswego
NewsChannel 9 WSYR, NY - 6 hours ago
Oswego, New York (WSYR-TV) – Central New York students looking to major in software engineering now have a cheaper, closer option to choose from. ...
Software Added SUNY Oswego
all 2 news articles


American Software Q1 Earnings Drop As Revenues Decline - Update
RTT News, NY - 11 hours ago
Software license revenues were $2.7 million, down 46% from $5.1 million in the prior-year quarter. AMSWA ended Thursday's regular trading at $5.79, ...
MOST E-MAILED RTT News
all 3 news articles


At Deadline Briefs
Computerworld, MA - 5 hours ago
Microsoft Corp. plans to release seven software patches tomorrow as part of its regularly scheduled monthly patch update. Four of the updates will fix bugs ...
Microsoft: Expect four bulletins on Patch Tuesday CNET News
Microsoft readies four patches in end-of-summer update SC Magazine US
Microsoft to release four critical patches NetworkWorld.com
CRN - ZDNet
all 26 news articles

Software - Google News

home | site map
© 2006