Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

How it works...

We saw that there is a lot of automation when we tested editing the odometer value and looked at the results in SQL. The system created a new version on every save (should anything have changed), and the fact the user has no control over this makes it great for auditing changes. It can also add significant overhead, depending on the volume.

A customer or consultant might request that date-time effectiveness is implemented on a table, and the request might seem reasonable if the requirement is to track a history of changes that have been made to a record. We also need to consider that it also adds complications to the code that we write and a significant overhead to the database – every change has to update the ValidTo field ...