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! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in help@albaspectrum.com ? 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 (help@albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: help@albaspectrum.com

affordable house cleaning Park Ridge ..
In The News:

Holiday shopping scams surge as fake refund emails target distracted consumers during Black Friday and holiday seasons, costing Americans billions annually.
The AI-powered IRMO M1 exoskeleton features four modes, including turbo, eco, training and rest for hiking, running, cycling and sports with eight-hour battery life.
OpenAI announced upgrades for its ChatGPT Images platform on Tuesday, saying the program can now make more precise edits and produce images more quickly.
Chrome for Android now turns web articles into AI-powered podcast conversations. Get hands-free browsing with Google Gemini's natural audio summaries.
LastPass faces $1.6 million fine from U.K. regulators after 2022 data breach exposed 1.6 million users. Password manager failed proper security controls.
Petco disclosed a data breach exposing customer Social Security numbers, financial account details, and driver's license information due to a software error.
Baseball teams can now analyze complete swing mechanics in normal training environments using Theia's markerless AI system that processes standard high-speed footage.
Smart home hacking fears overblown? Expert reveals real cybersecurity risks and simple protection tips to keep your connected devices safe from hackers.
MIT develops needle-free glucose monitor using light technology. Revolutionary device could replace painful finger pricks for diabetes management.
The ClickFix campaign disguises malware as legitimate Windows updates, using steganography to hide shellcode in PNG files and bypass security detection systems.
Researchers from Osaka Metropolitan University designed a 21-foot dome that combines aquaculture and hydroponics to create a self-sustaining urban food system.
The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.
Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.
Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.
Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.
Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.
Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.
Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.
Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.
Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.
New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.
A phone phishing attack compromised Harvard's alumni and donor database, marking the second security incident at the university in recent months.
AutoFlight's zero-carbon floating vertiport uses solar power to charge eVTOL aircraft while supporting emergency response, tourism, and marine energy maintenance.
A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.

How to Make Own CMS

Every day millions of new web documents emerge on the... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Reporting Tools for Microsoft Great Plains ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Hear It in Digits

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

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Microsoft CRM Data Conversion FAQ

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

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Microsoft Great Plains RW: Report Writer

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

affordable house cleaning Mundelein ..