Wednesday, June 04, 2014

Microsoft Dynamics to SAP ECC - Part 2

As promised, I'm posting Part 2 of the Dynamics GP to SAP migration.

Since my last post we've done a lot of cleansing to the GP data. Some of the ETL processes we ran include:

- Master data including GL accounts, Profit Center, Cost Center, Employees, Vendors and others
- Vendor and Customer addresses including multiple addresses for Vendor Partner functions
- Any Tax-related fields including 1099, GST, etc.
- Hierarchy if any (can be messy)
- Open Balances for General Ledger, Accounts Receivable, Accounts Payable and Fixed Assets

Lastly, I consider my SQL scripting decent but get a really good one as you'll need to create lines of code and SP for your ETL.


Note: I'll see if there's a need for another Part in FI, otherwise Part 3 will be more on SAP SD.


Unknown said...

We are migrating from Microsoft Dynamics GP to SAP your article has helped a lot. However I needed ask a few questions
How can i contact privately?

Anonymous said...
This comment has been removed by a blog administrator.
duke said...
This comment has been removed by the author.
advertising management software said...

Hello , thanks for brilliant article, your blog is very helpful for me :)

microsoft dynamics ax said...

Are you getting back to SAP? Why? Aren't you satisfied with MS Dynamics? Sap seems to have longer implementation time. What made you change your mind?

emarks said...


we offers clients access to the most extensive and most accurate New York Business Databases of business and consumer information.

ERP said...

oracle fusion financials online training at is worlds best online training center.
we have excelled in knowledge sharing through online. we have almost all country students as our subscribers for online course. 10+ years of experience we have in handling various ascent people.we have user friendly website where you will be provided with all the required details and Self-paced DEMO videos.

Oracle Fusion cloud HCM Online Training

Sophia said...

Nice blog, Our database can help you to target prospects to get high response rates and guaranteed results. Now reach and engage with your targeted audience by ERP Users Email List and stay connected with IT Technology in USA, Canada, UK, Australia and Europe.

soumya said...

Thanks for sharing valuable information with us, keep share more updates on MSBI Online Training Bangalore

piping design course said...

Good Information
"Sanjary Academy provides excellent training for Piping design course. Best Piping Design Training Institute in Hyderabad,
Telangana. We have offer professional Engineering Course like Piping Design Course,QA / QC Course,document Controller
course,pressure Vessel Design Course, Welding Inspector Course, Quality Management Course, #Safety officer course."
Piping Design Course
Piping Design Course in India­
Piping Design Course in Hyderabad
Welding Inspector Course
Quality Management Course
Quality Management Course in india
Safety officer course

piping design course said...

Thanks for sharing information
We are the best piping design course in Hyderabad, India. Sanjary academy Offers Piping Design Course and Best Piping Design Training Institute in Hyderabad. Piping Design Institute in India Piping Design Engineering.
Piping Design Course
Piping Design Course in india
Piping Design Course in hyderabad