Hi Mythe,
Thanks for the clarifications.. I don't think there is any path to migrate easily historical data from GP to Dyn 365 F&O.. I know Microsoft has some process to go to 365 BC, but I'm not positive it's the same for F&O.
It's not because the extended support for GP 2013 ends at some point in time that you can't keep it running.. Of course, 7 years is a long time and the current platform GP 2013 is running on today may well be depracated and usupported too in a few years (Windows & SQL).
This doens't mean your MR will not work though. One way you could handle this is to peform a data dump of the Financial historical data of GP and try to build an indepedant data cube, though from the legal perspective it would not longer come from the ERP system itself, so you may want to keep a running copy of your old GP as long as it's required by law.
GP used to have built-in Excel Analysis cubes, but I'm not sure that would the best way to run financial reports. If it would be me, I'd just keep the current setup and save it as long you can after you migrated the company to D365 F&O. BTW, you can export all your historical MR 2012 reports out of MR into Excel files and keep those for the duration requred by law.. I know companies that don't keep the MR reports they generate, as it would make the database grow a lot over the time. They periodically run some clean-up on the historical reports, but keep a copy as Excel file to archive with other financial documents.
Hope this helps.
