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
|
|
|
Lotus Domino: Reports And Connectors ? Crystal Reports, Xml, Odbc/jdbc, Ole
Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. For example some documents should be sent to your suppliers or customer in paper form. Lotus Notes (as a client) has built-in tools for printing documents, views and folders. Bu...(related: Software)
Microsoft Great Plains - Typical Problems And Fixes ? Overview For It Administrators
How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:
- Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'.
- Pervasive SQL/Ctree - if you have more than one user regis...(related: Software)
Erp Software Financing: The Future? ? Overview For Company Owner
In our case ? we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these pro...(related: Software)
Ukraine: A Prospective Player On The World Software Outsourcing Market
The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too. There are several prerequisites for this.PrerequisitesTraditionally, Ukraine always was a technical region of the USSR. No wonder, the IT education was and still is one of the most popular and respective education in the region. Such well-known Ukrainian universities as Kyiv National Technical University, Donetsk National Technical University etc. as well as new establishments with more innovative approach for IT specialists education, such as Donetsk State Institute of Artificial Intelligence and others, educate a new prospective generation of youn...(related: Software)
Create Asp In Minutes
DBxtra goes ASPGetting to the information hidden within corporate databases has always been a problem for all levels of an organization.IT shops are const...(related: Software)
Cosmic: A Small Improvement On The Symons Method
The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual system in use and internationally recognised, whereas MarkII, like other older systems, is not recognised anywhere, and, even in the UK is in decline if not actually dormant, so this debate is already over.Historically, from my limited understanding of the situation, it seems that originally there were upwards of 35 variants of function point style metrics until the ISO developed criteria for a acceptable solution, ISO 14143: Parts 1 to 5 (1995-2002):The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK. The aim was to improve on Albrecht's size index (IFPUG FPA)As stated in many sources, the most important feature...(related: Software)
Estore Advantage ? Extending Microsoft Econnect For Mbs Great Plains
eStore Advantage allows front-office applications to communicate with back-office business environments. It has a built-in support for electronic payment processing, and serves as a core integration platform for Nodus Technologies front-to-back office connectivity suites including RMS and CRM Advantage.eStore Advantage for Microsoft Business Solutions-Great Plains leverages Microsoft eConne...(related: Software)
Upgrading Great Plains Dexterity Customization ? Switching To New Technologies: Sql, Crystal, Econne
1. Replace Dexterity cursor with SQL Stored Procedure
Dexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Dexterity data retrieving mechanism is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, however a little bit slower to cursors in Transact SQL. Long ranges in Dexterity are good candidates for replacement by SQL stored procedures with update clause.
For example, consider to replace following Dexterity code:
Range clear SOP_HDR_WORK.
Clear 'SOP Type' of table SOP_HDR_WORK.
Clea...(related: Software)
Groupware: Answers The 5 Questions Of Document Collaboration
Every organization which creates collaborative documents, whether they are budgets, presentations, reports, spreadsheets, or other documents recognizes that collaborative efforts are requirement. That collaboration always forces the 5 eternal document collaboration questions: Who? What? Where? When? How? The reason I refer to them as eternal is that ...(related: Software)
Dont Choose Adobe When Working With Pdf
While Adobe is the most known maker of PDF tools, your business will be much better off, if you select third party tools to work with PDF documents.ABC Amber PDF converterPriced at eleven dollars, this tool may very well be the cheapest PDF software on the planet. ABC Amber PDF Converter is a powerful tool which allows you to convert PDF to any document format (HTML, CH...(related: Software)
Is Your Computer Sick?
Viruses and spyware usually show up on your computer one of two ways.Either they invade your system with a frontal assault like the Huns attacking the Romans, or they sneak in a back door like a cat burglar.Either way, once a virus or piece of spyware gets on your system, getting it off can rate harder than curing a severe case of trench foot!Viruses, malicious programs designed to disrupt normal computing, and spyware, programs intended to literally "spy" on your activities, can enter your computer a number of ways.Most commonly they enter your system through an email attachment, by sharing files with an infected computer by disk, as a "ride along" with a 3rd party program...(related: Software)
Professional Xp Style Icons In Software And Website Development
Using professional icons in your application or website can bring a modern and aesthetically pleasing appearance to your product or service. This will not only help you to attract potential customers but also give you that "edge" you need to stand out from your competitors. In an internet age, it's important that your interface looks prof...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software