Dynamics AX Importing Master Records and Transactions from Legacy Accounting

image_4ec9bb873ae4be3f32cb82b409fb3c0d

General advice is try to make data massage and conversion project scope minimal. In the case of AX data conversion is recommended to be minimal as well. Consider keeping your legacy accounting open for inquires. And in your new Corporate ERP system enter GL beginning balances, import customers, vendors, employees, inventory items and start using the new accounting on the first day of new fiscal period. In certain situations this advice doesn’t work and you have to dive into full scale historical transactions cleansing, massage and import project. Importing data into AX is not an easy routine, we recommend you to read Microsoft whitepaper, where integration tools are compared. However even more challenging for AX developer might be the project to export data from legacy accounting application. It is possible to switch to AX from large scale ERP and MRP packages, such as Oracle EBusiness Suite, PeopleSoft. We see more cases where customers are migrating from mid-market accounting packages, such as old Great Plains Dynamics, Great Plains DOS version, QuickBooks. There were some requests to migrate from SAP Business One, but this small business package seems to be too new on the US market to be retired. Sometimes customer has its own proprietary accounting system, programmed in something like MS Access, FoxPro. Let’s take and look at data export technologies:

1. Two methods to extract data from legacy ERP. The first one is to print reports into text files and then cleanse the data in MS Excel or in custom MS SQL Server Database (use Data Import Wizard or SSIS). And the second method is exporting via ODBC connection into text files go from there. If you know how to stretch ODBC connection to let’s say Great Plains Dynamics Btrieve database, this doesn’t necessary mean that this is the best method to do the job. If all you need to do is exporting customers and their addresses, then this routine might be quickly accomplished in so-called Report Writer custom reports. So, management homework seems to be required to avoid the situation when you are trapped in data conversion limbo. Let’s take a look now at the popular legacy accounting brands

2. QuickBooks. It is not the easiest one to convert, however migration route is usually via printing report into text file and further processing it in Excel or via importing into MS SQL Server custom table and then creating SQL View. In the View itself you have to weed out blank lines, page numbers, header, footer, etc. Expect several attempts, as we often see problems, associated with human entry errors. For example GL account is missing and you have to enter it and redo GL historical transactions import

3. Old versions of Great Plains Dynamics on Btrieve/Pervasive SQL: 7.5, 7.0, 6.0, 5.5, 5.0, 4.0. It is reasonably simple to establish ODBC connection and pull out records from GP tables to something like Microsoft Access or SQL Linked Server. You will need so-called Data Definition Files (DDF) in order to create ODBC System DSN. Btrieve based Great Plains Dynamics had GenDDF.set file. This file could be captured by mice, dragged and dropped at Dynamics.exe file to launch DDF files generation. When DDF files are produced you need to copy them into company folder root. You can read technical manuals in PDF directly on your legacy Great Plains user workstation folder, so this publication is for orientation only. GP tables structure could be reviewed in user interface: Tools -> Resource Description -> Tables

4. Great Plains Accounting for DOS, Mac or Windows: 9.5, 9.2 and earlier. It is also possible to establish ODBC connection to Btrieve based GPA data. However there is a complication, related to the data storage manner. GPA stored several tables in one Btrieve file. In this scenario some records, read from the table seem to be legitimate. Others seem to be filled with unreadable characters (because different table stores its records in the same file and its structure is different). Great Plains Accounting for DOS, Windows or Mac data migration often requires external consultant help

5. SAP Business One. As it is typically hosted in Microsoft SQL Server you can consider pulling records directly from original tables. If in menu you select show -> system information and then pull SB1 form – field and table name will be shown in the low left part of the form. SAP BO is also open to exporting most of its reports and custom queries into MS Excel

6. In-house programmed legacy accounting packages. Each one requires individual consideration. However DB platforms are usually easier for data export and table structure is often simple and self-explanatory

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


Matching School Ads
  • Online degrees offered include BA in Accounting, BA in Business Administration, MBA, and more.
  • Business students may be eligible for scholarships such as the Entrepreneurship Scholarship.
  • Courses help students develop knowledge of marketing, accounting, economic principles, and financial management.
  • Business Administration students can specialize in areas such as Entrepreneurship, Finance, and Project Management.

Programs:

  • BA/Accounting
  • BA/Consumer and Family Financial Services
  • BA/Finance
  • And more...
  • Ranked among the Best Online Bachelor’s Programs by U.S. News and World Report in 2015.
  • Ranked among the Best Online MBA Programs by U.S. News and World Report in 2015.
  • Founded in 1890, it has a campus in Waterbury, CT and offers online degree program in eight-week modules, six times a year.
  • About 800 students are enrolled at the main campus, and about half of them commute.
  • Online courses make it possible for students to earn a bachelor’s degree in as little as 18 months and a master’s degree in 14-24 months.

Programs:

  • B.S. in Accounting
  • B.S. in Business Administration / Accounting
  • B.S. in Finance
  • And more...
  • Our top-ranking program blends modern business theory with real-world experience
  • Institutionally accredited by SACSCOC with ACBSP graduate business program accreditation
  • High-quality, Christ-centered education with online and select on-campus & evening courses
  • Qualifying bachelor's students can transfer up to 90 credit hours into their degree program
  • 86% of Regent students receive some form of financial aid

Programs:

  • Bachelor of Science in Accounting
  • Bachelor of Science in Business - Accounting
  • Earn Your Bachelor's Degree in Business with GCU's Colangelo College of Business!
  • Emphases: Accounting, Applied Mgmt, Business Admin, Business Mgmt, Finance and Economics, Marketing & more.
  • Develop and refine skills in core areas such as economics, accounting, marketing, statistics, org. behavior, and legal and ethical issues.
  • Serving undergraduates who are preparing to initiate careers & working professionals who are seeking to develop their careers further.
  • Accredited by the Accreditation Council for Business Schools & Programs (ACBSP).

