Forum Discussion
Initial data load for incremental refresh on a nearly useless datetime column
JTsoi I would look into writing an extension/script that updates your system last modified dates in Dynamics 365 to something reasonable.
Hi JTsoi,
I agree with GeraldGEmerick. You want to get this cleaned up in Dynamics directly. Anything you do to try and resolve this externally is going to be a patch work solution at best.
Is the old ERP still up? Are you still in progress of the transition or is the transition over now?
The way I would approach this is to wipe it all out of D365 and do the import from the old system again, but this time have some ETL step that sets that modified date to something reasonable.
JTsoi I would look into writing an extension/script that updates your system last modified dates in Dynamics 365 to something reasonable.
Hi GeraldGEmerick,
I did consider that, but unfortunately the [systemLastModified] in Dynamics 365 is a system field that is read-only, so modifying them directly is out of my reach for now. I did have a a slightly insane moment of thinking about writing a script to loop through every single financial transaction in our system (around 4 - 5 million rows of g/l entries and 60000-ish budget entries) just to make an empty update just to force the systemLastModified field to change, but I'm going to leave that as a last resort, it feels a rather bit heavy of a hammer to use for this problem.
