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
Bradley bmw rental chicago .. Lockport Chicago limo O’HareThe destruction of the Soviet Union about 15 years ago,... Read More
Should one use Windows Update?This topic has good and valid... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
New post-recession era has new features, which didn't exist in... Read More
All of us know that Microsoft bought former Great Plains... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
In this small article we will show you the possible... Read More
If you look back to the history, you will see... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
The various resume software offered, particularly on the internet, can... Read More
The fact that a software tester is a most infamous... Read More
The software giants don't do everything and don't always produce... Read More
Beginning with Domino version R4 it has integration with the... Read More
I have always had a tendency to focus on the... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Although statistics often is blamed for various deadly sins --... Read More
When Windows fails to boot it is normally caused by... Read More
There are so many different programs that clutter up your... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Fundraising software lets you connect with donors in a way... Read More
prom limo McHenry ..Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
One of the things we can be as certain of... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
You turn on your computer, and it doesn't look quite... Read More
What is Software?Software is a set of instruction written to... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Fundraising software lets you connect with donors in a way... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
When you own a small business, time is money. And... Read More
Most people understand that the "hardware" part of their computer... Read More
We would like to give you pluses and minuses of... Read More
Finally, you have some time to personalize your desktop with... Read More
How would you like to prevent spyware and adware from... Read More
Icons are used everywhere; right from software applications, to internet... Read More
If you are in a business that passes documents around... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
When you need a phone number, you do a quick... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Some companies that are in need of fleet management may... Read More
Software |