1

When records are written to the Transaction log, the initial 'Create' record remains. But as you update statuses on a record, the full log is lost. This causes problems with the ability to fully audit the history of a transaction. When you create a new Case, the Transaction log will show a record written to this table for the Case being created (note the Action = Create). When you change the status of the Case to 'In process,' the Transaction log will show a record written to this table for the Case status being updated (note the Action = Update). Then when you change the status of the Case to 'Closed,' the Transaction log will show the second record that was written to the log has been overwritten. So the record of who & when the Case was moved to 'In process' has been completely lost. This has the potential to cause an issue when auditing. Ideally the Transaction log should keep record of all Updates separately, rather than changing the existing record as a Case (for example) moves through various statuses.

STATUS DETAILS
Needs Votes