|
|
| www.1001TopWords.com |
|
|
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! 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
|
|
|
|
RELATED ARTICLES
Imagine if Everyone Working In Your Office Was In Synch? Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more. Instant Messenger Clients If you have been using the Internet for any amount of time you have probably used an instant messenger at some time or another. They allow you to talk to your friends, family and co-workers with the click of a button. There are many great clients out there, as well as many different networks. Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base. Do You Want Your Own Fully Programmable ERP? - Part 1 We are in a transition phase in the Managerial Administration models of any company or Government, because three factors are summing for that: Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report This is intermediate level SQL scripting article for DB Administrator, Programmer, IT Specialist Bridging the Gap between Paper and Data The cornerstone of successful automated office systems is the ability to convert printed information into electronic data. Document processing applications need to capture and index data accurately and efficiently to bridge that gap. Microsoft CRM and No-Frills Cadillacs In today's business world it's all but impossible to escape Microsoft. Either you're using MS applications, developing your own, or negotiating your company's acquisition by this techno-behemoth. I must that the company is a daily part of my life (in fact I'm typing this article on MS Word). I've found however, that although Microsoft develops many versatile business software products, the company's 'one size-fits-all mentality goes only so far. I'm referring to the Microsoft CRM system. For you lay-people out there, CRM (customer relationship management) systems are designed to help you gather and interpret customer data in order to anticipate future customer purchasing demands and trends. Spyware - The Internet Devil Of Our Times! Spyware and Adware infest over 90 percent of computers in use today. Internet linked computers has made it easy for spybots, adware, and trojans to infiltrate and compromise online privacy. Installed toolbars can also contribute to browser hijacking and spyware related problems. Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant When Great Plains Software introduced the first graphical accounting application for Mac and Windows in the beginning of 1990th it had Great Plains Dexterity customization tool, IDE and programming language. Dexterity design was based on several longevity principles: Graphical platform independence and database platform independence and easy switch from one DB to the other among the most important ones. Dexterity was written as a shell in C programming language, which was "platform independent" and at the same time very efficient in compilation (close to assembler). Since then we saw new tools and options: S is for Spying, Surveillance -- and for Software as Well Words we choose to describe things and phenomena often show our attitude towards what we say. They imperceptibly reflect our opinions and judgments, prejudices and preferences, moral convictions and beliefs. Whether we like it or not, good deal of words we use are biased, or should I say "slanted", --positively or negatively. Two people will call the same thing differently, depending on their points of view. 20 Extra Hours Per Week: What Would You Do? While I was in college, if you would have asked me what I would do if I had an extra 20 hours to spend in a week, the first thing I would have told you is that I would definitely NOT spend it studying. I actually would have gone down a long list of hobbies and activities I would like to do if I had the time. So when my co-workers asked me to find out what owners/managers of sign companies would do if they had an extra 20 hours per week, I was very interested in hearing the responses. What types of activities are sign shop owners doing with their spare time? Was there a common activity or hobby in the sign & graphics industry? Or would I hear several different responses? Recovering Microsoft Great Plains Customization ? Tips for IT Director Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application ? Great Plains Dynamics. And did a lot of customizations to fit your business requirements precisely. You still remember the names of consultants and programmers who did the job and probably the name of the company ? Great Plains reseller in your business metro. This company more likely doesn't exist in the same form ? either closed the doors or merged and transformed to something else. When you tried to contact former programmers ? they more likely nicely let you know that they do not do this any more ? they got completely different job and profession. Great Plains Software was acquired by Microsoft and not part of Microsoft Business Solutions. In old good days Great Plains Software was taking care of popularizing its customization and growing Great Plains Dexterity programming expertise. Nowadays Microsoft Business Solutions has more concerns on merging all its ERP applications: Great Plains, Solomon, Navision, Axapta and making them run together as a set of modules (project Green). Removing Incoming Email in MS Exchange, C# Example The purpose of one of our projects was MS Exchange handler for processing incoming email. Microsoft Great Plains Upgrade ? Things to Consider and FAQ If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE. Who?s Watching What You Type? If someone entered your home, uninvited and installed numerous cameras and listening devices in order to monitor your activities, you would quite rightly be outraged. While such a situation, unless you are living in the Big Brother House, would be considered ridiculous, the same cannot be said for the humble home computer. Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of headaches related to the implementation and on-going care-and-feeding of enterprise based applications is enough make the savviest of companies want to engage in anything but another software implementation. Like a full-blown IRS audit. Anything? Hear It in Digits Music downloads are off the charts! We're listening to digital music in the digital era. Internet Faxing Service Review The Internet is reshaping every form of communications medium, and faxing is no exception. The latest twist: Internet faxing services that let you send messages to any fax machine from any Web browser or email, and others that give you a "personal fax phone number," then forward any documents sent there to your e-mail inbox. XML Parser and Their Types XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. An XML parser is similar to a processor that determines the structure and properties of the data. An XML parser can read a XML document to create an output to generate a display form. There are a number of parsers available and a few of them are listed below: Microsoft Great Plains Integrations ? Retail Management Sample Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. This integration strategy will be the software development direction for this Microsoft subdivision. Meanwhile, as of right now ? we have to recommend just to stake on it and deal with custom or in-house developed integration.
|
| © Athifea Distribution LLC - 2013 |
