Project Accounting Software

Archive for February, 2011

What are the big 3 public accounting firms?

February 28th, 2011 | Author: admin

well this is extra credit for my accounting project and i need help answering the prompt
here it is ” List the 3 big Public Accounting Firms. Describe the difference between public and private accounting firms”
please help me out, your services will be greatly appreciated lol

Posted in Project Accounting | Tags: Accounting, Firms, Public | 2 Comments »

NII Holdings Delivers Outstanding Performance for 2010

February 24th, 2011 | Author: admin

NII Holdings Delivers Outstanding Performance for 2010
RESTON, Va., Feb. 24, 2011 /PRNewswire/ — Full year 2010 net subscriber additions of 1,641,000 resulting in an ending subscriber base of 9.0 million – a 22% increase over the subscriber base at the end of 2009. Net subscriber additions of 436,000 in the fourth quarter . Full year 2010 consolidated operating revenues of $ 5.6 billion – a 27% increase over 2009. Consolidated fourth quarter …

myGPcloud Mobile for Windows Phone 7

February 22nd, 2011 | Author: admin

This video explains the new mobile application for myGPcloud on Windows Phone 7. For more detail visit this site: mygpcloud.com

Posted in Project Accounting | Tags: Mobile, myGPcloud, phone, windows | No Comments »

Barclays’ accounting birds nest shows shareholders should keep up pressure on pay

February 20th, 2011 | Author: admin

Barclays’ accounting birds nest shows shareholders should keep up pressure on pay
Before banker bashing and project Merlin, bonuses were a simple, if controversial, matter. Now they are a complex and controversial matter. Progress?

Read more on AFP Telegraph Finance News via Yahoo! UK & Ireland Finance

Posted in Project Accounting | Tags: Accounting, Barclays', birds, keep, nest, pressure, shareholders, should, shows | No Comments »

Migrating Data to Dynamics GP from Your Old Accounting

February 18th, 2011 | Author: admin

Migrating Data to Dynamics GP from Your Old Accounting

Free Online Articles Directory

Why Submit Articles?
Top Authors
Top Articles
FAQ
ABAnswers

Publish Article

0 && $.browser.msie ) {
var ie_version = parseInt($.browser.version);
if(ie_version Login

Login via

Register
Hello
My Home
Sign Out

Email

Password

Remember me?
Lost Password?

Home Page > Computers > Software > Migrating Data to Dynamics GP from Your Old Accounting

Migrating Data to Dynamics GP from Your Old Accounting

Edit Article |

Posted: Jan 26, 2011 |Comments: 0
|

]]>

Data conversion should be reviewed first, where you should pose such questions as conversion scope, budget, availability of the old system for data querying. In general, the lesser is the scope – the less is the chance to get some data inconsistency issues discovered for the converted data set. Plus modest migration scope also means lower consulting cost. If you are large organization, you may need reasonable amount of historical data, such as General Ledger posted entries for the previous year, compressed into monthly summaries. But, for smaller organization it is likely OK to keep the old accounting somewhere on the corner of your office, in case if old customer calls you or if there is the concern to face audit down the road. Now, let’s take a look at how conversion is typically done:

1. Exporting data from your legacy accounting. There are several options. One of the most popular is printing reports into the text files, then import each text file as custom table into MS SQL Server database, where you may consider to create view to join several tables (for example Sales document header and lines) and then base Integration Manager integration on the SQL view. You can also try to get ODBC connection to the old accounting database, however this method might theoretically be possible, however the connection might be not too reliable and it is easy just to export tables into the text files, MS Excel or Access. But, if you are downsizing and your old accounting sits in reliable and powerful DB platform, such as Oracle, MySQL/PHP/Linux, Pervasive SQL – you may establish ODBC connection there or simply create cross platform SQL view to join records in Oracle and MS SQL Server hosted tables

2. Migration tools. If your legacy accounting was Great Plains Software associated, for example Small Business Financials, Great Plains Select on Pervasive SQL 2000 or Ctree, Great Plains on DOS, Windows or Mac – there are migration tools to consider. These cases are typically considered as upgrades, not conversions. There are also migration tools for non-GPS ERP and small business accounting packages, QuickBooks for example

