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
shuttle from O'Hare Brocton .. Lockport Chicago limo O’HareThe objective for Zandi Digital is to make available clever... Read More
One of the things we can be as certain of... Read More
The vast majority of us will have, at some point,... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
If you have Microsoft Great Plains and support it for... Read More
It is now common thing when large corporation selects mid-market... Read More
The cornerstone of successful automated office systems is the ability... Read More
There are so many different programs that clutter up your... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
If you would like to pick something from Microsoft, or... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Let us give you - developer some hints in the... Read More
To all web designers out there, this article is for... Read More
Usually, the easiest way to tell you have spyware is... Read More
Spyware and malware are large problems for Internet users today... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Buying accounting software is a major investment. It's an important... Read More
Using professional icons in your application or website can bring... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Chicago charter limousine service Hickory Hills ..Shareware is software that you can try before you buy;... Read More
This article is the first of a series of articles... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
OEComplete is a utility for managing the personal information of... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Program Flow is what you think it is. How the... Read More
MS CRM is very close to document workflow automation, including... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
2005 ? Back to the Future.What does the future hold?... Read More
In this article you will find some background information about... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
The US House of Representatives has recently passed the "Spy... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Every day millions of new web documents emerge on the... Read More
Spyware is software or hardware installed on a computer without... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Although statistics often is blamed for various deadly sins --... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Viruses and spyware usually show up on your computer one... Read More
Ok... Where to start?Well, I guess I will start at... Read More
Remember old good days when your company probably had Great... Read More
Software |