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
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 (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
|
|
|
|
|
|
|
|
You Can Write Microsoft Office Program in About 60 Minutes
Microsoft Office program is a programming tool called Visual Basic... Read More
My Experience - Making a Vision into Reality
Disclaimer: All the thoughts expressed are my views only! Your... Read More
Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist
This is a short article, written in question/answer/FAQ style to... Read More
Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management
Let's first look at your ERP system selection (without Retail... Read More
Computer Based Language Development and Spell-checking
Language development computer: Computer-based method for aiding language development seems... Read More
10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Is Your Family Protected?
When you think... Read More
The Top 5 Wrong Reasons For Not Hiring Testers
Considering whether or not your software company should hire a... Read More
Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP
Enabling Chinese input is quick and easy, there are only... Read More
Microsoft Small Business Manager eCommerce ? Overview
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Partitioning, Formatting and Reinstalling in Windows 98
Formatting and reinstalling windows 98 is very easy if you... Read More
Linux Secrets
The first thing that you will notice about Linux Red... Read More
Microsoft Great Plains: Large Scale Implementation
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Microsoft Great Plains implementation: Restaurants Supply Chain Management Example
Microsoft Great Plains serves majority of US based horizontal and... Read More
What is Shareware?
Shareware is software that you can try before you buy;... Read More
Microsoft Great Plains - Microsoft RMS Integration ? overview
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Professional XP Style Icons in Software and Website Development
Using professional icons in your application or website can bring... Read More
Easy Guide to RAID Recovery
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Understanding Document Management
The term "document management" and "paperless office" is the subject... Read More
Microsoft CRM Customization Secrets ? Second Edition
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Falling in Love With More Than One Screensaver: The Fun Part
Having from five to ten and more favorite screensavers is... 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
Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Microsoft CRM Data Conversion FAQ
Microsoft Business Solutions CRM data conversion deserves FAQ type of... 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 Great Plains BR: Bank Reconciliation
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains as ERP and Microsoft CRM as CRM
If you have Microsoft Great Plains and support it for... Read More
Free Program Removes Spyware not Detected by Premium Security Scan
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM
Midsize business or non-profit organization should decide if one-vendor solution... Read More
eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains
eStore Advantage allows front-office applications to communicate with back-office business... Read More
DB Integration - Software for Combine MS Access Databases
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1
The first topic we are going to discuss... Read More
Fast Car Knoppix
Small can be beautiful! Working with Knoppix for the past... Read More
Microsoft Update - 5 Reasons to Update Service Pack 2
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Five Reasons for Using an O/R Mapping Tool
So, why should you use any O/R mapping tool? I... Read More
Quick Summary of Basic and Common Linux Commands
There are many commands that are used in linux on... Read More
Basic Tips and tricks for Windows XP
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains
We would like first emphasize the change in the paradigm.... Read More
ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Defining OLAP Solutions and Data Warehouse design
This tutorial covers OLAP solutions used by Data warehouses and... 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
Accounts Payable: A Powerful Document Management and Workflow Solution
Accounts payable is just one area of office management where... Read More
Make or Break Factors - When Considering Estimating Software
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Microsoft Great Plains Integration Manager ? Working With Text File
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Razzle Dazzle Them
Once upon a time not so long ago, there was... Read More
Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Destination: Desktop for Google
First we had the original Google search that evolved into... Read More
Software Upgrades Arent Always the Best Move
When my daughter was getting into AOL instant messaging (AIM)... Read More
Microsoft CRM Programming Secrets ? Tips For Developers
This article is for advanced Microsoft CRM SDK C# developers.... Read More
The XP Firewall Isnt Enough
You might think you don't need a firewall... Read More
6 Easy Steps for a Smoother CD/DVD Order
It's all about turn times in the eMedia industry! The... Read More
Healthcare Preventive Maintenance Software
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Cisco CCNA Certification: Becoming A Truly Valuable CCNA.
I've been active in the Cisco Certification track for four... Read More
Why Java RDBMS?
It is a well known fact that Java as a... Read More
Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant
Microsoft Business Solutions Great Plains is very good fit for... Read More
Groupware: Answers the 5 Questions of Document Collaboration
Every organization which creates collaborative documents, whether they are budgets,... Read More
Anti-Virus Software
Anti-virus software is used to find, remove or fix files... Read More
Microsoft CRM: Data Conversion ? Import from Act!
Best Software Act! is very popular CRM for small and... Read More
The Tools and Features of Adobe Photoshop
Adobe Photoshop is one of the world's leading graphics editing... Read More
Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report
This is intermediate level SQL scripting article for DB Administrator,... Read More
Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight
Microsoft Business Solutions Great Plains has many years of successful... Read More
Navision Attain C/ODBC Crystal Report ? Customization Example
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Imagine if Everyone Working In Your Office Was In Synch?
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
Accessing XML Using Java Technologies
The most important benefit of XML is its simplicity. Though... Read More
Software |