Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains Implementation ? Overview for IT Director/Controller > NetSparsh - Viral Content you Love & Share

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

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!

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Minnesota, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (, he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew:

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at


It's time to regulate: The US must make software companies liable for breaches
The software industry has failed to sufficiently protect the public from data theft and misuse. It's time for the U.S. government to get serious about regulation. Last year, multiple U.S. government agencies established guidelines for improved ...


Pivotal Software files for IPO | TechCrunch
The enterprise cloud computing company is majority-owned by Dell, which came about after its merger with EMC in 2016. It was spun off from Dell, EMC and VMware in April 2013. Since then, it raised $1.7 billion in funding from Microsoft, Ford and ...
3 Takeaways From the New Pivotal Software Upcoming IPOFortune
Dell-Backed Software Firm Pivotal Files For IPOForbes
Pivotal Software, majority-owned by Dell, files for IPO with over $500 million in revenue last yearCNBC
Wall Street Journal -MarketWatch
all 24 news articles »


Cloud Software Stocks Rise on M&A Hopes
8, at 6,777.16, young cloud software companies such as MongoDB (ticker: MDB) have soared; its stock is up 46% in that six-week period. Another star, SendGrid (SEND), is up 38%. Both have bested even the strong showings of older cloud computing stars ...

and more »

24/7 Wall St.

Pivotal Software Gears Up for IPO
24/7 Wall St.
Pivotal Software has filed an S-1 form with the U.S. Securities and Exchange Commission (SEC) regarding its initial public offering. No pricing details were given in the filing, although the offering is valued up to $100 million, but this is normally ...


Popular tax software may expose users to phishing attacks
A new report by security research firm Global Cyber Alliance finds that some of the most popular tax software providers may leave consumers at risk for identity theft.

and more »

The Register

UK Court of Appeal settles reseller's question: Is software a good?
The Register
Lady Justice Gloster of the Court of Appeal agreed with CA that "on a proper construction of the language in the regulations, the software did not constitute 'goods' within the meaning of Regulation 2(1)". The software itself was only ever supplied as ...

and more »

Electronic Design

What's All This Software Stuff, Anyhow?
Electronic Design
More bad software comes out of the USA than anywhere else. Think of those old HPGL plotter drivers. Indeed, a recent article in the Atlantic Monthly was titled “The Coming Software Apocalypse.” The URL base-name is equally amusing, “saving-the-world ...

Software helps NY college students track progress toward degree
Nassau Community College is boosting its efforts to increase student retention and on-time graduation through a new software program called DegreeWorks. The web-based auditing software allows students to see what courses they need, what order to take ...


Refreshed iPad and software to be focus of education event, cheaper MacBook reportedly not ready
There's also a chance Apple will unveil a new version of its iBooks Author software to allow teachers to make their own teaching materials, as well as a renewed push to bring textbooks into the digital era. We may also see Apple announce the release ...
Apple to launch low-cost iPad and educational software next week: BloombergBGR India
What to expect at Apple's education eventQuartz
Apple is working on a 'foldable' iPhone for release in 2020, says Bank of AmericaCNBC
Bloomberg -Emojipedia Blog
all 451 news articles »

Business Insider

Snap quietly acquired a British VR and gaming software startup called PlayCanvas
Business Insider
Snapchat's parent company Snap Inc. has acquired PlayCanvas, a British software startup which powers 3D gaming on mobile browsers and social media services. PlayCanvas was founded in 2011, and has built an open-sourced gaming engine that powers casual ...
News – Snap Inc.Snap Inc.
Snapchat's Map Explore feature will let you know when your friends are hanging out without youThe Verge
Introducing two new ways to reach your audience by location and context - Snapchat AdsSnapchat Ads
Tech2 -TechJuice
all 77 news articles »
Google News

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

Three highly respected names in Human Resources have joined forces... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

DBxtra is a powerful query and reporting tool that hides... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Navision Attain C/ODBC Crystal Report ? Customization Example

Microsoft Business Solutions Navision is main ERP application for European,... Read More

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More