3. Data Massage. There are often exceptions, one of them might be the desire to do GL chart of accounts revision. If you would like to do something like this – you should create accounts mapping worksheet for conversion consultant. This conversion sheet goes into custom table in MS SQL Server and it is one of the parts in the integration SQL View. If you Integration query base is text file, printed as report, there is the need to weed out all the empty lines, page numbers, report headers, and other non-structured lines. This could be achieved in Simple ODBC query over Microsoft Text Driver. We often here the following question – my data is in Excel and several documents are sitting on the same row in five columns – how do I split them into individual lines for the Integration Manager. The answer is use Union statement, which is available for Advanced ODBC working over CSV text file (Excel could be saved in CSV format), and each select statement in the Union should be responsible for the specific one of these five columns

4. Now the preferred conversion tools. For custom conversions we recommend Integration Manager only, as this tool validates business logic and doesn’t allow you to cause data compromise. We discourage you from feeding the data directly into the Great Plains system or company tables, where you are completely open to cause data compromise

5. Second Opinion in the case when your data conversion failed. You should be aware that there are consultants out there ready to help. There is no need to blame your current VAR, as data import is known to be risky, especially when you are trying to convert “everything”, and your consulting firm has limited experience

6. eConnect. This tools is rather for ongoing integrations, such as the interface with ecommerce shopping cart, Warehouse Management, POS systems, EDI. You, as MS Visual Studio C# or VB developer might be too excited about eConnect SDK. In fact – you already have the same integration power and connectors in Integration Manager, where it is much easier to do the conversion

7. Migrating away from Intellisol Advanced Purchase Order Processing. There is migration tool, available from MS Business Solutions. Most of the conversions were done for Great Pains version 7.5 and 8.0. If you have been used Intellisol Project Accounting, we are not aware about migration tool to GP PA (incorporated former MatchData PA), likely you should consider migration via Integration Manager

8. Migrating away from Dynamics GP or older versions of Great Plains Dynamics. In this scenario we are more than happy to export requested data into the format you choose: MS Access, Text File (CSV, Tab Delimited), MS Excel, XML

Retrieved from “http://www.articlesbase.com/software-articles/migrating-data-to-dynamics-gp-from-your-old-accounting-4112769.html”

(ArticlesBase SC #4112769)

Submit articles to Articlesbase.com, and watch your traffic increase. Click here to make it happen.
Liked this article? Click here to publish it on your website or blog, it’s free and easy!

Andrew Karasev -
About the Author:

Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space

]]>

Questions and Answers

Ask our experts your Software related questions here…

Ask

200 Characters left

What are the great plains and where are they located ?
Does using gps on iphone use data?

Rate this Article

1
2
3
4
5

vote(s)
0 vote(s)

Feedback
RSS
Print
Email
Re-Publish

Source: http://www.articlesbase.com/software-articles/migrating-data-to-dynamics-gp-from-your-old-accounting-4112769.html

Article Tags:
dynamics gp, great plains dexterity, extender

Related Articles

Latest Software Articles
More from Andrew Karasev

An Interview with Facebook’s VP Chris Cox

Molly Wood talks to Facebook’s vice president of product about privacy, opt-in, the future of the social network, and whether the company is selling data to advertisers. Tune in! (20:55)

Check Your Data Usage on Your iPhone

Worried about the new capped data plans for iPhone and iPad? They may actually save you money. Here’s how to check. (02:46)

How to Delete Personal Data Off a Game Console

If you’re getting rid of your Xbox, Wii, or PS3, make sure you delete your personal data first! (04:23)

Travis Pastrana Climbs a Mountain

Autoweek News Breake 09.10.2010: Travis Pastrana climbs the Mount Washington Road Run, the Panamera marks one year, Motor Vehicle Crash Deaths fall and and 5 year old rides his scooter on the highway. (03:21)

Hydrogen Fuel Cells Not Holy Grail for Energy

Griffith: Hydrogen Fuel Cells Not ‘Holy Grail’ for Energy
The Long Now Foundation – Contemporary Jewish Museum
Long Conversation, an epic relay of one-to-one conversations among some of the Bay Area’s most interesting minds, took place over 6 hours in San Francisco on Saturday October 16, 02010. Interpreting the Long Conversation in real time was a data visualization performance by Sosolimited; an art and technology studio out of M.I.T.Long Conversation was presented with a live performance of 1 (03:30)

Microsoft Dynamics Gp Great Plains East European Options Overview for Consultant

Great Plains Software Dynamics and eEnterprise were popular in Europe, prior to Microsoft acquisition of Great Plains Software, and since then Microsoft acquired also such ERP as Navision with strong European market presence. In those days of Navision purchase, Microsoft Business Solutions made a decision to market Navision, or current name Dynamics NAV in Europe and sort of deemphasize Dynamics GP Great Plains

Special Offers

Categories

Recent Posts

Archive for February, 2011

Archives

Tag Cloud

Blogroll