Thursday, 22 May 2014

Migrating from GP to AX using DIEF [AX 2012]

Today I found a hidden gem that I never noticed. It is actually in AX 2012 R2 CU7 and also in AX R3 (unchanged from the look of it).

I was going to through some DMF classes and I stumbled across this interesting class DMFDefaultMappingGP.

2014-05-22_2042

It has a number of select statements you can use to query GP to import into AX. Naming of the fields seem to have been done nicely, it should automatically map to the staging automaticly. I found nothing that calls these methods – only way I can think of is to copy the string and paste it into DIEF query. You will see some of the queries like InventTable and Project are empty. Either Microsoft started this and stopped after a while.

I can see the vision Microsoft started off here.

I will do some experimenting and see how it works out.

4 comments:

Anonymous said...

Have you looked if perhaps they have snuck a default NAV class in there as well ?

Munib Ahmed said...

Nah. This was it.
It only had the GP class.

Anonymous said...

I also have to do a GP to AX 2012 R3 data conversion. These select statements will help with mapping, but I think there will be more issues. Have you done this migration yet? If so do you have any tips? Which tools do you recommend?

Thanks!

Munib Ahmed said...

Not done it myself. Just found it interesting.