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: andrewk@albaspectrum.com
All of us know that Microsoft bought former Great Plains... Read More
Sales are all about leverage, because there is only so... Read More
Microsoft Word is one of the most popular office applications... Read More
In linux, one of great commands for finding out information... Read More
Usually, the easiest way to tell you have spyware is... Read More
We are in a transition phase in the Managerial Administration... Read More
Let's say that you have a software project that's under... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
What is a Web Database?A web database is a database... Read More
The Internet is reshaping every form of communications medium, and... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
When reading an article where some term is used often,... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
Learning how to program software seems like a daunting task... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
To all web designers out there, this article is for... Read More
Need software to record your voice, streaming audio or musical... Read More
After almost two decades of existence, Quark has become the... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
The intentions of this short tutorial are not to teach... Read More
Now is the time to look at an alternative to... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
If you have been running Windows XP for a couple... Read More
We were recently faced with a decision: either to let... Read More
Beginning with Domino version R4 it has integration with the... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
I have recently created my first Php program. I wanted... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Every day millions of new web documents emerge on the... Read More
Whether you are a small consultancy firm, a medium sized... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Today's business world is fast-paced. No matter what it is... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
If you would like to pick something from Microsoft, or... Read More
When it comes to screenplay software each screenwriter needs to... Read More
While I was preparing some personal background information for a... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
The software giants don't do everything and don't always produce... Read More
If you look back to the history, you will see... Read More
It is now common thing when large corporation selects mid-market... Read More
The purpose of one of our projects was MS Exchange... Read More
Domino server is a buffer between the operation system and... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Software |