Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

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! [email protected]

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: [email protected]

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Forbes

Move Slow and Make Things: Airtable's Howie Liu Built A $1B Software Giant Emphasizing Substance Over Speed
Forbes
The trio pored over academic papers on collaborative software theory, agonized about the Node.js architecture and obsessed over the speed at which windows popped open. After reading Kenya Hara's design book White, Liu spent months focusing on the ...

and more »

TechCrunch

Apex.AI raises $15.5 million for autonomous-vehicle software
TechCrunch
AI's software stack is designed to easily integrate into existing systems and serve as the enterprise version of the Robot Operating System, an open-source software middleware for robotics. “Most companies have expertise building consumer applications ...


Forbes

We Need Software That Doesn't Panic When Sensors Malfunction
Forbes
Much is still unknown about the crash of Lion Air Flight 610 in Indonesia, but one potential explanation is that a malfunctioning physical sensor caused a software algorithm to incorrectly intervene in a way that the human pilots were neither aware of ...


EFF

The Supreme Court Should Confirm, Again, that Abstract Software Patents Don't Need a Trial to be Proved Invalid
EFF
That has enabled independent software developers and small businesses to fight meritless infringement allegations without taking on the staggering costs and risks of patent litigation. In other words, Alice has made the patent system better at doing ...


TechCrunch

ServiceTitan raises $165M for its home services software, now valued at $1.65B
TechCrunch
ServiceTitan, a startup out of Glendale, Calif. that has built a software platform for home services businesses — in areas like air conditioning, plumbing and electrical repairs — to manage their work, has raised $165 million in what it claims is the ...
Software for Plumbers and Electricians Is a $1.7 Billion BusinessBloomberg

all 17 news articles »

EurekAlert (press release)

Advanced computer technology & software turn species ... - EurekAlert!
EurekAlert (press release)
Representing a group of successful biocontrol agents for various pest fruit flies, a parasitic wasp genus remains overlooked, with its most recent identification key ...

and more »

TechCo (blog)

Best Route Planning Software
TechCo (blog)
Any company with a fleet, no matter how small or large, could benefit from a route planning software. It's the best way by far to accomplish a few essential tasks: It can help managers dispatch vehicles towards multiple locations, it can automatically ...


ZDNet

Robotic process automation software spend set to hit $680m this year
ZDNet
This is an increase of 57 percent year over year; according to Gartner, RPA software spending is on pace to total $2.4 billion in 2022. RPA uses software to understand how people process transactions in an attempt to then use those rules to build an ...

and more »

TechCrunch

'Software robot' startup UiPath expands Series C to $265M at a $3B valuation
TechCrunch
UiPath, a startup that works in the growing area of RPA, or robotic process automation — where AI-based software is used to help businesses run repetitive or mundane back-office tasks, to free up humans to tackle more sophisticated work — has raised ...
Software robot startup UiPath lands funding from Madrona and others, plans Seattle-area expansionGeekWire

all 9 news articles »

Software Cradle Releases scSTREAM, scFLOW v14.1
Ten Links
OSAKA, Japan, Nov 15, 2018 – Software Cradle Co., Ltd., part of MSC Software a Hexagon Company, today announced the latest release of its technology leading CFD (computational fluid dynamics) software scSTREAM v14.1 and scFLOW v14.1. Building ...

Google News

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Adware, What Is It?

Adware is a type of Spyware program that displays some... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

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

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Software Tools To Help Your Business Sell More

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

Microsoft Great Plains ? Licensing & Product Versions

Current Microsoft Business Solutions Great Plains has more that 10... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Spyware Protection: A Must for Any Home Computer

Now that spyware is the single most dangerous threat to... Read More

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More