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

quick home cleaning Glenview ..
In The News:

Major Marquis fintech breach exposes 400,000-plus Americans' data through unpatched SonicWall vulnerability, with Texas hardest hit at 354,000 affected.
Free up iPhone storage fast by clearing large photos and videos from Messages app. Simple steps for iOS users to delete attachments without losing chats.
Scammers are flooding inboxes with fake tracking alerts that mimic real carriers, exploiting the holiday rush to steal logins and personal data.
The Fox News AI Newsletter brings you the latest news on AI technology advancements and the challenges and opportunities AI presents now and for the future.
Texas family reunites with missing 11-year-old cat Grayson after 103 days using Petco Love Lost's AI photo matching technology and community help.
Tired of AI customer service loops? These insider tricks help you escape "frustration AI" and get real human help when you need it most for urgent issues.
Unlock richer audio from your streaming apps with simple tweaks to volume normalization, equalizer settings, and quality preferences for cleaner sound.
Scammers are sending fake Facebook settlement payout emails that mimic legitimate notices from the privacy settlement administrator to deceive users.
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.

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... 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

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... 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

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Internet Security Threats: Who Can Read Your Email?

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

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

Software Tools To Help Your Business Sell More

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

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

scheduled maid service Winnetka ..