Programs:

  • B.S. in Accounting
  • B.S. in Finance and Economics
  • Degrees offered include Bachelor of Science in Accounting, Bachelor of Science in Business Administration, and Master of Business Administration.
  • Students are instructed in relevant business skills like communication, mathematics, and management.
  • Coursework emphasizes the development of project management, communication, decision-making, and problem-solving skills.
  • Flexible, 100% online and campus based programs available.

Programs:

  • BS in Accounting - Public Accountancy
  • BS in Accounting
  • BS in Accounting - Managerial Accountancy
  • And more...

CTU Classes Are As Close As The Mobile App.
Take classes with the help of your smartphone, tablet or laptop. CTU’s online bachelor’s programs were ranked among the Best Online Bachelor’s Programs by U.S. News & World Report.

Programs:

  • Bachelor of Science in Accounting
  • Bachelor of Science in Business Administration - Finance

You’re serious about success. With your busy schedule and the desire to move your career forward, you can earn an accredited associate, bachelors or master’s degree at a pace that works for you anywhere, anytime, 24/7.

At AIU, the Serious U, you can get started to get ahead.

Programs:

  • Bachelor of Accounting
  • Bachelor's (BBA) - Accounting
  • Bachelor's (BBA) - Finance

100% Online & No Standardized Testing

We are committed to helping you achieve your goals and complete your degree as quickly as possible.

Programs:

  • BS in Business - Finance
Get the hands-on training and skills it takes to succeed with Ashworth College, a respected, worldwide leader in distance education. Study at the times and places most convenient for you.

Programs:

  • Payroll Clerk
  • Find Online Schools. 100% Online Accredited Courses
  • Get Matched to Programs In A Few Clicks!
  • Earn an Affordable Degree from Home at your own pace
  • Get College info today. Its Free and Easy!

Programs:



Matching School Ads
  • Fortis offers nursing programs including ADN, PN, BSN degrees, and more
  • 40+ schools in 15 states including Florida, Arizona, Ohio, and Virginia
  • All colleges are accredited by ABHES, ACCSC, ACICS, or other accrediting bodies
  • Fortis Online serves benefits to US military service members
  • Grants & scholarship aid may be available for qualifying students

Programs:

  • Registered Nurse to Bachelor of Science in Nursing
  • Associate Degree in Nursing
  • Practical Nursing
  • And more...
Locations:  Grand Prairie

Making the decision to earn your degree and pursue your career goals could be the best decision you ever make. Enroll at ECPI University and you’ll join a collaborative and fostering learning environment, surrounded by faculty and staff who are there to support you through the entire process.


What sets ECPI University apart? Just ask the employers who hire our graduates. Since 1966, more than 3,800 employers have looked to ECPI for talented professionals who are capable of entering the workplace and doing the job right on the very first day. That’s because our curriculum is designed to meet the needs of today’s highly-specialized job market.

 

What Are You Waiting For?

Programs:

  • Practical Nursing - Diploma
Locations:  Manassas
  • RNs, ready to take your nursing career to the next level? Earn your BSN online with GCU.
  • The baccalaureate degree in nursing and master's degree in nursing at GCU are accredited by the Commission on Collegiate Nursing Education
  • GCU's courses are taught by practicing nurses and experts who share knowledge and experience in areas of clinical patient care, healthcare management and professional nursing practice and leadership.
  • Gain a comprehensive view of patient care principles to strengthen your ability to care for patients and take on hospital responsibilities with your BSN.
  • Focus on family-centered healthcare, health history and physical examinations, applied health care statistics, nursing leadership and development and more.

Programs:

  • B.S. in Nursing (Registered Nurse - R.N. to B.S.N)

Designed with the needs of working adult students in mind, South University, Online Programs is built on the similar curriculum offered at South University's campus locations. As a student at South University, Online Programs you will receive the same quality instruction, variety of learning options and level of service found at the campus locations.

Programs:

  • Nursing (RN to BSN)

Regent University prepares students with the knowledge to excel and the faith to live with purpose. Our 20,000 alumni, from more than 110 countries, are changing the world as accomplished professionals. Named a top-15 school nationally for online bachelor's programs (U.S. News & World Report, 2015), Regent is among the most affordable undergraduate Christian colleges (CCCU 2015). Fully accredited, challenging programs are available online and on campus. New classes begin every eight weeks.

Programs:

  • Bachelor of Science in Nursing (RN to BSN)

CTU Classes Are As Close As The Mobile App.
Take classes with the help of your smartphone, tablet or laptop. CTU’s online bachelor’s programs were ranked among the Best Online Bachelor’s Programs by U.S. News & World Report.

Programs:

  • Bachelor of Science in Nursing (RN to BSN completion)

100% Online & No Standardized Testing

We are committed to helping you achieve your goals and complete your degree as quickly as possible.

Programs:

  • BS in Nursing (RN to BSN)
  • Find Online Schools. 100% Online Accredited Courses
  • Get Matched to Programs In A Few Clicks!
  • Earn an Affordable Degree from Home at your own pace
  • Get College info today. Its Free and Easy!

Programs:

  • Interested in Helping Others? Get Educated in the Nursing Field
  • Build the Capabilities and Connections to Power Your Future
  • Nursing, RN to BSN, LVN/LPN Degree Programs and More From Top Colleges that Fit Your Needs
  • Find Schools Online or Near You & Get Info for FREE Today!

Programs: