Microsoft Business Solutions Great Plains serves multiple industries in the US, plus it has strong presence in Latin America, U.K., Australia, Canada, Middle East, South Africa. Great Plains is natural solution for growing company, when small business accounting application, such as QuickBooks, M.Y.O.B, Peachtree, Quicken or others should be replaced with ERP, better positioned to serve mid-size business. With the switch to Microsoft Great Plains you need to decide on data migration and conversion. Let us give you highlights on your options:
? Beginning Balances approach. This is the simplest way. What you do is ? enter beginning balances in Great Plains General Ledger (GL) and begin using your new system. When you need to enter invoice for existing customer ? you create customer record in Great Plains and go ahead with Invoice in Accounts Receivables or Sales Order Processing (SOP). The same symmetric procedure is for vendor invoices in Purchase Order Processing (POP)
? Master Records migration. If you have large number of customers and vendors, plus multiple addresses for customers, numerous inventory items, sophisticated chart of accounts with several thousand accounts in GL ? you need to migrate these master records from your old accounting to Great Plains. The best way is ? purchase Great Plains Integration manager and do it in-house or with minimal help from external consultant. If Integration Manager license seems to be expensive and you have SQL expertise in your IT group ? you could your programmer populate master tables: GL00100, RM00101, RM00102, PM00200
? Open & Work Data Migration. In Great Plains Accounts Receivables and Accounts Payables invoices have open status if payments are not yet applied to these documents. We recommend you to use integration manager to bring customer and vendor invoices and payments and post them in Great Plains. This way will allow you to save on consulting services and keep good relationship with you Microsoft Business Solutions Partner. We do not recommend using SQL scripts for bringing open data into Great Plains ? you will have posting issues, related to incorrect distributions. In other words do not populate such tables as SOP10100, SOP10200 via direct SQL stored procs.
? Historical Data Migration. We recommend stay away from this migration unless it is absolutely necessary ? you may have order takers needing immediate access to customer historical records to place new order. In this case having two system: legacy accounting for data lookup and Great Plains for new documents ? may not be efficient. Then you do direct historical tables population: SOP30200, SOP30300, etc.
? Data Conversion. Conversion means the process of extracting data from your legacy application and massaging it to be ready to be fed to Great Plains. In case of each specific system you should use specific approach. In case of QuickBooks you simply print reports, save them in text file and massage there ? usually in Excel or Lotus 1-2-3. The specific of small accounting applications is proprietary database platform, which makes traditional tools, such as ODBC connection complicated.
Good luck with conversion and migration 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 Alba Spectrum Technologies ? USA nationwide Microsoft RMS, Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://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: http://www.albaspectrum.com
Culver prom limo ..This article will not attempt to advocate the use of... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
The java programming language is becoming more and more popular... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
What is a Web Database?A web database is a database... Read More
Once upon a time not so long ago, there was... Read More
Crystal Reports is the most flexible tool on the market... Read More
You've finally created databases that you can actually use to... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
I have always regretted how Microsoft price gouges and rips... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Remember old good days when your company probably had Great... Read More
Scrapbooks are very popular these days. I think that almost... Read More
The Internet is reshaping every form of communications medium, and... Read More
It could just be me, but my experiences with document... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
New post-recession era has new features, which didn't exist in... Read More
Although statistics often is blamed for various deadly sins --... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Wood Dale limo ..Mike Dunville* had a decision to make. As the new... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
Adware is a type of Spyware program that displays some... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Linux essentials:It's free for download but you have to pay... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Google Inc. has launched a new software package that allows... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
It is possible that if one avoided all sources of... Read More
Whether you are an experienced web programmer or a complete... Read More
When you double-click a layer in the Layer Palette, you... Read More
IntroductionPHP can be used for a lot of different things,... Read More
There are so many different programs that clutter up your... Read More
Our hosted solution allow you to run your own search... Read More
How to delete the user? This is the first problem... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Background: For many organizations like ours, the interim target of... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
In today's business world it's all but impossible to escape... Read More
Following tips help you to learn a software in lesser... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Software |