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.
Goodluck!
Note: I'll see if there's a need for another Part in FI, otherwise Part 3 will be more on SAP SD.
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Wednesday, June 04, 2014
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...