Greetings all,
We are performing in-house migration from MS DGP to MS D365. I am in charge of the automation process. I have SQL queries written down, and have extracted all type of data including financial, HR, inventory etc from GP tables.
Now I am trying to export blank data entities from DMF Export Projects on D365, so I can edit the Excel files with GP data, then reimport into D365. Currently facing issues with correct mapping of entities (there is a V2, V3 in some cases).
I would export this, read files via Python and map data from SQL output into the files.
If any developers or community members are interested in automation and development of a nice smooth trick that can solve all data import/export flows; I am seeking guidance on the correct entities, their sequence, and all necessary columns for this process.